Recovery Models: Going from Simple to Full Recovery

  • jeremym-1104502

    SSC-Addicted

    Points: 459

    Hello,

    We are planning on moving our SQL databases from Simple to the Full Recovery Model. We are taking precautions like making sure we have enough disk space and putting the logs on a different drive array. Does anyone know of any serious gotcha's I may run into when doing this? Any tips or tricks is much appreciated.

  • Gail Shaw

    SSC Guru

    Points: 1004446

    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
  • jeremym-1104502

    SSC-Addicted

    Points: 459

    Thanks. Looks like I should let it buck and see what happens. Are you able to change models on the fly or does it take a restart of machine or service?

  • Gail Shaw

    SSC Guru

    Points: 1004446

    You can chance them as you like. A switch to simple takes effect immediately. A switch from simple to either full or bulk logged takes effect after the next full/diff backup.

    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

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

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