Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Towards the innovative SQL ideas
Browse by Tags · View All
ms sql server 119
ms sql 118
sql server 116
sql 115
database 102
tsql 81
#SQL Server 78
t-sql 75
#sql 71
sql server general 67

Archive · View All
April 2011 14
July 2011 12
May 2011 12
August 2011 11
June 2011 10
September 2011 8
December 2011 6
November 2011 6
June 2013 5
April 2013 5

Could not obtain exclusive lock on database 'model' - SQL Server

Jul 9 2011 1:05AM by Paresh Prajapati   

Problem:
One day when i was creating a new database, i was notified as "Could not obtain exclusive lock on database 'model'. Retry the operation later" and i could not able to sucees to created that database.

The error looks,

TITLE: Microsoft SQL Server Management Studio

Create failed for Database 'NewDatabase'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22+((SQL_PreRelease).080709-1414+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476

ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

 Could not obtain exclusive lock on database 'model'. Retry the operation later. CREATE DATABASE failed. Some file names listed could not be created. Check related errors. (Microsoft SQL Server, Error: 1807) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.1600&EvtSrc=MSSQLServer&EvtID=1807&LinkId=20476


I have the checked any open transactions which have locked the "Model" database, But no any processes were locked for this database.

Everything were OK with this database. Finally i have checked the processes or connections to this databases in process, And one connection was from Management studio.

The script to find connection of "Model" database.
SELECT 
* 
FROM SYS.SYSPROCESSES
where dbid  = DB_ID('model')

GO

Solution:
After disconnecting from "Model" database i have tried one more time to create a new database.

Then i was able to sucessfully create it. This is becuase of new database is created from "Model" database.
Let me share your experience if you got this errors and what you did for the resolutaion for the same. Also share the reason for this type of errors.

Tags: sql, sql server, ms sql, ms sql server, #SQL Server, mssql, #sql, database, sql server general, sql errors, SQL Server Problems,


Paresh Prajapati
6 · 22% · 7044
3 Readers Liked this
Paresh Prajapati Liked this on 11/17/2011 12:04:00 AM
Profile · Blog · Facebook · Twitter
Nirav Liked this on 3/28/2012 1:12:00 AM
Profile · Blog · Facebook · Twitter
kavan dhruv Liked this on 11/12/2012 2:18:00 AM
Profile · Facebook · Twitter
3
Liked
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

Your Comment


Sign Up or Login to post a comment.

"Could not obtain exclusive lock on database 'model' - SQL Server" rated 5 out of 5 by 3 readers
Could not obtain exclusive lock on database 'model' - SQL Server , 5.0 out of 5 based on 3 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]