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.
| Author |
Topic |
|
AsimKhaliq
Yak Posting Veteran
94 Posts |
 Posted - 2003-11-19 : 14:10:12
|
| HeyI want to restore my database, but I am running my wizard to restore the database it gives an error that database in use. Can anyone help me in restoring the database. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-19 : 14:51:37
|
| You have to KILL all of the spids that are connected to the database in order to perform the restore. Go to the Current Activity window and kill the processes. You should consider putting the database in read-only mode right after so that you have time to get to through the restore wizard screen.Tara |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Database restore Error.