Differential vs LOG bAckup

Question

Differential vs LOG bAckup

ramyours2003

SSChampion

Points: 12268
More actions
October 15, 2012 at 2:52 am

#263880

What are the differences between
Differential vs LOG bAckup
Bulk recovery vs simple Recovery

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Abu Dina SSChampion Points: 14155 More actions · Answer 1

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[/url]

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

http://msdn.microsoft.com/en-us/library/ms175526.aspx

Managing Transaction Logs[/url]

http://www.sqlservercentral.com/articles/Administration/75461/

http://www.sqlservercentral.com/articles/Recovery+models/89664/

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

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, MVP, M.Sc (Comp Sci)
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

Abu Dina SSChampion Points: 14155 More actions · Answer 4

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[/url]

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

Nope. Maybe read the last two articles I linked above.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
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

ramyours2003 SSChampion Points: 12268 More actions · Answer 6

ramyours2003

SSChampion

Points: 12268

October 15, 2012 at 3:28 am

#1549046

Thanks all to share the info