Tuesday, February 14, 2012

CREATE DATABASE failed

Does any body seen this message before?
Microsoft SQL-DMO (ODBC SQLState: 42000)
Error 1807: Could not obtain exclusive lock on database 'MODEL'. Retry the
operation later.
CREATE DATABASE failed. Some file names listed could not be created. Check
previous errors.
OK
Hi,
This error will occur if there is a user connected to model database. Run
sp_who to determine what connections are using model.
Identify those connetions and kill the SPID and try to create database
again.
Thanks
Hari
SQL Server MVP
"SQLCluster" <SQLCluster@.discussions.microsoft.com> wrote in message
news:24E3473B-9AD3-43C9-A668-07A7653DF676@.microsoft.com...
> Does any body seen this message before?
> --
> Microsoft SQL-DMO (ODBC SQLState: 42000)
> --
> Error 1807: Could not obtain exclusive lock on database 'MODEL'. Retry the
> operation later.
> CREATE DATABASE failed. Some file names listed could not be created. Check
> previous errors.
> --
> OK
> --
>

No comments:

Post a Comment