SQL Server Performance

Why difference is there in Record Count & tables in Manual Log Shipping

Discussion in 'SQL Server 2008 Log Shipping' started by bsethi24, Nov 19, 2011.

  1. bsethi24 New Member

    Dear All,

    I have implemented MANUAL Log Shipping on SQL Server 2008. Here, Manual means First I took the full backup of a DB then Restore it with RESTORE with STANDBY option on another server.

    After this taking the transaction log backup on a 15 min. interval via a JOB & then copy the LBK (Transaction log backup file) to another server & restore it on the DB.

    After this working when I am doing random check the found that New Tables created on Live server are not getting restored on Backup server & on random check I also found difference in Record count means on live servers records are inserting but, on backup the same is not getting reflected.

    One more point I need to clear that the difference is only of Records / Tables those are generated after Full Backup means something is faulty there in Transaction log backup/restore process.

    Kindly guide me what the issue or am I missing something?

  2. satya Moderator

    Welcome to the forums.
    How frequently you are checking the record status on SECONDARY server?
    Also what is the DATABASE RECOVERY MODEL on this database?

Share This Page