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

1 comment:

  1. pas cher jimmy choo chaussures, combinant style élégant et technologie de pointe, une variété de styles de pas cher jimmy choo mules, le pointeur se place entre votre style gustatif exclusif.

    ReplyDelete