Sample Header Ad - 728x90

Could not obtain exclusive lock on database 'model' - who is using it?

10 votes
2 answers
30152 views
when trying to run the following query in order to create a new database: CREATE DATABASE [Lunch] CONTAINMENT = NONE ON PRIMARY ( NAME = N'Lunch', FILENAME = N'E:\Data Files\Lunch.mdf' , SIZE = 110592KB , FILEGROWTH = 1048576KB ), FILEGROUP [DATA] ( NAME = N'Lunch_Data', FILENAME = N'E:\Data Files\Lunch_Data.ndf' , SIZE = 110592KB , FILEGROWTH = 1048576KB ), FILEGROUP [NONCLUSTERED_INDEXES] ( NAME = N'Lunch_nonclusteredindexes', FILENAME = N'E:\Data Files\Lunch_nonclusteredindexes.ndf' , SIZE = 110592KB , FILEGROWTH = 1048576KB ) LOG ON ( NAME = N'Lunch_log', FILENAME = N'F:\logFiles\Lunch_log.ldf' , SIZE = 524288KB , FILEGROWTH = 524288KB ) GO Getting the following error message: > Msg 1807, Level 16, State 3, Line 1 > > Could not obtain exclusive lock on database 'model'. > > Retry the operation later. > > Msg 1802, Level 16, State 4, Line 1 > > CREATE DATABASE failed. > > Some file names listed could not be created. Check related errors. what is using the model database and does not allow me to obtain the exclusive lock?
Asked by Marcello Miorelli (17274 rep)
Sep 5, 2018, 11:53 AM
Last activity: Aug 16, 2022, 06:58 AM