October 11, 2013 at 2:07 am
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.....
October 11, 2013 at 3:43 am
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.
October 11, 2013 at 9:17 am
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 .
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply