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 |
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
 Posted - 2004-01-26 : 19:45:32
|
| If I have a database that is stuck in rollback and I would rather delete it and do a restore. How would I go about this? Also is this a very bad idea?Rollback time est. 3-4 hrsRestore time est. 15 minDanielSQL Server DBA |
|
|
gwhiz
Yak Posting Veteran
78 Posts |
Posted - 2004-01-26 : 20:05:47
|
| Are there other databases on the server? If you have a good backup and there are no other databases on the server you could restart the server and then perform the restore. But I would wait for the rollback. |
 |
|
|
|
|
|
Database stuck in Rollback... ?