Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Restore from database snapshot does not appear in the history table Expand / Collapse
Author
Message
Posted Tuesday, September 21, 2010 12:01 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, March 04, 2014 4:19 PM
Points: 975, Visits: 1,589
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.



Post #989963
Posted Monday, February 24, 2014 4:23 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 6:12 PM
Points: 827, Visits: 342
Please refer http://www.sqlservercentral.com/Forums/Topic966065-1550-1.aspx
Post #1544737
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse