SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


How to Know server is in SRDF


How to Know server is in SRDF

Author
Message
sunil.aggi
sunil.aggi
SSC Journeyman
SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)

Group: General Forum Members
Points: 75 Visits: 155
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?
sqlGDBA
sqlGDBA
SSC-Addicted
SSC-Addicted (493 reputation)SSC-Addicted (493 reputation)SSC-Addicted (493 reputation)SSC-Addicted (493 reputation)SSC-Addicted (493 reputation)SSC-Addicted (493 reputation)SSC-Addicted (493 reputation)SSC-Addicted (493 reputation)

Group: General Forum Members
Points: 493 Visits: 315
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.
sunil.aggi
sunil.aggi
SSC Journeyman
SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)

Group: General Forum Members
Points: 75 Visits: 155
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.
sqlGDBA
sqlGDBA
SSC-Addicted
SSC-Addicted (493 reputation)SSC-Addicted (493 reputation)SSC-Addicted (493 reputation)SSC-Addicted (493 reputation)SSC-Addicted (493 reputation)SSC-Addicted (493 reputation)SSC-Addicted (493 reputation)SSC-Addicted (493 reputation)

Group: General Forum Members
Points: 493 Visits: 315
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.
sunil.aggi
sunil.aggi
SSC Journeyman
SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)

Group: General Forum Members
Points: 75 Visits: 155
Thank you ....
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search