Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2002
    Posts
    94

    Unanswered: database recovery

    Is it possible to ignore / skip database recovery at SQL server startup?

    Please reply.
    Ram.

  2. #2
    Join Date
    Jul 2002
    Location
    IA
    Posts
    28
    If you restore master it wouldn't know about the user databases until you re-attached them.

    If move or rename the .mdf and .ldf files it would error out.

    What are you trying to do?
    Thanks,
    Jason

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Why do you want to do so, let SQL work it out to keep the consistency.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    About the best you yourself can do is set the Recovery Interval to be a bit lower (one minute, or so), but this will have an effect of lowering performance on your system overall. Lowering the Recovery Interval will increase the number of checkpoints that SQL Server is issuing.

    After that, you have to try to be sure that you are not restarting the SQL Server service midway through a large transaction. An old rule of thumb was that it took SQL Server almost twice as long to back oout of a transaction as it took to get this far through. So, if you have been waiting staring at Query Analyzer for 20 minutes, you may have to wait up to 40 minutes after you hit "cancel query". Same could apply to restarting the SQL Service. Have you poked around to see if there are any extra-long/piggish transactions that someone may have put in a "begin/commit transaction"?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •