|
Home > Archive > MS SQL Server > February 2006 > SQL2000, need to move a database to a different disk
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL2000, need to move a database to a different disk
|
|
| cqmman 2006-02-10, 7:23 am |
| Hello,
I have a database that is in production. The database is a SQL2000
database (SP4), but stored on c:\. I would like to move the DB to F:\.
What is the best way to do this? Backup the DB, delete it, recreate a
new DB with the same name, and restore to it?
Is there a better (or safer way!).
Cheers
| |
|
| If it's TempDB it can be moved with ALTER DATABASE
The syntax is :- ALTER DATABASE tempdb MODIFY FILE ...
OR
INF: Moving SQL Server Databases to a New Location with Detach/Attach
http://support.microsoft.com/defaul...b;en-us;Q224071
--
HTH. Ryan
"cqmman" <cqmman@yahoo.co.uk> wrote in message
news:1139576735.361564.280120@z14g2000cwz.googlegroups.com...
> Hello,
>
> I have a database that is in production. The database is a SQL2000
> database (SP4), but stored on c:\. I would like to move the DB to F:\.
>
> What is the best way to do this? Backup the DB, delete it, recreate a
> new DB with the same name, and restore to it?
>
> Is there a better (or safer way!).
>
> Cheers
>
| |
|
| YOu have two options:
-Backup and Restore at the new destination
-Detach and Attach at the new destination (see sp_detach and sp_attach
in the BOl for more information about this).
If you use the detach and attach solution I would suggest having a
valid backup first.
HTH, jens Suessmeyer.
| |
| cqmman 2006-02-10, 9:23 am |
| Thanks very much for the replies.
|
|
|
|
|