Question about SQL cluster



We currently have a SQL cluster with two nodes (active/passive). The
transaction logs are currently on the same RAID partition as the databases,
and we're looking to move them off to their own partition. We are planning
to do this by purchasing five new Ultra SCSI 3 15,000 rpm drives, and use
that new RAID solely for the transactions logs. My question is what steps
will need to be taken once we have the drives in place and the new array
set? Since this is a production application, we need as little downtime as
possible.



Thanks a million in advance!

Create the RAID container. FYI, I would use RAID-10 and four drives rather
thatn RAID-5 with 5 drives.
Rescan the physical disks in Disk Manager.
Partition and format the disk.
Create a physical disk resource in the Cluster Administrator tool for the
new disk.
Test moving this disk to each node and make sure it can be brought online
and is visible.
Move the disk to the same node as SQL Server. The following steps must be
done from the node currently hosting the SQL instance.
Move the disk to the SQL server resource group.
STOP SQL SERVER
Using the Cluster Administrator tool, make the SQL Server service dependant
on the new disk.
START SQL SERVER
You can now move the log files using any of the normal database file
movement techniques.



--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

"Adam Freden" <Adam.Freden (AT) cpsa-rbha (DOT) org> wrote