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 |
|
rb1373
Yak Posting Veteran
93 Posts |
 Posted - 2005-03-17 : 11:39:05
|
| I have a DB that is stuck in the loading state. Apparently the BAK file was not ready to be restored. The DB is restored from a job. In the past, the DB returns to normal a normal after a few hours. Can I kill the restore job and try another restore using a different BAK file?Thanks,Ray |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-03-17 : 11:47:23
|
| Post the code of the restore...And what do you mean returns to normal?Brett8-) |
 |
|
|
rb1373
Yak Posting Veteran
93 Posts |
Posted - 2005-03-17 : 13:40:08
|
| The database returned to normal (ie., EM does not show 'Loading) faster than anticipated. Thanks anyway! |
|
|
|
|
|
|
kill restore job?