Why difference is there in Record Count & tables in Manual Log Shipping | SQL Server Performance Forums
SQL Server Performance Forum – Threads Archive
Why difference is there in Record Count & tables in Manual Log ShippingDear 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? Thanks
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?