Windows Forum

Ask something
Discussion Locked

SQL7-Move Database to another disk drive

0 helpful
1 reply

by ped

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

SQL7 is installed on NT4 Server w/service pack6a. my database is located on the "c" drive with only 400mb free space. the "log" file is located on the "f" drive and i want to move mydb to the "f" drive.

how can i move the file.

1 reply

by bhrdwh

You can "move" the Database "mydb" to your "I:" drive.
1. Click on "SQL Enterprise Manager" take FULL Backup of the database "mydb". Note the users / permissions given access to "mydb".
2. Copy the Database Backup file to your I: drive. (say I:\>SQLDB\MYDB)
3. Now in SQL Enterprise Manager, delete the database "mydb"
4. Restoe the database "mydb" from the location on I: drive.
That all !!
Akash

This discussion is closed to new replies.