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 |
|
GazzerJenk
Starting Member
4 Posts |
 Posted - 2008-11-07 : 06:35:48
|
| Hi all, I have a simple enough question about Log Shipping.I have just set-up some TEST Log shipping for the first time every, so please bare with me.I have set-up log shipping on the same server for testing purposes, so when I say Primary & Secondary I mean the same server.....The Log shipping jobs seems to work, and I get no errors, but when I check the secondary DB the tables have not been updated.What I mean by this is the Table on the Primary DB has 100 records in it.The same Table on the Secondary DB before log shipping had 10 records, and still has 10 records in it after log shipping has completed sucessfully.All the jobs in the Sql Agent appear to have worked correctly, the log files are appearing in the shared folder.I may have missed the point of Log Shipping, but I was under the assumption that Log Shipping made the secondary Db upto date with the first after completeion.Any help would be appreciated as ever.Cheers |
|
|
GazzerJenk
Starting Member
4 Posts |
Posted - 2008-11-07 : 06:47:21
|
| Update to this post.I have checked the job which checks sync and it says no Restore has been complted, so it appears the restore bit is failing, but that job gives no errors.Cheers |
 |
|
|
GazzerJenk
Starting Member
4 Posts |
Posted - 2008-11-07 : 06:54:45
|
| Another update as follows, I have checked the restore job and can see the following problems.Message2008-11-07 11:45:16.75 Skipped log backup file. Secondary DB: 'LogShipTEST2', File: 'd:\TransLogs\LogShipTEST_20081107111516.trn'2008-11-07 11:45:16.79 Skipped log backup file. Secondary DB: 'LogShipTEST2', File: 'd:\TransLogs\LogShipTEST_20081107113016.trn'2008-11-07 11:45:16.79 Could not find a log backup file that could be applied to secondary database 'LogShipTEST2'.2008-11-07 11:45:16.81 The restore operation was successful. Secondary Database: 'LogShipTEST2', Number of log backup files restored: 02008-11-07 11:45:16.81 Deleting old log backup files. Primary Database: 'LogShipTEST'2008-11-07 11:45:16.81 The restore operation was successful. Secondary ID: 'ece650df-e932-4f4f-8b3d-d4c11b7b4568'2008-11-07 11:45:16.82 ----- END OF TRANSACTION LOG RESTORE -----Exit Status: 0 (Success) |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-07 : 09:41:04
|
| So you mean you are doing Log shipping on 2 instances in same server? How frequently have you set backup and restore jobs? Remember there should be no manual or other maintenance plan running to backup log except MP for Log shipping. |
|
|
|
|
|
|
|
|
Log Shipping in Sql 2005