Skip to Content
0
Former Member
Sep 27, 2008 at 02:25 PM

Disk re-assignment on SQL2000/MSCS

27 Views

Folks,

I hope someone can offer some advice.

CI DB on SQL (MSCS/Server 2003) consists of 4 files.

Disk space is running low on 1 datafile.

My proposed solution is to Create a new large partition, stop SQL, copy the data file to the new partition.

Delete the physical disk resource for the file in the cluster manager.

switch the drive letters for the old/new partitions.

Re-add the physical disk resource with the new drive letter and name.

Start SQL Server.

Do I need to worry about disk signatures under these cricumstances?

Tim

Edited by: Tim McKenzie on Sep 28, 2008 12:25 AM