Differential vs LOG bAckup

  • What are the differences between

    Differential vs LOG bAckup

    Bulk recovery vs simple Recovery

  • 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

  • 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
  • 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
  • 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

  • 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
  • Thanks all to share the info

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

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