Post reply

Why do we use 'Copy_Only' during a datbase backup? does this effect LSN?

  • July 23, 2012 at 1:00 pm

    #264459

    BACKUP DATABASE XXXXX

    TO DISK = 'C:\Sqlserver\backup\xxx.bak'

    with copy_only

    GO

    Why do we use 'Copy_Only' during a datbase backup? does this effect LSN?

    In which backups do we backup mdf and ldf?

  • July 23, 2012 at 1:04 pm

    #1516430

    http://sqlinthewild.co.za/index.php/2011/03/08/full-backups-the-log-chain-and-the-copy_only-option/

    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

  • July 23, 2012 at 1:25 pm

    #1516440

    From MSDN:

    A copy-only log backup preserves the existing log archive point and, therefore does not affect the sequencing of regular log backups.

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

  • July 23, 2012 at 1:58 pm

    #1516458

    Vikrant S Patil (7/23/2012)

    From MSDN:

    A copy-only log backup preserves the existing log archive point and, therefore does not affect the sequencing of regular log backups.

    That is specifically talking about a copy only log backup, not a copy only full backup. I have logged a connect asking for that page to be clarified.

    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

  • July 24, 2012 at 8:30 am

    #1516843

    Gail, Thanks for the update.

    Really appreciate you sharing your knowledge and giving all of us a opportunity to learn from your vast experience.

Viewing 5 posts - 1 through 4 (of 4 total)

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