Monday, May 9, 2011

How to restore a database when the database is in use??

Usually when we are restoring the database in the server.. when the database is in use it will throw the pop up error the database is in use. So inorder to fix that pop up error, do the following..

ALTER DATABASE <DBNAME> 
SET RESTRICTED_USER WITH ROLLBACK IMMEDIATE

No comments:

Post a Comment