Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to Know server is in SRDF Expand / Collapse
Author
Message
Posted Friday, November 30, 2012 11:50 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, November 20, 2014 3:04 AM
Points: 11, Visits: 148
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?
Post #1391484
Posted Friday, November 30, 2012 3:03 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, November 22, 2013 10:13 AM
Points: 79, Visits: 200
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.
Post #1391570
Posted Sunday, December 2, 2012 6:55 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, November 20, 2014 3:04 AM
Points: 11, Visits: 148
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.
Post #1391721
Posted Wednesday, December 5, 2012 7:43 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, November 22, 2013 10:13 AM
Points: 79, Visits: 200
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.
Post #1393010
Posted Wednesday, December 5, 2012 10:49 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, November 20, 2014 3:04 AM
Points: 11, Visits: 148
Thank you ....
Post #1393131
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse