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, September 23, 2014 8:53 AM
Points: 209, Visits: 573
Hello Masters,

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


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Today @ 4:40 AM
Points: 1,464, Visits: 8,288
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: Saturday, August 9, 2014 11:36 PM
Points: 676, Visits: 245
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


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Today @ 4:40 AM
Points: 1,464, Visits: 8,288
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