Moving the Data directory in Desktop Edition

Is it possible to change the location of the databases on the desktop
edition? Thanks
Have a look here: http://www.support.microsoft.com/?id=224071
Andrew J. Kelly SQL MVP
"boe" <boe_d@.hotmail.nospam.com> wrote in message
news:uI1dKyy3EHA.2180@.TK2MSFTNGP10.phx.gbl...
> Is it possible to change the location of the databases on the desktop
> edition? Thanks
>
|||Whoops - sorry it looks like I may asking the wrong question. If I have no
SQL databases (but SQL DE is installed) and want to change where it creates
a new one is this possible? I won't need to migrate the data just change
the default location.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:uCgCX943EHA.3616@.TK2MSFTNGP11.phx.gbl...
> Have a look here: http://www.support.microsoft.com/?id=224071
> --
> Andrew J. Kelly SQL MVP
>
> "boe" <boe_d@.hotmail.nospam.com> wrote in message
> news:uI1dKyy3EHA.2180@.TK2MSFTNGP10.phx.gbl...
>
|||Right click on the server node in Enterprise Manager and choose Properties.
Under the database settings tab you can specify the default database
directories. You can also specify the location in the Create Database
command.
Andrew J. Kelly SQL MVP
"boe" <boe_d@.hotmail.nospam.com> wrote in message
news:uYWNZF93EHA.2192@.TK2MSFTNGP14.phx.gbl...
> Whoops - sorry it looks like I may asking the wrong question. If I have
> no SQL databases (but SQL DE is installed) and want to change where it
> creates a new one is this possible? I won't need to migrate the data just
> change the default location.
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:uCgCX943EHA.3616@.TK2MSFTNGP11.phx.gbl...
>