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

Storage migration for 2 node sql cluster. Expand / Collapse
Author
Message
Posted Friday, October 11, 2013 2:07 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 5:21 AM
Points: 272, Visits: 984
Hi,

We have active acitvie sql cluster 2008 running on win 2008 cluster.

On this server storage migration(needs to be upgraded (HBA, Drivers, 3PAR etc)) is planning.

i want know for the DBA Prospect is there any impact on the DBAs? , and also advise me as DBA what are precautions and steps need to be taken.

Kindly suggest me.

Reply is much appricated.

Advance thanks.....
Post #1503909
Posted Friday, October 11, 2013 3:43 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, March 21, 2014 9:46 AM
Points: 387, Visits: 1,078
First of all, I suggest a clean sql backup of your user database as well system database (Master, Msdb and model) prior to start of upgrade.

At the same time, SAN team should take a copy of mdf/ndf and log files for safety.

Before start of the upgrade, a clean shutdown of sql service is required in order to avoid killing inflight transaction which in turn may delay the recovery process while startup later.
Post #1503929
Posted Friday, October 11, 2013 9:17 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Monday, July 21, 2014 11:33 AM
Points: 609, Visits: 425
I have done this multiple times most of the time it runs pretty smooth HBA firmware and drivers doesn't impact SQL layer of files . If you have EMC its even more robust .
Above all you have active active , mine was active passive so we did failover check before and after HBA upgrade .

Backup of SQL is fine for extra precuation but not necessary .
Post #1504064
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse