Re: Set seperate Log/Data file locations during install
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
I don't believe so. Generally it's only really tempdb that needs to be moved
for IO throughput reasons. master and msdb tend to remain small enough for
that to be irrelevant. tempdb can be moved using ALTER DATABASE so it's not
really that much hassle but I agree it would be handy to be able to define
the default locations suring install.
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Dan" <Dan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9DA35413-5EFF-4E5C-860B-396A7463A081@xxxxxxxxxxxxxxxx
>I have a new SQL Box built with 3 drives, with the following intended
>usages:
> C: OS & Prog Files
> D: Log Files
> E: Data Files
>
> During the SQL install process you are allowed to specify the location for
> all data files but there is no way to specify one location for log files
> and
> a
> second for data files. Without specifying the 2 locations during the
> install, master/model/tempdb all ended up with their log and data files on
> the same drive and I have to go through the long process of detaching and
> reattaching them. Is there any way around this problem?
>
> -Dan
.
Relevant Pages
- Re: SQL 2005 Best Practice vs SQL 2000: Application Files Separate from data (and log) files
... choice to install sql server binaries of the SQL Server on C drive, ... appears that I am not given the choice to install system databases/log files ... drives must be physically seperated so that you'll gain performance ... We are physically separating log and data files on separate disks. ...
(microsoft.public.sqlserver.setup) - Re: Primary File Group full
... SQL Server tries to grow as per the increment specified for the file. ... > the data files. ... Some disks is almost out of disk space but ... >>> in the database that i am creating, ...
(microsoft.public.sqlserver.server) - Re: SQL 2005 Best Practice vs SQL 2000: Application Files Separate from data (and log) files
... button in the "Components to Install" window in SQL Server 2005 Setup. ... In 2005 I appear not to be given the choice to install sql server binaries of the SQL Server on C drive, it appears that I am not given the choice to install system databases/log files on a separate drive, as I could in 2000. ... If it's being used intensively in your environment then you should locate it's log and data files on different physical disks. ... Of course these drives must be physically seperated so that you'll gain performance benefits. ...
(microsoft.public.sqlserver.setup) - Re: How to recreate/restore the database from the data and log files
... 2)You can use the option 'Attach Database' In Sql EnterPrise manager to ... 3)Open the enterprise manager - Click on your Sql Server group... ... Browse the your Data Files file.... ...
(microsoft.public.sqlserver.tools) - Re: How to recreate/restore the database from the data and log files
... Reinstall SQL Server and place the data files in the same directory ... > log files and the data files of the database were on another hard ...
(microsoft.public.sqlserver.tools) |
|
