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 |
|
shaminda
Starting Member
25 Posts |
 Posted - 2012-03-02 : 15:59:05
|
| This weekend we are planning on changing the drive on our SQL Server 2000 cluster. I saw in of the forums that others have done this. Here is the lnk:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=62093Here is what we are planning on doing: Turn off MSSQLSERVER serviceTurn off SQLSEVERAGENT serviceCopy the files to the new driveRename drive F: to a different letterAfter the copy is complete rename the new drive to F:Turn on the two servicesSo the question I have is do we keep both servers on while we copy the data? And do we turn the services off from cluster administrator or from Administration Tools? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
shaminda
Starting Member
25 Posts |
Posted - 2012-03-07 : 11:08:38
|
| Thanks tkizer! This past weekend we moved the data to the new drive. The only problem we had was, we had folder paths that were longer than 256 characters. We had to use Robocopy to copy the data to the new drive. Other than that every thing else was a breeze. Performance on our clients have improved significantly since we changed to the new drive. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
moving SQL server data to a new drive