Moving a Database

I have a few databases that is clogging up my C drive and I would like to
move them to my D: drive.
What is the easiest and safest way to do that?Hi,
just
-detach them from drive c:
-copy over to drive d:
-attach on drive d:
You can either use thhe GUi for attach /detach or use the sp_detach /
sp_attach statement / procedure for that, more details can be found in
the BOL.
HTH, jens Suessmeyer.
http://www.sqlserver2005.de
--|||Cool, thank you.
But where is the GUI located for that?
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1145564475.673288.28790@.g10g2000cwb.googlegroups.com...
> Hi,
> just
> -detach them from drive c:
> -copy over to drive d:
> -attach on drive d:
> You can either use thhe GUi for attach /detach or use the sp_detach /
> sp_attach statement / procedure for that, more details can be found in
> the BOL.
> HTH, jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>|||Hi,
depends on which version of SQL Server you are using. If you use the
client tools for SQL 2000 you lopen the enterprise manager, navigate to
the database you want to detach, right click, select detach, copy the
files, right click on the Server, select attach, browse to the
destination and you are done.
It is nearly the same for SQl Server Management Studio and SQl Server
2005.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--|||How or where do I find teh GUI?
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1145564475.673288.28790@.g10g2000cwb.googlegroups.com...
> Hi,
> just
> -detach them from drive c:
> -copy over to drive d:
> -attach on drive d:
> You can either use thhe GUi for attach /detach or use the sp_detach /
> sp_attach statement / procedure for that, more details can be found in
> the BOL.
> HTH, jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>|||You didn=B4t say yet which version of SQL Server you are using.sql

Moving a Database

I have a few databases that is clogging up my C drive and I would like to
move them to my D: drive.
What is the easiest and safest way to do that?Hi,
just
-detach them from drive c:
-copy over to drive d:
-attach on drive d:
You can either use thhe GUi for attach /detach or use the sp_detach /
sp_attach statement / procedure for that, more details can be found in
the BOL.
HTH, jens Suessmeyer.
--
http://www.sqlserver2005.de
--|||Cool, thank you.
But where is the GUI located for that?
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1145564475.673288.28790@.g10g2000cwb.googlegroups.com...
> Hi,
> just
> -detach them from drive c:
> -copy over to drive d:
> -attach on drive d:
> You can either use thhe GUi for attach /detach or use the sp_detach /
> sp_attach statement / procedure for that, more details can be found in
> the BOL.
> HTH, jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>|||Hi,
depends on which version of SQL Server you are using. If you use the
client tools for SQL 2000 you lopen the enterprise manager, navigate to
the database you want to detach, right click, select detach, copy the
files, right click on the Server, select attach, browse to the
destination and you are done.
It is nearly the same for SQl Server Management Studio and SQl Server
2005.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--|||How or where do I find teh GUI?
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1145564475.673288.28790@.g10g2000cwb.googlegroups.com...
> Hi,
> just
> -detach them from drive c:
> -copy over to drive d:
> -attach on drive d:
> You can either use thhe GUi for attach /detach or use the sp_detach /
> sp_attach statement / procedure for that, more details can be found in
> the BOL.
> HTH, jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>|||You didn=B4t say yet which version of SQL Server you are using.