Change DB recovery model from Simple to Full

  • PJ_SQL

    SSCertifiable

    Points: 6412

    Hello!
    I need to change Database recovery model from Simple to Full.
    Currently, Full backup is scheduled for everyday at 12 AM.

    Once I change the DB to Full, let the scheduled Full backup to run and then schedule T-log?

    Thank you.

  • NorthernSoul

    SSCertifiable

    Points: 6783

    Yes that's right, there needs to be a full backup before the log can be backed up.

    Thanks

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

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