Home Forums SQL Server 2005 Administering Full Backup after changing Changing recovery models RE: Full Backup after changing Changing recovery models

  • Ratheesh.K.Nair (11/20/2012)


    Thanks Everyone.

    Do we need to take any kind of backup when changing database recovery model from SIMPLE-->BULK LOGGED-->SIMPLE

    My first question would be why you're changing the recovery model to bulk-logged for a short period.

    If you want to initialise the log chain so that you can take log backups, you need to take a full or diff backup after switching to bulk-logged, but the fact that you're switching back to simple suggests you don't want log backups, so I fail to see the point of changing to bulk logged.

    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