Post reply

Copy_Only Backup

  • May 11, 2010 at 7:50 am

    #386904

    Is it possible to perform a copy only backup of secondary database involved in Log shipping.

  • May 11, 2010 at 7:53 am

    #1165549

    I've never done that, but, according to BOL's description of copy only backup, I think it can be done.

    -- Gianluca Sartori

  • May 11, 2010 at 8:04 am

    #1165558

    While backup secondary database with copy only option, receives error "Database '%ls' is in warm-standby state (set by executing RESTORE WITH STANDBY) and cannot be backed up until the entire load sequence is completed."

Viewing 3 posts - 1 through 3 (of 3 total)

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