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

In this video you will learn how to restore SQL Server database using differential backup, how to add full backup and differential backup to restore, error concerning restore of differential backup with no full backup, database is not restored to correct earlier state. Tail Log backup options and best practices, restoring Differential database using T-SQL Script.

Scripts used in video for Differential backup and Restore



USE [master] 
BACKUP LOG [SalesOrders] TO  DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLPROD\MSSQL\Backup\SalesOrders_LogBackup_2015-03-03_17-52-03.bak' WITH NOFORMAT, NOINIT
 NAME = N'SalesOrders_LogBackup_2015-03-03_17-52-03', NOSKIP, NOREWIND, 
 NOUNLOAD,  NORECOVERY ,  STATS = 5 

RESTORE DATABASE [SalesOrders] FROM  DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLPROD\MSSQL\Backup\FullBack.bak' WITH  FILE = 1,  NORECOVERY,  NOUNLOAD,  REPLACE,  STATS = 5 
RESTORE DATABASE [SalesOrders] FROM  DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLPROD\MSSQL\Backup\Diff.bak' 
WITH  FILE = 1,  NOUNLOAD,  STATS = 5

GO




How to Restore a Database from Differential Backup in SQL Server

1 comment:

  1. and more importantly, your personal experienceMindfully using our emotions as data about our inner state and knowing when it’s better to de-escalate by taking a time out are great tools. Appreciate you reading and sharing your story, since I can certainly relate and I think others can too

    vidmate.onl

    ReplyDelete