LogShipping completed, but new record not added to the standby db

[mm8294]

I have setup the log shipping following the LearningTree's training materials on our servers:

Source: Northwind on server prod
Destination: Northwind2 on server dev

After the plan was created, everything looks fine. The new database northwind2 was created successfully. I checked on server prod the jobs under SQL Server Agent, and also checked the log ship monitor, all the messages indicated that the log shipping works fine. However, the log shipping was scheduled to run every 15 minutes, but I inserted a record in northwind on server prod an hour ago and I still don't see the new record in Northwind2 on dev.

This is the first project my boss asked me to do as a DBA, any help is very appreciated.


Thanks in advance.

 

[mrdenny]

Check the job history to make sure that the log shipping job actually is scheduled. Also make sure that the agents are up and running.

This is one of the reasons that I prefere to write my own log shipping code as a job, and ignore the built in log shipping.

Denny

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)

 

[mm8294]

Denny, thank you very much for your help. I have double checked before I posted my question here. The job has been run successfully every 15 minutes as scheduled, and the agents are up and running. Something must be wrong. It is really weird to me.

I checked it again a few minutes ago, it seems that the logs were backed up successfully, but the restore failed. The "Transaction Log Backup Job for DB Main....." was successful, but "log shipping alert - Restore" failed.

Does anybody know where to check the details of the failed job? Event Viewer does not provide detailed info.

 

[mrdenny]

In Enterprise Manager Open {Server} > Management > SQL Server Agent > Jobs.
Right click on the job and click View History.

Denny

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)

 

[JayKusch]

It seems as half of the log shipping execution is happening. You are getting the log backup but the restore fails.

I would verify destination share that you are sending your backups too. It seems they are getting there but the Restore job may be looking in another share for the backup to restore.

Thanks

J. Kusch