database is in use - SQL Server Forums

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]

taniarto
Starting Member

27 Posts

Posted - 2013-03-04 : 21:25:12

Thanks..a lot

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources