How to Create Snapshot and Restore From Snapshot in SQL Server Database

Take Snapshot:
CREATE DATABASE Sales_Snapshot_01 ON( NAME = Sales, FILENAME ='C:\temp\Sales_2021_05_15.ss' )
AS SNAPSHOT OF [Sales]; 
GO





Restore from Snapshot:
USE MASTER;
RESTORE DATABASE [Sales] 
FROM DATABASE_SNAPSHOT = 'Sales_Snapshot_01';
GO






Comments