November 30, 2012 at 11:50 am
We have SRDF DR setup in our SQL env and one common question which arise everyday is how can one come to know that my server is set up under SRDF. Is there any command which I can run under command prompt my primary box and confirm that this server is under SRDF DR recovery?
November 30, 2012 at 3:03 pm
While we dont use SRDF, and use a similar Hitachi product, we have a dummy job that runs every hour updating a single row in a dummy table. We use this to check latency on the other side and to ensure that its being replicated to the DR site. Hope that helps.
December 2, 2012 at 6:55 am
Thanks, but my question was not on how to update records under SRDF. I want to know where at looking at primary server you can define tha this server is under SRDF DR recovery mode. Like in Log shipping we go in database properties and check, for replication we check in local publication. Like wise for SRDF recovery mode, is there any place where we can confirm that this database is in SRDF.
December 5, 2012 at 7:43 am
As far as I know, no. This setting is exclusive to the SAN. SQL Server, as far as I know is not aware of this setup, and the refresh is managed entirely on / by the SAN at the block level(At least in our case - using Hitachi SAN). This is something like how some apps / services are not cluster aware, but can be managed in a cluster by adding them in the cluster set up as a generic service.
December 5, 2012 at 10:49 am
Thank you ....
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply