jwcolby
jwcolby at colbyconsulting.com
Tue Sep 28 16:12:52 CDT 2010
Thanks Francisco, I will take a look at that unattended install thing. I already put the log files out on a separate raid volume (raid 0) just to get the speed up. John W. Colby www.ColbyConsulting.com On 9/28/2010 10:55 AM, Francisco Tapia wrote: > 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 >> > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >