SQL Server DBA Tutorial 7 - How to Restore a Database from Differential Backup in SQL Server
[email protected] Chirag's SQL Server DBA Tutorial https://www.chirags.in
*****************************************************************************************
How to Restore a Database from Differential Backup in SQL Server *
*****************************************************************************************
Differential backup:
SQL Server differential backup means backing up only the data that has changed since the last full backup. This type of backup requires you to work with less data than a full database backup, while also shortening the time required to complete a backup.
We will be using two ways to Restore a Database from Differential Backup in SQL Server
1. Using SQL Server management studio graphic user interface GUI Version
2. Using T-SQL script
/** t-SQL*/
USE [master]
BACKUP LOG [DVDRentalNew] TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Backup\DVDRentalNew_LogBackup.bak' WITH NOFORMAT, NOINIT,
NAME = N'DVDRentalNew_LogBackup', NOSKIP, NOREWIND,
NOUNLOAD, NORECOVERY , STATS = 5
RESTORE DATABASE [DVDRentalNew] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Backup\DVDRentalNew.bak' WITH FILE = 1, NORECOVERY, NOUNLOAD, REPLACE, STATS = 5
RESTORE DATABASE [DVDRentalNew] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Backup\DVDRentalNew_diff.bak'
WITH FILE = 1, NOUNLOAD, STATS = 5
GO
Note : Flow the Process shown in video.
😉Subscribe and like for more videos:
/ @chiragstutorial
💛Don't forget to, 💘Follow, 💝Like, 💖Share 💙&, Comment
Tutorial Link :
https://www.chirags.in/tutorials/micr...
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
