How to create Database Snapshot - SQL Server DBA Tutorial

In this video you will learn how to create sql server database snapshot using T-SQL Script, it also demonstrates how to view the snapshots using SQL Server Management Studio, how to restore the database from the snapshot, how to revert database using database snapshot. You will also learn some real time scenarios when it is best to use snapshot options.

Script used in this video

Create Snapshot
CREATE DATABASE SalesOrders_dbss ON( NAME = SalesOrders, FILENAME ='C:\Program Files\Microsoft SQL Server\SalesOrdersCurrent.ss' )
AS SNAPSHOT OF [SalesOrders];
GO

Restore Snapshot Script

USE MASTER;
RESTORE DATABASE [SalesOrders] 
FROM DATABASE_SNAPSHOT = 'SalesOrders_dbss';
GO

 

How to Create Database Snapshot in SQL Server