Change disks in SQL Cluster.


Here are the general steps recommended for the migration of SQL Storage volumes, for instance:Ensure that there are Full backups of all databases in the system, when just prior to migration.

Stop all SQL Server services (Cluster Manager – Take Offline Services SQL only).

Assigning the new storage volumes and Drive Letter’s temporary copies.

Full copy of all existing data, keeping the ACLs of existing volumes to new ones.

Removal of dependencies on the SQL Service of old records.

Removing the Drive Letter’s of old records and assignment of these new discs to Drive Letters (attention has to be guaranteed that all drive Letters are kept for each volume replaced)

We recommend that prevented access by the operating system on both nodes to the old disk (disable the making of the Path, or another method which ensures that the OS does not access the old disk), but keeping the data intact in case you need to RollBack.

Allocation of new volumes in the SQL Cluster Group.

Making even the services of SQL “Offline” Move SQL group for each of the physical nodes in the cluster, must raise all funds, with the exception of SQL Services. With this step we ensure that the new volumes are correctly recognized by the OS of each physical node.

Assign dependencies removed in section 5 to the SQL Service, should be exactly the same as previously existing.

Making again the SQL Failover Group, even with the SQL services “Offline”, among all physical nodes in the cluster.

Making the Bring Online Services and SQL Move Group from all physical nodes in the cluster to ensure that the SQL service is started successfully on all physical nodes in the cluster.

You can follow the following article concerning optimization of the discs to SQL Server 2008:

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s