Post reply

secondary database is sink

  • March 15, 2013 at 6:02 am

    #275291

    secondary database in logshipping is sink how can i resume ?

  • March 15, 2013 at 6:16 am

    #1597458

    If the log shipping chain is broken and you don't have copies of all logs from the primary database, you have to take a full backup of the primary database and restore it in standby mode on the failover, before you can resume the log shipping.

  • March 15, 2013 at 6:31 am

    #1597466

    Sink?

    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

  • March 15, 2013 at 6:37 am

    #1597469

    either dive down and get it 🙂

    or

    if logs wont load because of missing lsn restart from a full again or if you have not taken a full backup of the primary since it went out of 'synch' you can restart from a differential. Restore it with the norecovery option.

    ---------------------------------------------------------------------

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

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