Change DB recovery model from Simple to Full

• PJ_SQL

  SSCertifiable

  Points: 6703

  More actions

  March 20, 2019 at 2:27 pm

  #382026

  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: 6869

  More actions

  March 21, 2019 at 1:50 am

  #2025082

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

  Thanks