Re: 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:36:02 -0700

Wonderful. Thanks. 

-- 
Dan D.
"Jacco Schalkwijk" wrote:
> 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: New Install of SBS 2003?
    ... Dan typed: ... localy and have them install the sofware at my local computer guru's ... You lose two drives? ... I do believe in overengineering ones' server. ...
    (microsoft.public.windows.server.sbs)
  • Re: New Install of SBS 2003?
    ... Dan typed: ... our peer to peer. ... Can you add in a RAID controller and get SCSI drives? ... We have a server tower designed to hold multiple harddisks. ...
    (microsoft.public.windows.server.sbs)
  • Re: New Install of SBS 2003?
    ... Dan typed: ... What if I went with a raid ... Would it be easy enough to add drives or would I need some major ... If it's worth putting a server in, I think it's worth getting the right ...
    (microsoft.public.windows.server.sbs)
  • Re: OWA 2003 in DMZ ?? --->> DAN
    ... Never mind Dan. ... i realize that the cert for the BE would ... > configuration (two ports and a protocol to set up IPSec, ... > server will talk with. ...
    (microsoft.public.exchange.admin)
  • Re: Add remote client PC...remotely! (problem)
    ... "Dan Freer" schreef in bericht ... > following information can help you troubleshoot your DNS configuration. ... >>> PPP adapter RAS Server Interface: ... >>> Ethernet adapter Server Local Area Connection: ...
    (microsoft.public.windows.server.sbs)
Loading