February 18, 2008 at 10:31 am
I need help on how to determine which transaction logs are applied on a remote server to determine when a failure occurs. I am setting a logshipping for transaction logs on a remote server that I don't have access and will like to know or need help on checking for transaction log failures that were not applied on the remote server
February 18, 2008 at 2:03 pm
Can someone reply to this post and even if they don't have all the answers to the question, I will aprreaciate any feedback
February 18, 2008 at 2:47 pm
Your request isn't entirely clear. Are you saying you want to setup log shipping & want to know how to monitor it, that you've got log shipping already and want to know how to monitor it or you've got a failed log shipping scenario and you want to get it started up again (with an option on future monitoring)?
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
February 18, 2008 at 2:51 pm
we have servers that are in production now and I have a task to move those databases to a remote server through FTP. In the remote server we will like to have all the databases with there transactions applied and up to date. At the same time I will like to know when any of the transaction logfiles is applied or failed to be applied on the remote server.
February 19, 2008 at 12:53 am
There are two ways to monitor your logs:
1. While setting up logshipping configure monitor server which will keep all the track of tlog applied or is lacking behind or out of sync. etc.
2. Second option is on destination server there will be restore job for tlog. set notification to send mail in case of success and/or failure to the operator.
Hope this will help.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply