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

  • October 9, 2012 at 5:42 am

    #1547170

    Ratheesh.K.Nair (10/9/2012)

    Hi Experts,

    I know we have to run a full backup if we change the recovery model from full--> simple-->full.

    No, you can just run a differential to restart the log chain, no need for a full

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉