Open SQL
Select DB Name
Right click on DB
Select properties
Click on Files
You will find where .mdf .ldf files are located in the server.
Now you need to move this files in to another drive.
Step1:
Select DB
Right click -->Tasks-->Detach
Check Drop, Update check boxes in the new window
Ok
Now you have Detached DBs from SQL
Step 2:
Move .mdf .ldf files to another location.
Cut from current location and paste another location.Ex: form c to D
Step 3:
Attach the DB
Right click on database
Click Attach
Select .mdf file from your new location
Ok
Done..
Select DB Name
Right click on DB
Select properties
Click on Files
You will find where .mdf .ldf files are located in the server.
Now you need to move this files in to another drive.
Step1:
Select DB
Right click -->Tasks-->Detach
Check Drop, Update check boxes in the new window
Ok
Now you have Detached DBs from SQL
Step 2:
Move .mdf .ldf files to another location.
Cut from current location and paste another location.Ex: form c to D
Step 3:
Attach the DB
Right click on database
Click Attach
Select .mdf file from your new location
Ok
Done..
