Monday, February 20, 2012

OS and SQL Server installed on seperate drives.

We have a server with one IDE drive which is where the OS
in located. We have recently purchased a SCSI drive and
intend on installing SQL Server 2000 on it. Is anyone
aware of any problems that could arise from having the OS
and SQL server on seperate drives? Thanks a lot!No issues that I know of. In fact, having more drives to spread out the I/O
is strongly encouraged.
--Brian
(Please reply to the newsgroups only.)
"Mark" <anonymous@.discussions.microsoft.com> wrote in message
news:398b01c4014b$1477d870$a601280a@.phx.gbl...
> We have a server with one IDE drive which is where the OS
> in located. We have recently purchased a SCSI drive and
> intend on installing SQL Server 2000 on it. Is anyone
> aware of any problems that could arise from having the OS
> and SQL server on seperate drives? Thanks a lot!|||Hi Mark.
There's no problem with separating the drives that the o/s & SQL Server are
on, but you should be aware that by far the most important components to
separate onto different physical disks are SQL Server's .mdf & .ldf files.
There are significant performance and recoverability issues that stem from
this separation and it's the thing that most inexperienced people get wrong.
Regards,
Greg Linwood
SQL Server MVP
"Mark" <anonymous@.discussions.microsoft.com> wrote in message
news:398b01c4014b$1477d870$a601280a@.phx.gbl...
> We have a server with one IDE drive which is where the OS
> in located. We have recently purchased a SCSI drive and
> intend on installing SQL Server 2000 on it. Is anyone
> aware of any problems that could arise from having the OS
> and SQL server on seperate drives? Thanks a lot!

No comments:

Post a Comment