Forum Discussion
paul_scroce
12 years agoFrequent Contributor
If you are restoring an SQL database try this step to disconnect all users
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=170474
Step (3): Disconnect all users
If you are restoring over an existing database make sure all currently connected users are disconnected
(If you are restoring to create a brand new database skip this step)
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=170474
Step (3): Disconnect all users
If you are restoring over an existing database make sure all currently connected users are disconnected
(If you are restoring to create a brand new database skip this step)
ALTER DATABASE MyTargetDatabaseName SET SINGLE_USER WITH ROLLBACK IMMEDIATE