Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Learn about SQL Server DBA, SQL Server database performance,SQL Server optimisation,database tuning,t-sql,ssis
Browse by Tags · View All
DBA Scripts 51
performance 37
SQL Server 29
Object Management 24
#SQLServer 24
Backup and Restore 20
Security Management 20
Powershell 17
Indexes 14
DBA 14

Archive · View All
June 2011 38
January 2011 33
May 2011 32
August 2011 27
July 2011 26
January 2012 24
February 2011 19
April 2011 19
March 2011 17
March 2012 17

Jack Vamvas's Blog

SQL Server RESTORE DIFFERENTIAL BACKUP WITH SIMPLE RECOVERY

Mar 23 2012 12:00AM by Jack Vamvas   

First thing this morning – a request from a DBA to confirm if Differential BACKUPS can be restored on a database in SIMPLE RECOVERY mode.  Yes , you can.

 A few assumptions are made :

1) A Differential base exists

2) The Differential base is not a COPY_ONLY database .More on Differential backup cannot be restored . BACKUP with COPY_ONLY

3) The Differential backup includes changes only since the last backup

3) No Transaction Logs exist as it’s a database in SIMPLE RECOVERY mode

A simple example :

--Create a sample database in SIMPLE RECOVERY 
CREATE DATABASE [DIFF_TEST] 
GO
ALTER DATABASE [DIFF_TEST] SET RECOVERY SIMPLE 
--Create a FULL backup (base)
BACKUP DATABASE DIFF_TEST TO DISK = 'M:\diff_testFULL.bak'
--commit some activity 
--create a DIFFERENTIAL BACKUP
BACKUP DATABASE DIFF_TEST TO DISK = 'M:\diff_testDIF.bak' WITH DIFFERENTIAL
GO
--Drop the DIFF_TEST database
DROP DATABASE 
-- Restore the Full (base) with NORECOVERY mode
RESTORE DATABASE DIFF_TEST
FROM DISK='M:\diff_testFULL.bak'
WITH NORECOVERY
--Restore the DIFFERENTIAL with NORECOVERY mode
RESTORE DATABASE DIFF_TEST
FROM DISK='M:\diff_testDIFF.bak'
WITH NORECOVERY

--Bring the database ONLINE
RESTORE DATABASE DIFF_TEST
WITH RECOVERY


Republished from SQL Server DBA [65 clicks].  Read the original version here [7 clicks].

Jack Vamvas
5 · 26% · 8528
2
 
0
Lifesaver
 
0
Refreshed
 
 
0
Incorrect



Submit

Your Comment


Sign Up or Login to post a comment.

"SQL Server RESTORE DIFFERENTIAL BACKUP WITH SIMPLE RECOVERY " rated 5 out of 5 by 2 readers
SQL Server RESTORE DIFFERENTIAL BACKUP WITH SIMPLE RECOVERY , 5.0 out of 5 based on 2 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]