how to copy database from one drive to another drive in sql server?

You can copy databases using two techniques:
1. Detach the databases from the server, copy the DatabaseName.mdf and DatabaseName.ldf files to the drive you want to copy to, and finally, attach the database by selecting the files from the new drive.
2. Backup the database and then restore it using 'WITH MOVE' and 'REPLACE' options.

Muschi.

Thankyou muschi.it's very helpful.

Before moving make a current backup of all databases.
you must have sys admin(sa) permissions
you should know the data file and log file locations

If you unaware of location of data and log files, can find it
using sp_helpfile stored procedure.

use <database_name>
go
sp_helpfile
go


to move database you can use attach/detach stored procedures

first detach database you want to move



use master
go
sp_detach_db 'database_name want to move'
go

next copy data and log files from the current location to new location

then re-attache the db to new location as follow

use master
go
sp_attach_db 'db_name','new location .mdf file','new location of .ldf file'
go

The question looks to be abandoned by the user who asked it. If no action is taken within 2 days, a Quomon Moderator will consider closing the question and distributing the points.

The Quomon Team

thank you verymuch