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

SAN replication Expand / Collapse
Author
Message
Posted Tuesday, November 29, 2011 1:50 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 3, 2012 3:35 AM
Points: 3, Visits: 4
Hi There,

We are implementing SAN level replication for our SQL Databases. Can you direct me to any links that guides on step by step activities to be done on the DR server to bring up the database.

Cheers,Gali
Post #1213537
Posted Tuesday, November 29, 2011 1:56 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Saturday, October 18, 2014 5:21 PM
Points: 5,877, Visits: 13,005
Its going to depend on your SAN vendor, the OS you are running and which databases you are replicating (are you doing the system databases?)

Once the steps are done that are relevant to those variables likely you will just have to restart SQL and all databases will be online and usable


---------------------------------------------------------------------

Post #1213543
Posted Tuesday, November 29, 2011 2:23 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 3, 2012 3:35 AM
Points: 3, Visits: 4
Thanks for your time .It is Dell and the OS is Windows 2008 and the DB is SQL server 2008 R2. Can you please advise what would be the status of the database on the DR side once the disks are mounted?

Cheers,Gali
Post #1213564
Posted Tuesday, November 29, 2011 2:40 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Saturday, October 18, 2014 5:21 PM
Points: 5,877, Visits: 13,005
IF the metadata about the databases exist in the system databases on the DR server, they should be usable.

I strongly suggest you set up a test environment and practice the failover.

are you replicating the drive supporting the system databases?



---------------------------------------------------------------------

Post #1213576
Posted Tuesday, November 29, 2011 2:48 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 3, 2012 3:35 AM
Points: 3, Visits: 4
Thanks again. The new DR server would be an exact copy of the old server including the C drive. What I am trying to understand is what are the steps(technical) that I need to do bring up the database on DR site.
Post #1213582
Posted Tuesday, November 29, 2011 3:08 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Saturday, October 18, 2014 5:21 PM
Points: 5,877, Visits: 13,005
So you are booting from SAN? thats probably the best way to leverage SAN replication.

From the SQL side there should be NOTHING to do, should all just work once the server is up. all the effort is on the intel side powering up the hardware. What steps the system people might need to take I am not sure I am afraid.


---------------------------------------------------------------------

Post #1213591
Posted Monday, July 9, 2012 11:39 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, August 8, 2012 5:48 AM
Points: 29, Visits: 95
Hi;

Very interesting topic, I am planning same environemnt. By active participation we can conclude this discussion with a complete DR solution.

I have attached a picture(solution), please add comments.

I want to creat attached environment, please advice steps.

Thanks



  Post Attachments 
PRD_DR Cluster with SAN to SAN Replication.zip (33 views, 69.12 KB)
Post #1327263
Posted Thursday, December 6, 2012 12:30 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, December 6, 2012 12:23 PM
Points: 2, Visits: 0
hii,

So u are looking for the steps how to replicate ur data, for disaster recovery??
Post #1393702
Posted Friday, January 24, 2014 2:59 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 4:00 AM
Points: 42, Visits: 238
yes. pls assist.
Post #1534395
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse