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

move SQL data files to same letter drive but different disk

Hi,
We need to move our sql data files to new disks. Current
data are on drive D, F. New disks are U,V. We want to
move data files on D to U and F to V. Then rename U to D
and V to F (after rename original D & F to X & Y).
The quesions are
if SQL server is shutdown before this, will SQL Server
see the same data file?
Will I need to do a dettach/attach even the data file
will be on same path at the end?
Thanks.
Haii believe if you do this in correct order you don't have any problem:
1. stop SQL service
2. move the files (.mdf and .ldf)
3. rename D:, F: to X:, Y:
4. rename U:, V: to D:, F:
5. start SQL service
don't know if a reboot after step 4 would help but why don't you try it?
"Hai Le" <hle@.coair.com> wrote in message
news:02d401c3dac8$70e9a2e0$a101280a@.phx.gbl...

quote:

---

> Hi,
> We need to move our sql data files to new disks. Current
> data are on drive D, F. New disks are U,V. We want to
> move data files on D to U and F to V. Then rename U to D
> and V to F (after rename original D & F to X & Y).
> The quesions are
> if SQL server is shutdown before this, will SQL Server
> see the same data file?
> Will I need to do a dettach/attach even the data file
> will be on same path at the end?
> Thanks.
> Hai

---

Move DTS package to another server

I'm building a DTS package on my development server which I want to
move to my test server. I can save the file and import it, but there
are connections etc that will be named differently.

Is there a quick and easy way of changing the names of connections ? I
also have some CSV files used for import/export (quicker than table
copy for my needs), but again I will need to change the path.

How can I do this without having to check each component ?

Thanks

Ryan"Ryan" <ryanofford@.hotmail.com> wrote in message
news:7802b79d.0402130529.230f2596@.posting.google.c om...
> I'm building a DTS package on my development server which I want to
> move to my test server. I can save the file and import it, but there
> are connections etc that will be named differently.
> Is there a quick and easy way of changing the names of connections ? I
> also have some CSV files used for import/export (quicker than table
> copy for my needs), but again I will need to change the path.
> How can I do this without having to check each component ?
> Thanks
> Ryan

Have a look at some of these articles:

http://www.sqldts.com/default.aspx?101

One possible approach is to define global variables in the packages for the
connection properties. Then at the start of the package, set the connection
properties with a Dynamic Properties task. Since you can specify global
variable values on the command line using DTSRUN.EXE, this is also a handy
way to pass in the properties from a batch file.

Simon