Database Snapshot

Sample T-SQL Code for creating a database snapshot. use AdventureWorks2012 go sp_helpfile — used to get the logical database name needed for below CREATE DATABASE AWSnapshot ON ( NAME = ‘AdventureWorks2012_Data’, FILENAME=’’ ) AS SNAPSHOT OF AdventureWorks2012; –using it USE AWSnapshot; GO SELECT * FROM Sales.SalesOrderDetail WHERE ProductID = 53; –reverting from snapshot RESTORE DATABASE […]

Read More