Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Differential backup Expand / Collapse
Author
Message
Posted Tuesday, August 21, 2012 12:41 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 12:43 AM
Points: 208, Visits: 563
Hello Masters,

Can I perform Differential backup if my recovery model is Simple ?
Post #1347584
Posted Tuesday, August 21, 2012 1:24 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, July 25, 2014 1:01 AM
Points: 1,539, Visits: 8,133
Yes, and it's quite trivial to try.

BrainDonor
Linkedin
Blog Site
Post #1347602
Posted Tuesday, August 21, 2012 1:28 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, July 21, 2014 10:30 PM
Points: 672, Visits: 243
Hi,
Sure you can. Just try it!
But first of all, you need to make a "FULL" backup, otherwise just a differential backup without a full base is useless.
Post #1347603
Posted Tuesday, August 21, 2012 5:28 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, October 31, 2013 3:44 AM
Points: 314, Visits: 4,128
MSzI (8/21/2012)
Hi,
Sure you can. Just try it!
But first of all, you need to make a "FULL" backup, otherwise just a differential backup without a full base is useless.


If I remember correctly, it won't even let you do a diff without having first done a full for the reasons you have specified.
Post #1347720
Posted Tuesday, August 21, 2012 7:16 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, July 25, 2014 1:01 AM
Points: 1,539, Visits: 8,133
Correct, and the OP has already discovered that - http://www.sqlservercentral.com/Forums/Topic1347590-1292-1.aspx#bm1347662.

BrainDonor
Linkedin
Blog Site
Post #1347772
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse