Hi, we have a copy of SQL Server 2000 running happily on a production server.
Unfortunately, we have realised that the server was set up wrongly, with the data partition (F) on the same Raid 1 drive as the operating system. We've been advised to move the data onto the currently-unused Raid 5 drives.
Our infrastructure team have offered to copy the files across, and rename the partitions so that the new partition is now the F drive.
Can anyone tell me if this would work?
Alternatively, I know there is a Knowledgebase article explaining how to detach and reattach each database, complete with additional steps for the system databases.
Could anyone please advise which of these options would be better/safer/less downtime etc.
asked Nov 10 '09 at 12:17 PM in Default
As long as the SQL Server service is shut down during the operation, and the file names remain the same before and after, then you should be able to re-start without incident. To be honest, you don't really need to detach and re-attach if the files are going to be in the same locations afterwards as far as the file system is concerned. It won't really affect the time taken in doing so.
However, one thing you should definitely do is back up your databases first.
answered Nov 10 '09 at 12:35 PM
Matt Whitfield ♦♦