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 vs LOG bAckup Expand / Collapse
Author
Message
Posted Monday, October 15, 2012 2:52 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 2:35 AM
Points: 526, Visits: 2,032
What are the differences between

Differential vs LOG bAckup
Bulk recovery vs simple Recovery
Post #1372601
Posted Monday, October 15, 2012 3:07 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: Friday, September 19, 2014 3:37 AM
Points: 708, Visits: 3,288
ramyours2003 (10/15/2012)
What are the differences between

Differential vs LOG bAckup
Bulk recovery vs simple Recovery


Google is your best friend. But here goes anyway:

Differential backup - A file which contains ONLY the changes that have occurred since the LAST full backup.

T-Log backup - A file which contains transaction logs?! (basically the instructions SQL server used to make changes to the database)


Simple Recovery - Doesn't allow Log backups. SQL Server automatically reclaims log space so no management from the user is required.

Bulk recovery - Bulk operations are minimally logged - other operations are logged as normal.


---------------------------------------------------------


It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens

Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
Post #1372608
Posted Monday, October 15, 2012 3:08 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 7:59 AM
Points: 39,984, Visits: 36,353
http://msdn.microsoft.com/en-us/library/ms175526.aspx
Managing Transaction Logs
http://www.sqlservercentral.com/articles/Administration/75461/
http://www.sqlservercentral.com/articles/Recovery+models/89664/






Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1372609
Posted Monday, October 15, 2012 3:08 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 7:59 AM
Points: 39,984, Visits: 36,353
Abu Dina (10/15/2012)
Bulk recovery - Bulk operations are minimally logged - other operations are logged as normal.


But that's true for simple recovery as well.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1372611
Posted Monday, October 15, 2012 3:15 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: Friday, September 19, 2014 3:37 AM
Points: 708, Visits: 3,288
GilaMonster (10/15/2012)
Abu Dina (10/15/2012)
Bulk recovery - Bulk operations are minimally logged - other operations are logged as normal.


But that's true for simple recovery as well.


I didn't know that. My understanding is that SIMPLE is the same as FULL except that SQL Server reclaims log space by itself and you can't do T-Log backups so no point in time recovery.


---------------------------------------------------------


It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens

Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
Post #1372613
Posted Monday, October 15, 2012 3:16 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 7:59 AM
Points: 39,984, Visits: 36,353
Nope. Maybe read the last two articles I linked above.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1372614
Posted Monday, October 15, 2012 3:28 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 2:35 AM
Points: 526, Visits: 2,032
Thanks all to share the info
Post #1372624
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse