I have an old SQL Server 2000 machine in a clustered environment. The data files are on Disk S: which is running out of space. I have another Disk B: in the same disk array which has lot of space. I want SQL Server to use the Disk B: instead of Disk S:
How do I setup SQL Server to store the data files on Disk B?
Any help would be greatly appreciated.