Tuesday, October 23, 2012

MS SQL Restore failed ...Exclusive access could not be obtained


So, sometimes you'll encounter this when you're trying to restore a SQL DB.  Usually killing the associated schedule server and service shell resolves this issue.  But you may have a query window associated with the DB or some other process that isn't apparent.  In this case, you can open up a query window for the "master" DB, and type:


sp_who

and then use the kill command with the process id

kill 51

No comments:

Post a Comment