We have attached a SAN to one of our SQL Server 2000 boxes. I want the defau
lt drives for data and logs to change to the SAN. I tried to change the mode
l database thru EM but that didn't work. I tried to detach model but that di
dn't work either.
Is it possible to change the default drives so that when a new database is c
reated the data and log files will default to the SAN drives?
Thanks,
--
Dan D.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.|||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...
> default drives for data and logs to change to the SAN. I tried to change t
he
> model database thru EM but that didn't work. I tried to detach model but
> that didn't work either.
> created the data and log files will default to the SAN drives?
>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment