• 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