SQL 2008 Recovery 6 - snapshot

CREATE DATABASE Northwind_dbss1800 ON
( NAME = Northwind, FILENAME =
'C:\TSQL2K8DB\Northwind_data_1800.ss' )
AS SNAPSHOT OF Northwind;
GO

use Northwind

update [Order Details] set Quantity = Quantity + 1 where OrderID = 10248


select * from [Order Details]


--restore from snapshot
USE master;

RESTORE DATABASE Northwind from
DATABASE_SNAPSHOT = 'Northwind_dbss1800';
GO