Hello,
I am trying to use Transaction Log shipping to replicate a SQL 2005 database. The log shipping set up and process proceeds without any errors or warnings but when I test the replicated database none of the transaction logs seem to have been applied to it.
Here are the details:
- Primary server = windows Server 2008 Cluster with SQL 2005
- Secondary server = windows server 2003 (not clustered) with SQL 2005
- Both servers are in the same domain
- I have set up a LogShippiongOut folder on the primary server, shared it out and made sure that SQL server agent has modify access.
- I have set up a LogShippingIn folder on the secondary server and also made sure that SQL server agent has modify access.
- When setting up Transaction Log Shipping in SQL Server Management Studio I have taken all the defaults and under the Restore Transaction Log Tab for the secondary server I have chosen Standby Mode when restoring. (Though the issue also happens if I choose no recovery mode)
- No errors are reported when the log shipping is initiated and the database properly copies over to the secondary server
- Every 15 minutes all the log shipping jobs run without error.
- The transaction logs themselves appear in the both the LogShippiongOut folder on the primary server and the LogShippiongIn folder on the secondary server.
- BUT when I recover the database on the secondary server to test it, none of the transaction logs actually seem to have been applied and it is in the same state that it was when it was originally copied over during the set up.
Any assistance would be greatly appreciated,
Thank you.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
There are only three jobs that I can see on the target server. One is an LSAlert job that has an error reading "databse has restore threshold of 45 minutes and is out of sync." - which I assume is because it has not been restoring. The other two are LSCopy and LSRestore. Neither one of has any errors and they all read as successful.
As some added information I stopped and restarted the logshipping from scratch. Now the LSAlert job does not show any errors. Specifically the details of the three logs from the target server are:
LSAlert log
Date 07/04/2009 10:30:00
Log Job History (LSAlert_SERVER01)
Step ID 1
Server SERVER01
Job Name LSAlert_SERVER01
Step Name Log shipping alert job step.
Duration 00:00:00
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
--------------------------
LSCopy log
Message
Executed as user: DOMAIN\Service Account. The step succeeded.
Date 07/04/2009 10:30:00
Log Job History (LSCopy_server02)
Step ID 1
Server SERVER
Job Name LSCopy_ server02
Step Name Log shipping copy job step.
Duration 00:00:02
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
Executed as user: DOMAIN\Service Account. The step succeeded.
--------------------------
RSResore log
Date 07/04/2009 10:30:00
Log Job History (LSRestore_ server02)
Step ID 1
Server SERVER
Job Name LSRestore_ server02
Step Name Log shipping restore log job step.
Duration 00:00:46
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
Executed as user: DOMAIN\Service Account. The step succeeded.
I have changed the names but server01 is the target server and server02 is the primary server. The SQL agent is set to run under the domain Service Account. Again there are no errors being reported but the database on the target server does not seem to be actually have the transaction llogs being applied.
Business Accounts
Answer for Membership
by: St3veMaxPosted on 2009-04-07 at 00:50:58ID: 24084703
There should be a job on the target server which applies the logs. Can you check that and see what errprs are reported.