Moving Database to another locationgreenspun.com : LUSENET : SQL Server Database Administration : One Thread
I have installed SQL 7. I am running out of disk space on one of the drives. I want to move the big databases to the new drive.
I have used the sp_detach_db to detach the database. I moved the .MDF file to the new folder on the new drive. However, when I run the sp_attachdb command, I get an error message.
Have you done this task before. I appreciate your help on this and how you would go about doing it.
-- Anonymous, February 06, 2000
Why don't you create a disk dump device on the new drive and back up your large database to it. Then you can create an identical database on the new drive and then restore from the disk dump device. Be sure to validate all of your data structures and data before dropping the old database.
-- Anonymous, February 07, 2000