Post reply

Recovery model and Performance

  • August 5, 2010 at 11:36 pm

    #224380

    I am going to install new SQL sever, and i had one question, which recovery model i should use to have best performance. My own answer is SIMPLE model. What about experts' opinion.

  • August 6, 2010 at 12:20 am

    #1203270

    What type of performance u expect??

    If u want point in time recovery(if data is important) u have to use full recovery model..

    http://msdn.microsoft.com/en-us/library/ms189275.aspx

    this will help u for sure

  • August 6, 2010 at 3:50 am

    #1203335

    Recovery model has nothing to do with performance. Recovery model has to do with how the log is reused and how you restore the database in case of a failure.

    If you need to be able to restore to point-of-failure, then you need full recovery model and log backups. If it's acceptable to lose everything back to the last full backup, simple recovery is sufficient.

    Please read through this - Managing Transaction Logs[/url]

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 6, 2010 at 3:54 am

    #1203336

    Thanks alot for you? answers

Viewing 4 posts - 1 through 3 (of 3 total)

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