December 17, 2010 at 2:06 am
we have two sql servers one is the main production server and other is just a stand by both the server's are in sync. If product server fails control goes to the stand by server.
I want to know how do i keep the track that both the servers are / were in sync if disaster occurs.
December 20, 2010 at 10:13 am
What method are you using to keep them "in sync" ? You can set up an agent job on one or both of the servers to audit the state of synchronization of the data. How to do that depends on how you have them configured as well as the nature of your data.
The probability of survival is inversely proportional to the angle of arrival.
December 20, 2010 at 10:04 pm
It is being implemented through process of log shipping.
Can u plz. share some details on job agent and audit or the methods which u know to keep the server's in syn. As i have just started working on sql server so dont have that much working knowledge.
Waiting 4 your reply
December 21, 2010 at 6:56 am
First let me say that I do not use the built in log shipping methods. I create my own so that my procedures and audits are consistent from SQL version to version. In my case my auditing procedures regularly check the log ship control table to insure that all logs and/or databases are being restored and are current otherwise an alert is generated. I usually allow an hour or so lag time for various reasons, but you can maintain currency right up to the transaction log backup interval.
If you are using the built in SQL Server log shipping facilities I will not make suggestions since we don't use it. I'm sure they provide some means of monitoring the restores, and the control tables are probably located in msdb so you could interrogate them directly.
If you restore your databases/logs in STANDBY (read only) mode you can query the data and in that way have a check for current timestamps (or heart beat timer) somewhere in your data to insure the logs are being restored and the data is current.
The probability of survival is inversely proportional to the angle of arrival.
December 21, 2010 at 9:45 pm
Ok
Thanks for your response and guide.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply