Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Extend Disk Drives for SQL Cluster


Extend Disk Drives for SQL Cluster

Author
Message
soportegdl_mx
soportegdl_mx
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 5
I saw some solutions and aswers in your forum and found they very interesting.
I was wondering if someone can help me providing another answer.

I recently changed my position and I got the responsibility of a Production SQL 2005 Cluster running on Windows 2003.
I have two Disk Drives configured on it where bigger DBs reside and they are getting full soon,
Those disks are disk resources in the cluster.
Since I am not DBA, I am planning to add 2 bigger disks and copy the DBs to these two new disks with the same drive letters and no move SQL settings.
I cannot convert those new disks to dynamics neither to GPTs.

Since this is production cluster, I got a short nightly maintenance window and I got nervous because I have only 6 hrs to do this and I don't want to loss something. I do not have an environment to test this so I would appreciate any input.

This is the plan that I have

1. Stop the App and SQL Services
2. Login to the primary node 1 of the cluster
3. Take offline the SQL Server, SQL Server Agent and SQL Server Fulltext resources in SQL Group clearing the affect group check box for them.
4. Remove the dependencies from the Resources Disks in SQL Group.
5. Delete Resources Disk
6. On Disk Management Tool change labels and letters for "Old" disks to any
7. Initialize new Disks and Create new Partitions
8. Perform Quick Format and assign letters to new disks as the old disks had
9. Login to the secondary node 2 of the cluster
10. On Disk Management Tool change labels and letters for "Old" disks to any.
11. Login to primary Node 1 of the cluster
12. Create Resources Disks and set the dependencies from the Resources in SQL Group
13. Stop antivirus services related
14. Copy all content data from old disks to new disks
15. Reenable check box “affect the group” in the SQL resources.
16. Start SQL Engine and services related
17. Take online the resources in SQL Group
18. Perform cluster failover and check if it is working properly.

Regarding step 10, I don't know if when I delete the resources the "old" disks appears as available in node 2 in order to change the letters and then when I perform the failover node 2 can see the new disks with the new letters as set in node 1.

Are those steps fine?

Please help me!

Thank you.

Alex Salazar
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search