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 |
|
maquaro
Starting Member
6 Posts |
 Posted - 2005-05-20 : 12:24:16
|
| I can't figure out how to stop 2 databases that have been restoring since yesterday and just report Loading next to their names in EM.I have tried restarting the sql service, but the same out come.I should have just attempted 1 restore statement at a time. I got over zealous and ran 2 restore statements at the same time. Both are only a restore of a full backup, no diffs or logs applied. Both also have NoRecovery enabled.Thanks. |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-05-20 : 17:14:54
|
| You restarted the SQL Service while they were restoring???You will need to drop the databases, delete the file, then restore the databases from backup. Sucks!!!MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-05-22 : 22:35:23
|
| loading may mean you are restoring with norecoveryhave you tried restoring again on the DBs with recovery?HTH--------------------keeping it simple... |
|
|
|
|
|
|
Stopping a restore that has hung