PJ_SQL
SSCertifiable
Points: 6699
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
Points: 6869
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply