I am trying to determine if a full database backup on a Full Recovery Model database, truncate the log? Or does only backing up the log, truncate the log?
Ensure you execute the log backup command just prior to your database backup. This makes the backup as small as possible. I have also noticed that when I would backup the database and then the log I was sometimes not able to restore (in test fortunately) the first trans log of the day.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply