June 28, 2005 at 7:37 am
Hi , I have a database that is slowly doing a rollback and it has been rolling back for many hours. I would rather drop the database and restore it rather than wait for this to complete. How can I drop it when I can't get it into single_user mode because of the rollback process. This is a development database.
June 28, 2005 at 8:52 am
I wouldn't recommend it, but about the only way to do so is to shut SQL Server down (and it may require a hard shutdown at this point) Once SQL is down, you can delete the data and log file, bring SQL back up and then do your restore.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
June 28, 2005 at 9:53 am
Thanks, actually that's what I did. I shut down sql server, renamed the log file and brought sql back up. Then once it was up the database was marked as suspect and I was able to delete it. Now I can do a restore. Thanks for your help.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply