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 |
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
 Posted - 2008-02-19 : 14:05:13
|
| Say you have a database that had a process run for 2 days in a transaction until if filled the disk. The error causes a rollback (presumable another 2 days). I want to restore from a backup instead of waiting for the rollback to complete. Please to be telling me how to?Jayto here knows when |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-02-19 : 14:50:53
|
| I guess you have already tried something like this:alter database MyDB set offline with rollback immediateand the roll back continued?You could try stopping SQL Server, deleting the database files for the database you are going to restore, and restating SQL Server. The database should be in supect mode when you restart, so you could then drop it.Edit: I hope your database backup is good. The ususal "do this at your own risk" disclaimers apply. And I have never done this!CODO ERGO SUM |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-19 : 22:37:36
|
| Or you can start sql with option to skip db recovery. |
|
|
|
|
|
|
Offline Immediate (I mean right now)