Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 database is in use

Author  Topic 

taniarto
Starting Member

27 Posts

Posted - 2013-03-04 : 02:00:16
Hi all,

I just create a backup syntax, and it's running well. But when I try to restore it again there's a message that the backup cannot be run because database is in use. Does any one can tell me how to disconnect or solving the problem..

thanks

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2013-03-04 : 03:07:26
execute the restore command from other database like master instead of the one you are trying to restore. You can restore the database if you access it.

basically,

use master
restore database . . . .



KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

taniarto
Starting Member

27 Posts

Posted - 2013-03-04 : 21:25:12
Thanks..a lot
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2013-03-05 : 01:50:15
If there are other processes - you can use the KILL command - although check with the users first

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -