Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bsethi24
Starting Member
25 Posts |
 Posted - 2011-11-19 : 12:26:24
|
| 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 |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-11-21 : 17:21:25
|
| log shipping will only copy transaction logs from primary server to secondary server. It will not copy schema. If new inserted/updated record not shown on secondary server, check if jobs are running? copy and restore job on secondary server. |
 |
|
|
|
|
|
Why difference is there in Record Count & tables i