Re: changing default drives for data and logs

From: Jacco Schalkwijk (jacco.please.reply_at_to.newsgroups.mvps.org.invalid)
Date: 07/16/04 

Date: Fri, 16 Jul 2004 13:29:32 +0100

In Enterprise Manager, right click the server, choose properties, and you
can change the default locations for data and log files on the Database
Settings tab. 

-- 
Jacco Schalkwijk
SQL Server MVP
"Dan D." <DanD@discussions.microsoft.com> wrote in message
news:7A59D230-D56F-4C14-B49B-BE3C6633C5F0@microsoft.com...
> We have attached a SAN to one of our SQL Server 2000 boxes. I want the
default drives for data and logs to change to the SAN. I tried to change the
model database thru EM but that didn't work. I tried to detach model but
that didn't work either.
>
> Is it possible to change the default drives so that when a new database is
created the data and log files will default to the SAN drives?
>
> Thanks,
> -- 
> Dan D.

Relevant Pages

  • Re: SQL 2005 Best Practice vs SQL 2000: Application Files Separate from data (and log) files
    ... You'll not be using most of the system databases intensively so you don't need to seperate them, I mean locating them on different physical disks. ... If it's being used intensively in your environment then you should locate it's log and data files on different physical disks. ... For this question you must understand the reason why we should seperate data and log files. ... Of course these drives must be physically seperated so that you'll gain performance benefits. ...
    (microsoft.public.sqlserver.setup)
  • Re: How to commit tran log to .edb
    ... new database and move all the mailboxes to it. ... On our exchange server i get the databse corruption error and from the ... A corrupt database will generally not mount. ... delete those log files. ...
    (microsoft.public.exchange.admin)
  • Re: Backup Error 0x800423F0
    ... So much for recommending that the database and log files be on separate ... drives. ... Now a machine that succesfully completed a ASR set backup prior ...
    (microsoft.public.windows.server.general)
  • Replication left the database in a weird state
    ... On my main DB Server I'm ... publishing the database, mybigdb (540Gb data file - my drive is ... the Log transactions to be marked as ... 2- There are no additional drives on the system, so all I have is the ...
    (microsoft.public.sqlserver.replication)
  • Re: How to commit tran log to .edb
    ... database corrruption error is gone. ... MVP - Exchange ... On our exchange server i get the databse corruption error and from the ... delete those log files. ...
    (microsoft.public.exchange.admin)