Creating a Database Snapshot
This is a quick vid that steps you through the process of creating a database snapshot, restoring a database from a snapshot and dropping a snapshot. I typically use snapshot while I am in a testing mode. I quickly create a snapshot and make all my modifications, run through my test and blow it all away by restoring from my recent snapshot. It is very useful and I use it often on my local development instances. Hopefully you will find it just as useful.
Create Database Snapshot
CREATE DATABASE AdventureWorks_20100401_1700 ON ( NAME = AdventureWorks_Data ,FILENAME = '<file path>\AdventureWorks_20100401_1700.ss' ) AS SNAPSHOT OF AdventureWorks;
Revert from a Database Snapshot
RESTORE DATABASE AdventureWorks FROM DATABASE_SNAPSHOT = 'AdventureWorks_20100401_1700';
Drop Database Snapshot
DROP DATABASE AdventureWorks_20100401_1700
Updated 3/24/2010 - Note: SQL Server 2005 Standard Edition does not support Database Snapshots. SQL Server 2005 Enterprise and Developer Editions do.
For more information about Database Snapshots visit the Microsoft site for Database Snapshots
Comments [0]