changing default drives for data and logs

From: Dan D. (DanD_at_discussions.microsoft.com)
Date: 07/16/04 

Date: Fri, 16 Jul 2004 05:22:01 -0700

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: Database/Log placement
    ... The idea behind seperating the logs and database files to different physical ... a SAN shares all physical drives and breaks them out ...
    (microsoft.public.exchange.admin)
  • SAN
    ... Right now I put the logs on one drive and data file on ... "When you go to the SAN we will install Powerpath ... dual 2GB fibre channels. ... If you want separate drives we ...
    (microsoft.public.sqlserver.server)
  • Re: Drive Allocations for SQL2005 via iSCSI
    ... It is always a good idea to physically separate the logs from the other data ... different physical drives. ... We will be connecting the server to an iSCSI SAN. ...
    (microsoft.public.sqlserver.setup)
  • RE: Running diskpar.exe on SAN drives
    ... I would first check wit hyour SAN manufacturer about using this utility on ... > I'm confused how I run this against a set of SAN drives, ... > logs volume. ... > ask says to use the old diskpar utility. ...
    (microsoft.public.exchange.admin)
  • Re: ingres locations and SAN
    ... Companies will often take the largest disk drives possible for the SAN ... System Administrators will typically make everything RAID 5 ... to get the faster drives for the Ingres configuration and won. ...
    (comp.databases.ingres)
Loading