SQL Server Performance Forum – Threads Archive
how to check if the log shipping is succesfulHi all, How can i check that if the logshipping is working perfectly fine. I test on test database. all the job worked successful but i don’t see the changes in the database nor i seee th file which sould be copied to destination location. How to check it [email protected]@@ Thanks!!
a simple (if kludgy) way would be to run a select on the logshipped database (which should be in read only iirc), and confirm that it is accurate.
You might be able to review the SQL Server logs on the destination server – I think the restores of the logs should be in there.
Do you have a monitor server set-up – what does that show?
Panic, Chaos, Disorder … my work here is done –unknown
it does not show anything like log restored!! nor in database selece shows anything!! Thanks Thanks!!
Check whether this KBAhttp://support.microsoft.com/kb/292586/ is anyhelp.
http://support.microsoft.com/kb/314515/EN-US/ fyi on faq. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing.
it works fine now but getting error for The log shipping source (local).test has not backed up for 325 minutes.. this error is getting in server log!!! why! please help me to solve it plz… Thanks!!