Post reply

starting SQL Server without recovery

  • December 20, 2002 at 8:49 am

    #159311

    I had a database crash. It is a developement environment so I don't care about the data. I know that everytime I start SQL Server after a crash it goes into this recovery mode that take almost a day to finish. I want to avoid this recovery mode and just reload the trashed database from a backup. Is this possible?

  • December 20, 2002 at 4:25 pm

    #444973

    Couple options. One is to start in single user mode, then just drop the db you're concerned with. You can also use (havent tested, but I think ok) trace flag 3607 to skip recovery, 3608 to skip recovery for all but master.

    Recovery time usually isnt anywhere near that long, you might want to look at your checkpoint interval.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

    Andy
    Connect with me on LinkedIn

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply