Post reply

Database snapshot history

  • August 5, 2010 at 8:16 am

    #222127

    Is there any historical system tables or catalog views to find out if the database was reverted back from the snapshot?

  • August 5, 2010 at 12:44 pm

    #1203057

    Does anyone know about it? I am still not able to figure it out. Any help is appreciated.

  • August 5, 2010 at 1:45 pm

    #1203108

    Can't believe this, no one answered as yet.

  • August 5, 2010 at 1:49 pm

    #1203113

    Did you see an entry in [msdb].[dbo].[restorehistory]?

  • August 5, 2010 at 1:56 pm

    #1203115

    Yes, did not find an entry for Snapshot restore.

  • August 5, 2010 at 2:01 pm

    #1203118

    Here are the scripts to create scenario

    --Create Snapshot

    CREATE DATABASE AdventureWorksSnap08052010 ON

    ( NAME = AdventureWorks_Data, FILENAME =

    'E:\MSSQL\Data\AdventureWorksSnap08052010.ss' )

    AS SNAPSHOT OF AdventureWorks;

    GO

    select * from HumanResources.Employee

    select * from AdventureWorksSnap08052010.HumanResources.Employee

    Update HumanResources.Employee Set HireDate='1996-07-30' where

    EmployeeID=1

    --Revert

    USE master;

    RESTORE DATABASE AdventureWorks from

    DATABASE_SNAPSHOT = 'AdventureWorksSnap08052010';

    GO

    Select * from msdb.dbo.restorehistory order by restore_date

  • August 6, 2010 at 7:32 am

    #1203507

    Can anyone help me? I would really appreciate it.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply