Search code examples
sql-serverdatabase-administrationdatabase-backupsrecoverymodel

Transaction Log Backup Chain

Database is in full recovery mode and transaction log backup job is running every 15 minutes.

Will the following sequence of operations cause an issue with transaction log backups?

  1. Disable transaction log backup
  2. Take a full backup
  3. Change the recovery mode to simple
  4. Perform maintenance jobs like index rebuild, update stats etc...
  5. Change the recovery mode to full
  6. Enable transaction log backup

Or should I take a full backup after step 5 for transaction log backups to work?

Thanks.

Solution

  • You break the tran log backup chain as soon as you do 3. You can restart a new log backups chain after 5 if you take a full backup. After 5 but without taking a full backup your DB remains in pseudo-simple mode, you cannot take any log backup, the log is in auto truncated mode