SQL Server Performance

Restarting Sql Server Services of a Log Shipped Database

Discussion in 'SQL Server 2005 Log Shipping' started by akshay_menon2002, Aug 4, 2007.

  1. akshay_menon2002 New Member

    hi,
    I have a database which is being log shipped to a secondary server.
    If i restart the sql server services in the first server what will happen?
    Thanks and Regards
    Akshay
    akshay_menon2002, Aug 4, 2007
    #2

  2. satya Moderator

    If the log shipping process say backup of log is under progress then you will lose all uncommitted transactions and that are failed to written to log.
    For the next time when log shipping job starts to secondary server it will fail with log mismatch, you might need to apply full database backup in order to continue log shipping again.
    Log shipping works on LSN and any mismatch will cause issues in sync.
    satya, Aug 5, 2007
    #3

Share This Page