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 |
|
W00dY
Starting Member
8 Posts |
 Posted - 2008-10-31 : 12:09:11
|
| I have a sqlserver 2000 failover cluster with ten production user databases (plus a test db). I would like to move the data and log files for each of the user databases to it's own new, dedicated LUN. I am thinking of something like: offline, detach, copy the files, attach with new files, online. Is there anything else that I need to consider? I am worried about missing something in the clustering aspects... |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-10-31 : 14:25:38
|
| Your approach is what I would do. For the cluster part if you are assigning a new drive letter, you'll need to add it as a dependency to the SQL Server service. You should consider separating the data and log files onto their own drives (or mount points if you're setup for them). We use 4 mount points on our clusters: 1) system files and system databases 2) user database data files 3) user database log files 4) backup files.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
W00dY
Starting Member
8 Posts |
Posted - 2008-11-03 : 05:32:06
|
| Thank you for responding Tara, it's much appreciated. One of the reasons for the move is to provide a separate LUN for data and log files for each database on the instance. |
|
|
|
W00dY
Starting Member
8 Posts |
Posted - 2008-11-03 : 07:14:43
|
| In terms of dependencies, am I correct in assuming that I need to perform the following actions in the cluster administrator?(a) add each new LUN as a resource(b) add each new LUN resource as a dependency to the SQL Server resource |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
W00dY
Starting Member
8 Posts |
Posted - 2008-11-04 : 05:46:40
|
| Thank you once again Tara: you're a star. |
|
|
|
|
|
|
Moving data/txn files