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 |
|
DBA007
Posting Yak Master
145 Posts |
 Posted - 2010-10-26 : 10:48:55
|
| how to delete a db which is in restoring state,this is not part of mirroring |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2010-10-26 : 15:33:46
|
| why you are deleting db?you should have valid backup if you need to restore.If you don't need that db then use this command:restore database <db name> with recoverygodrop database <db name>go |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2010-10-26 : 18:32:19
|
| Yes, Tara is right, thanks for clarification. |
|
|
|
|
|
|
restoremode