Setup and Breakdown of a Database Snapshot
You might actually be surprised to find out how easily you can set up a database snapshot. This simplicity is partly due to the level at which database snapshots are created: at the database level and not at the table level. Setting up a database snapshot only entails running a CREATE DATABASE with the AS SNAPSHOT OF statement. You cannot create database snapshots from SQL Server Management Studio or from any other GUI or wizard for that matter. All must be done using SQL scripts. All SQL scripts for this chapter are available to you as a download from the Sams Publishing website for this book title (www.samspublishing.com) and on this book’s CD. The script file, named DBSnapshotSQL2008.sql, also contains ...
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
