Post reply

Full Backup, T-Log Backup

  • April 29, 2012 at 4:41 am

    #259996

    Hi,

    If i take full backup and transaction log backup, is the same data available in the both backups. The DB is in full recovery model.

    Plz tell me any one.....

  • April 29, 2012 at 4:56 am

    #1480910

    No.

    I think you need to do you research. Google knows all.

    There's a whole sections on this to read up about transaction logs right here on SSC

    http://www.sqlservercentral.com/stairway/73776/[/url]

  • April 29, 2012 at 5:35 am

    #1480911

    No

    A full database backup is a complete backup of the entire database. A transaction log backup contains the log records since the last transaction log backup.

    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

  • April 29, 2012 at 6:28 am

    #1480913

    Minimally, you must have created at least one full backup before you can create any log backups.

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

  • April 29, 2012 at 7:03 am

    #1480920

    I recommend that you read up about different types of backups, what is included in them, and different strategies. It is far to easy to invest confidence in a faulty disaster recovery plan to only get bitten at the worst possible moment.

    BOL Backup Overview


    Twitter: @SQLife
    Email: sqlsalt(at)outlook(dot)com

  • April 29, 2012 at 8:41 am

    #1480929

    I want to know that If take first T-Log backup then I took Full Backup, is the data in the T-Log is also in Full Backup or not ?

    please let me know....

  • April 29, 2012 at 9:04 am

    #1480934

    As Gail pointed out above a full backup is a backup of the entire database.


    Twitter: @SQLife
    Email: sqlsalt(at)outlook(dot)com

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

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