Restore from database snapshot does not appear in the history table

• Roust_m

  SSCoach

  Points: 17410

  More actions

  September 21, 2010 at 12:01 am

  #224192

  Hi,

  I was trying to do the following:

  CREATE DATABASE MYDB_ss1600 ON ... AS SNAPSHOT OF MYDB;

  GO

  Then:

  RESTORE DATABASE MYDB FROM DATABASE_SNAPSHOT = 'MYDB_ss1600'

  And finally:

  SELECT top 10 [restore_date], [destination_database_name], rh.[backup_set_id], physical_device_name

  FROM [msdb].[dbo].[restorehistory] rh (nolock)

  JOIN [msdb].[dbo].[backupset] bs (nolock)

  on rh.backup_set_id = bs.backup_set_id

  JOIN [msdb].[dbo].[backupmediafamily] bmf

  on bs.media_set_id = bmf.media_set_id

  order by restore_date desc

  But I find no trace of the restore from the snapshot.

  Is this normal?

  Thanks.

• Amit Raut

  SSCrazy

  Points: 2613

  More actions

  February 24, 2014 at 4:23 pm

  #1691737

  Please refer http://www.sqlservercentral.com/Forums/Topic966065-1550-1.aspx