Re: Install SS 2005 - log files best practice
- From: "Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx>
- Date: Wed, 27 Jun 2007 22:10:20 -0400
Installing the log files on a logical drive that is on the same physical
array as the data files gives you little to no advantage. It certainly does
not give you any performance benefits and it can give false hopes of such if
people don't realize it is not two separate physical drives. Hopefully you
are not looking to do lots of transactions or you may not be happy with this
setup. In a case like this I prefer to just make a single large partition
and place everything on that in separate folders. That way you don't have to
worry later on down the road if you made one partition too small or another
too large. As for placing the log file on another server that just isn't
supported.
--
Andrew J. Kelly SQL MVP
"Sandy" <Sandy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7268310D-3A65-4396-B41B-0C57F3A20BB1@xxxxxxxxxxxxxxxx
Hello -
I am a programmer, not a DBA, and have to install Sql Server 2005. We
have
a network guy who is going to be part of the Sql Server 2005 installation
project.
We just had Win 2003 Server installed on a box to be used for Sql Server.
The contractors did not partition it. We have RAID 5.
The network guy thinks it's okay to just install everything on the C
drive,
his reason being: because we have RAID 5.
From everything I've read or done, best practice is to install the log
files
on another drive, and it's my understanding that the preference is another
physical disk, i.e., another computer and if that isn't possible, install
the
logs to another logical drive on the same computer.
Can anyone point me in the right direction for articles that support my
position, and that give tangible reasons for doing same?
Also, he did suggest if we really needed another physical disk, installing
the log files on our application server -- God, I wish I was a DBA --
would
that make sense?
Any light anyone can shed on this will be more than appreciated!
--
Sandy
.
- Follow-Ups:
- Re: Install SS 2005 - log files best practice
- From: Sandy
- Re: Install SS 2005 - log files best practice
- Prev by Date: How do I uninstall SQL Server 2005 from Vista when uninstall and manual attempts fail
- Next by Date: RE: How do I uninstall SQL Server 2005 from Vista when uninstall and manual attempts fail
- Previous by thread: How do I uninstall SQL Server 2005 from Vista when uninstall and manual attempts fail
- Next by thread: Re: Install SS 2005 - log files best practice
- Index(es):
Relevant Pages
|
