VGillingham
SSC Journeyman
Points: 92
More actions
December 2, 2003 at 9:44 am
#160203
Hi,
How can I move my sql7 databases from one drive to another without using query analyzer on NT ?
guarddata
SSCertifiable
Points: 6583
December 2, 2003 at 1:55 pm
#484360
The easiest ways I know are:
1) Detach the database, move the files, reattach.
2) Backup the original, drop the database, restore with the new path.
Guarddata-
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply