Automatic backup after restore.

• SQLSACT

  SSC-Insane

  Points: 21838

  More actions

  October 10, 2016 at 7:19 am

  #400855

  Hi All

  Environment: Microsoft SQL Server 2008 R2 (SP3) - Standard Edition.

  So I have 2 SQL Servers - Server1 and Server2. I have a job that runs daily on Server1 that backs up MSDB directly to a share on Server2..then on Server2, I have a job that restores said backup as MSDB_RESTORE.

  I've noticed entries in MSDB on Server2 that indicates a successful backup of MSDB with a timestamp of just before the restore finishes....however, there is no entry in the SQL error log indicating a backup of MSDB. MSDB indicates that the location of the backup is the same location and .bak file name as the location MSDB is restored from and the "backup" size is the same size as the restored backup.

  Any idea why MSDB thinks that a backup was done?

  Thanks

• SQLSACT

  SSC-Insane

  Points: 21838

  More actions

  October 10, 2016 at 10:43 am

  #1905710

  After fiddling around a bit...this is what's happening.

  When the restore runs, it inserts an entry into the msdb.dbo.backupset table about the backup...

  Is this normal?

  Thanks