[dba-SQLServer] New SQL Server install

John,
  You are still going to have to go through the installation of Sql Server
even if you put the *system* files over on another directory.  I don't know
what you would gain.  Typically file management on Sql involves data files
and transaction log files.  It might be advantageous to put the *system*
files on another partition that has more space in case you have a log file
(sql service log or sql agent log) that won't roll over and continues to
grow, but you ought to be able to catch that by regular maintenance of your
system.

More than likely what you may wish to do is to create an "unattended
install" script, this way the next time you need to re-install sql server
2008, you can do so with one quick command and have everything else work
*auto magically*


for a quick guide on how to create your *own* unattended install script,
check out this post, it's fairly step by step and easy to follow, however if
you should have any trouble just post back and I'll see where I can help.
http://www.codeproject.com/Articles/113480/SQL-Server-2008-R2-Unattended-Silent-Install.aspx



-Francisco
http://bit.ly/sqlthis   | Tsql and More...




On Tue, Sep 28, 2010 at 7:19 AM, jwcolby <jwcolby at colbyconsulting.com>wrote:

> I am about to bring up a new server, Windows 2008 and SQL Server 2008.  I
> know from experience that
> SQL Server likes to put it's system files buried in a path in C:.  Is it
> possible, and if so is it
> useful to move those files off to another file on my raid controller.
>
> As it stands, I have all of my data files on drives physically connected to
> a raid controller card.
>  I will need to move that entire raid card and all the disks into the new
> server.  I know from
> experience that I have to jump through some hoops to find and mount all of
> the databases.
>
> So my question really is, if whatever SQL Server stores in the C: path were
> to be put on another
> drive (D:) on my raid controller during the next install, the *next time* I
> have to go through this,
> can I install SQL Server and tell it "use these system files" - the ones
> that were in C: but now are
> on D: (on the raid drive)?
>
> Or am I dreaming and just need to disconnect and reconnect on the new
> system?
>
> --
> John W. Colby
> www.ColbyConsulting.com
>