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 Shipping

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? 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?
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |