Re: changing db location on sql2000
- From: "Kevin3NF" <kevin@xxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 12 Feb 2008 10:28:51 -0600
Yes....specify it when you create the database. The default that pops up in
the GUI is based on where teh model database is, if I remember correctly.
SQL 2008 allows this to be set at install-time....very cool new feature for
those of us with hundreds of SQL installs :)
--
Kevin3NF
SQL Server dude
You want fries with that?
http://kevin3nf.blogspot.com/
I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.
"cj" <cj@xxxxxxxxxxxxx> wrote in message
news:uD%239bLZbIHA.1208@xxxxxxxxxxxxxxxxxxxxxxx
I think I'll stick to righ clicking for now. That works, I managed to copy
the database I need moved. Do you know how to change the default location
it saves new databases?
Kevin3NF wrote:
Right click the datbase, all tasks, detach database. Move the files to
D. Right click "Databases", all tasks, attach database
Or you can do the same things with sp_detach_db and sp_attach_db if you
are happier in code
.
- References:
- changing db location on sql2000
- From: cj
- Re: changing db location on sql2000
- From: Kevin3NF
- Re: changing db location on sql2000
- From: cj
- changing db location on sql2000
- Prev by Date: Re: changing db location on sql2000
- Next by Date: Re: changing db location on sql2000
- Previous by thread: Re: changing db location on sql2000
- Next by thread: Re: changing db location on sql2000
- Index(es):
Relevant Pages
|
