November 19, 2011 at 10:15 am
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
November 19, 2011 at 10:27 am
Are the log restores succeeding?
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
November 19, 2011 at 9:17 pm
Yes in job history it shows all time jobs completed successfully & when I checked the Log folders then the Backup & Restore both are completed.
November 20, 2011 at 3:16 am
Since db is in standby mode, some of the uncommitted transactions are in undo file…
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply