Menu Toggle
Close
Home » tutorials » microsoft_sql_server_database_tutorials
Microsoft SQL Server DatabaseTutorial

SQL Server DBA Tutorial 1 - How to Install SQL Server 2014 step by step in Windows System

SQL Server DBA Tutorial 2 - How to Create Database in SQL Server

SQL Server DBA Tutorial 3 - What is Database Backup How Many Types of Backups available

SQL Server DBA Tutorial 4 - How to Manually Take Full Backup of a Database in SQL Server

SQL Server DBA Tutorial 5 - How to Restore a Database From Full Backup in SQL Server

SQL Server DBA Tutorial 6 - How to Manually Take Differential backup of a Database in SQL Server

SQL Server DBA Tutorial 7 - How to Restore a Database from Differential Backup in SQL Server

SQL Server DBA Tutorial 8 - How to Manually Take Transaction Log backup of a database in SQL Server

SQL Server DBA Tutorial 9 - How to Restore a Database to Specific Time Point in Time in SQL Server

SQL Server DBA Tutorial 10 - How to Create Backup Maintenance Plan in SQL Server

SQL Server DBA Tutorial 11 - How to Schedule Auto Databases Backup in SQL Server

SQL Server DBA Tutorial 12 - How to Cleanup Old Backups in SQL Server

SQL Server DBA Tutorial 13 - How to Rename a Database in SQL Server

SQL Server DBA Tutorial 14 - Create Database Best Practices with SSMS

SQL Server DBA Tutorial 15 - How to Create Database Snapshot in SQL Server

SQL Server DBA Tutorial 16 - Manually Take Tail Log Transaction Log backup of a Database in SQL Server

SQL Server DBA Tutorial 17 - How to Attach and Detach Databases in SQL Server

SQL Server DBA Tutorial 18 - How to Script out an Entire Database in SQL Server

SQL Server DBA Tutorial 19 - How to Take Database Offline and Bring it Online in SQL Server

SQL Server DBA Tutorial 20 - How to compare these two databases and find what is the difference between these two databases

SQL Server DBA Tutorial 21 - How to configure Database Mail in SQL Server

SQL Server DBA Tutorial 22 - How to Setup the Email Notificaion For Job Failure on SQL Server

SQL Server DBA Tutorial 23 - What is replication Types of replication and when to use each type

SQL Server DBA Tutorial 24 - Why do we use Replication Provide couple scenarios

SQL Server DBA Tutorial 25 - How to Configure Distribution in SQL Server Replication

SQL Server DBA Tutorial 26 - How to Create Snapshot Replication in SQL Server

SQL Server DBA Tutorial 27 - How to Create Transactional Replication in SQL Server

SQL Server DBA Tutorial 28 - How to Create Merge Replication in SQL Server

SQL Server DBA Tutorial 29 - Overview of SQL Server Agent Configuration

SQL Server DBA Tutorial 30 - How to Create Job using SQL Server Agent

SQL Server DBA Tutorial 31 - Job Categories Overview in SQL Server Agent

SQL Server DBA Tutorial 32 - How to Create an Alert in SQL Server

SQL Server DBA Tutorial 33 - How to Create an Operator in SQL Server

🔰 SQL Server DBA Tutorial 15 - How to Create Database Snapshot in SQL Server 🔰

Facebook  Twitter  Instagram  Youtube  #WhatsappLinkCustom #TelegramLinkCustom


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:
https://www.youtube.com/@chiragstutorial
💛Don't forget to, 💘Follow, 💝Like, 💖Share 💙&, Comment

Facebook  Twitter  Instagram  Youtube  #WhatsappLinkCustom #TelegramLinkCustom

0 Comments
Leave a message

 

Search Current Affairs by date
Other Category List
झारखंड कर्मचारी चयन आयोग (Jharkhand Staff Selection Commission)
General Knowledge
Aptitude
General Science
Education
Networking
Verbal Ability
Logical Reasoning
Database
Computer Science
JTET Paper I & II
PGT
Class 10 ML Aggarwal
RK Bansal 10th Math(ICSE)
JPSC Prelims Paper I
JPSC Prelims Paper II
JPSC Prelims Paper II categories
1947 से राज्य आर्थिक विकास का इतिहास, झारखण्ड का भूगोल – जंगल, नदी, पहाड़-पर्वत, खान-खनिज आदि (History of State Economic Development since 1947, Geography of Jharkhand - Jungle, River, Mountain - Mountain, Mine - Mineral etc.)
Folk literature, dance, music, instruments, sightseeing and tribal culture of Jharkhand (झारखण्ड का लोक साहित्य, नृत्य, संगीत, वाद्य, दर्शनीय स्थल एवं आदिवासी संस्कृति)
History of Jharkhand (झारखण्ड का इतिहास)
Jharkhand Movement (झारखण्ड आन्दोलन)
Jharkhand Sports (झारखण्ड के खेल-कूद)
Jharkhandi literature and litterateur (झारखण्डी साहित्य और साहित्यकार)
Major educational institutes of Jharkhand (झारखण्ड के प्रमुख शिक्षण संस्थान)
Unique Identification of Jharkhand (झारखण्ड की विशिष्ट पहचान)
झारखण्ड की औद्योगिक नीति, विस्थापन और पुनर्वास नीति एवं अन्य नीतियाँ (Jharkhand's Industrial Policy, Displacement and Rehabilitation Policy and other policies)
झारखण्ड की प्रमुख योजनाएँ एवं उपयोजनाएँ (Major schemes and sub-plans of Jharkhand)
झारखण्ड के प्रमुख उद्योग का नाम और स्थान तथा औद्योगिक विकास (Name and location of major industry of Jharkhand and industrial development)
झारखण्ड के भूमि सम्बन्धी कानून/अधिनियम (Land Related Laws / Acts of Jharkhand)
झारखण्ड में जंगल प्रबंधन एवं वन्य जीव जन्तु संरक्षण कार्य (Forest management and wildlife conservation work in Jharkhand)
झारखण्ड राज्य के पर्यावरण सम्बन्धी तथ्य, हो रहे पर्यावरण परिवर्तन एवं उसके अपशमन एवं अनुकूलन (Facts related to environment of Jharkhand state, environmental changes happening and its abatement and adaptation)
झारखण्ड से आपदा प्रबन्धन (Disaster Management from Jharkhand)
झारखण्ड से सम्बंधित विविध तथ्यों एवं समसामयिक घटनाएँ (Miscellaneous facts and current affairs related to Jharkhand)
Microsoft Certifications
Question2Answer