This project is read-only.


[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]

This sample works only with SQL Server 2005 and SQL Server 2008. It will not work with any version of SQL Server earlier than SQL Server 2005.
The purpose of the DatabaseSnapshot sample is to demonstrate the database snapshot capabilities of SQL Server. For more information, see "Database Snapshots" in SQL Server Books Online.


A database snapshot is a read-only, static view of a database. This database is called the source database. Each database snapshot is transaction-consistent with the source database at the moment of the snapshot's creation. A snapshot persists until it is explicitly dropped by the database owner. Multiple snapshots can exist on a database. This sample creates a new database snapshot of the AdventureWorks sample database.




Before running either of the scripts included in this sample, make sure the following software is installed:
  • SQL Server, including the following components:
  • SQL Server Database Engine
  • SQL Server Management Studio
  • AdventureWorks (OLTP) sample database
  • SQL Server Database Engine samples

Running the Sample

Installing and Running the Sample
  1. From Management Studio, open the file CreateDatabaseSnapshot.sql script located in the C:\Program Files\Microsoft SQL Server\100\Samples\Engine\Administration\DatabaseSnapshot\Scripts folder, and click Execute. © 2007 Microsoft Corporation. All rights reserved.

Last edited Jun 5, 2007 at 6:58 PM by bonniefe, version 5


No comments yet.