inchirags@gmail.com Chirag's SQL Server DBA Tutorial [ Ссылка ]
*****************************************************************************************
* How to Create Database Snapshot in SQL Server *
*****************************************************************************************
What is a database snapshot in SQL Server?
Create Snapshot Database in Microsoft SQL Server
1. SSMS Graphical User Interface (GUI) with T-SQL Script
2. Make changes to Orignal Database
3. Restore database using snapshot
/**Create Snapshot**/
CREATE DATABASE SalesOrders_db_ss ON( NAME = SalesOrders, FILENAME ='C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Backup\SalesOrders.ss' )
AS SNAPSHOT OF [SalesOrders];
GO
/**Restore Snapshot Script**/
USE MASTER;
RESTORE DATABASE [SalesOrders]
FROM DATABASE_SNAPSHOT = 'SalesOrders_db_ss';
GO
Note : Flow the Process shown in video.
😉Subscribe and like for more videos:
[ Ссылка ]
💛Don't forget to, 💘Follow, 💝Like, 💖Share 💙&, Comment
Tutorial Link :
[ Ссылка ]
Thanks & Regards,
Chitt Ranjan Mahto "Chirag"
_________________________________________________________________________________________
Note: All scripts used in this demo will be available in our website.
Link will be available in description.
#DBATutorial
#DBATutorialLearning
#DBAEducation
#DBATutorialFree
#DatabaseTutorial
#SQLServerDatabaseTutorial
#SQLServerDBATutorial
#MicrosoftSQLServerDatabaseTutorial
#ChiragsDBATutorial
#ChiragsDatabaseTutorial
#ChiragsSQLServerDatabaseTutorial
#ChiragsSQLServerDBATutorial
#Chirags.inSQLServerDBATutorial
#ChiragsMicrosoftSQLServerDatabaseTutorial
#CreateDatabaseinSQLServer
#CreateDatabasewithT-SQL
#chiragstutorial
#databasetutorial
#sqlserver
#sqlservertutorial
#sqlservermanagementstudio
#sql_server
#sqlservertutorial
#chiragstutorial
#databasetutorial
#sqlqueries
#sqldba
#database
#databasemanagement
Ещё видео!