Installing SQL Server 2005 on Windows 2003 Server (RAID 5) - need advice
- From: Learner <pradev@xxxxxxxxx>
- Date: Tue, 13 Nov 2007 10:55:39 -0800
Hi,
We are currently running our databases on Sql server 2000. As an
upgrade to move our databases we bought a brand new machine and unlike
the regular machines with just one hard disk this machine has the
following hard disk configuration.
It has 6 physical hard disks of 72 GB each (is it called RAID
machine?)
2 of the hard disks are mirrored (I guess it is called RAID1 please
correct me if I am wrong) and these two made C: drive.
The remaining 4 hard disks made D: drive and are setup at RAID 5.
We just installed Windows 2003 Server OS on C: drive (on RAID 1 or
mirrored hard disks) and I guess this good. Please advise if not.
Now the next step is to install SQL Server 2005 and here is our idea
on how where to install it on:
1).Install the Sql Server 2005 Enterprise version on D: drive (RAID 5)
2).Put the .mdf fiile on D: drvie (RAID 5) itself
3).Put the .ldf file on C: drive (RAID 1)
I need to mention here that I am new to this RAID stuff so would like
to take advice on where to install the Sql server 2005 as a software,
and where to pu the .mdf files (fiile groups), and where to put
the .ldf files.
Hope my explanation above gives a clear idea of what we have and what
we are trying to do
Please take a moment to advise me in the right direction.
Thanks,
-L
.
- Follow-Ups:
- Prev by Date: Re: Poor stored procedure performance on multicore comp.
- Next by Date: Re: Installing SQL Server 2005 on Windows 2003 Server (RAID 5) - need advice
- Previous by thread: Poor stored procedure performance on multicore comp.
- Next by thread: Re: Installing SQL Server 2005 on Windows 2003 Server (RAID 5) - need advice
- Index(es):
Relevant Pages
|
Loading
