83. How to Create Database Snapshot in SQL Server & How to restore table from Snapshot @PandeyGuruji

In this video discussed How to take snapshots of a Database and restore database from the snapshots
Scripts:
USE master
CREATE DATABASE Youtube_SQL_Training_SS_29Sep2024
ON
(NAME=AdventureWorksDW2017,
)
AS SNAPSHOT OF Youtube_SQL_Training

-- Restore Database
alter database Youtube_SQL_Training set single_user with rollback immediate;
GO
--Restored SS
RESTORE Database Youtube_SQL_Training
from DATABASE_SNAPSHOT = 'Youtube_SQL_Training_SS_29Sep2024'
go
alter database Youtube_SQL_Training set multi_user;
Go
----------------------------------------------------------------
Become SQL Expert Whats App: [phone]
-------------------------------------------------
FOLLOW ME ON:
----------------Top Playlist------------------------------------------------------------------
#SQL #PandeyGuruji
---------------------------------------------------------------------------------------------------
Disclaimer - This video is just for educational purposes.
Copyright Disclaimer under Section 107 of the Copyright Act 1976, allowance for the "fair use".
All the images, music, and graphics used in this video belong to their respective owners and I or this channel do not claim any right over them.
Copyright Disclaimer under section 107 of the Copyright Act 1976, allowance is made for “fair use” for purposes such as criticism, comment, news reporting, teaching, scholarship, education, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing