Post reply

Changing Recovery mode from simple to Full

  • April 24, 2007 at 1:34 pm

    #63062

    Hi,

      I am planning to change the database recovery mode to full from Simple and start scheduling the log backups. I am planning to do this in the day time. I am guessing that there will not be any effect to the users at that time while changing the database to full.

    Can anyone just let me know your thoughts on this? I just want to know if there are any effects doing this in day time.

    Thanks

     

     

  • April 24, 2007 at 1:44 pm

    #702250

    I would do it before users get on the system.  After you switch to full recovery mode, do a full backup and then start your transaction log process to start log chain.

    Also, if you haven't already, be sure to read BOL for more information.

  • April 24, 2007 at 1:49 pm

    #702251

    Yes i would take a full backup and then start the Tlog backup process soon after i switch the database to full. can you please let me know if it locks the database when switching the recovery mode.

  • April 24, 2007 at 2:32 pm

    #702264

    You shouldn't see any real hit on your server during the change.

  • April 26, 2007 at 7:08 am

    #702594

    You can change the recovery mode anytime you want or you need.  In this case after you change the recovery mode to full make sure you get a full backup the database then schedule you tlog backups how often you need.

    Good day,

    Bulent

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

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