Post reply

Backup

  • December 5, 2013 at 12:03 am

    #285738

    Hi

    I am new in sql server.

    I am confused with the backing up process ,when we do a Diff. backup does it backup from ldf. file or just mdf?What a bout Full and Log backup?

    Does the ldf file only contain transaction log?

    Could anyone please give me some resource to read more about it?

  • December 5, 2013 at 12:09 am

    #1670928

    A differential backup is a backup of the data changes since the last full backup. It's a data backup, not a log backup, so mostly the data file with enough log to restore consistently.

    The ldf is the transaction log.

    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

  • December 5, 2013 at 12:23 am

    #1670929

    Hi,

    This link will help you understand all the backup types of sql server in detail.

    http://technet.microsoft.com/en-us/magazine/2009.07.sqlbackup.aspx

    Thanks & regards

    MJ

  • December 5, 2013 at 12:28 am

    #1670930

    go through below article to get an idea about SQL backups.

    http://www.mssqltips.com/sqlservertutorial/6/types-of-sql-server-backups/


    Praveen D'sa
    MCITP - Database Administrator 2008
    http://sqlerrors.wordpress.com

  • December 5, 2013 at 1:20 am

    #1670941

    Sorry ,so " with enough log to restore consistently" means from ldf?

  • December 5, 2013 at 2:32 am

    #1670960

    It means enough of the transaction log so that the restore can recreate the database in a transactionally consistent way. Don't worry about what from what file, just focus on what the backups do in terms of the database.

    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

  • December 7, 2013 at 2:37 am

    #1671711

    Thanks to all

    It was so helpful 🙂

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

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