setting to exclusive mode for restore (or other operations)

When attempting to restore a database you'll often get an error saying you must be in exclusive mode...

When attempting to restore a database you'll often get an error saying you must be in exclusive mode...

well, when using the enterprise manager you can right click on the database in the left pane and select properties from the popup menu. Then go to properties and set the mode to single user. This will allow you to run your restore.

Hope someone finds this helpful :)

 

Share this article!

Follow us!

Find more helpful articles: