Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
marco1moreclick
Starting Member
2 Posts |
 Posted - 2007-01-16 : 15:52:13
|
| Hi,My sql server 2000 running on windows 2003 cluster system. (2 nodes)Two disk resource are assign to the sql cluster group (H for mdf, L for ldf).Now I want upgrade the storage for increase disk space.To migrate sql data from ol disk to new disk I'll be perform this step:take offline cluster node 2.take offline sql cluster group.take online disk resource assigned to sql cluster group.copy data from old disk to new disk.delete cluster disk H and cluster disk L.Change label on new disk using H and L.Assign new disk resource to sql cluster group.take online sql cluster group.It's correct?Thanks in advanced.Marco |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-01-16 : 17:20:43
|
| what kind of SAN are you using? can you simply extend the existing LUN instead?-ec |
 |
|
|
marco1moreclick
Starting Member
2 Posts |
Posted - 2007-01-17 : 04:40:17
|
| Compaq RA4000 5 years old.I must change this storage because it's very old. In my server farm there is another storage HP MSA8000. I prefer migrate all sql data in msa8000. Two new volume has been create, one for data file and one for log file. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-01-17 : 11:15:18
|
| yeah, these SANs probably don't support resizing existing LUNs. So we have to go with your original approach.as for your procedure it won't work becuase you are not changing the disk signatures on the new disk to match the old disk. If you go through with your plan, you will wind up with a completely unusable cluster.Microsoft has a tool available to help you with this problem. It is called the Cluster Server Recovery Utility and you can download it here http://www.microsoft.com/downloads/details.aspx?familyid=2BE7EBF0-A408-4232-9353-64AAFD65306DIt has a feature to help you replace a failed disk. In your case you don't actually have a failed disk, but that doesn't matter. The end result is that this software will allow you to replace one disk in your cluster with another disk and they can be of different sizes.I suggest you read the docs for the software (it is part of the win2k3 resource kit) and then test out the procedure. good luck.-ec |
|
|
|
|
|
|
sql 2000 server & MS Cluster service