March 6, 2008 at 8:02 pm
Hi Gud Am to all we are planning to change the hard disk location of all mdf and ldf in our server (space issue) these are the ways we are thinking...
1. Stop MSSQL, Change HD Name Start MSSQL
2. Edit FileName path of mdf and ldf then stop/start mssql (not sure)
3. Backup all databases then restore using WITH MOVE
So far what we are aiming is solution number 3 because no. 1 is not advisable since there are issues with other folders in the Hard Disk. I don't know how to do no. 2 so i will also not be using that solution. By the way our sql version is 7. Are there any other faster solutions for this??
"-=Still Learning=-"
Lester Policarpio
March 6, 2008 at 9:17 pm
You may consider attach/detach approach.
March 6, 2008 at 10:31 pm
is it available in sql version 7?
"-=Still Learning=-"
Lester Policarpio
March 7, 2008 at 1:51 pm
I think so, but not 100% sure. You can right-click the desired database, and see if it is there.
March 8, 2008 at 6:53 pm
yes, it is detach/attach that is your quickest approach..sql7 has it.
_____________
Donn Policarpio
March 9, 2008 at 6:40 pm
Thanks to all we successfully transfer the databases in 1 hard disk to another not by using dettach/attach but by using backp and restore to another hard disk location. I dont see any dettach/attach in sql 7 is it available in sql 7 with no sp?
"-=Still Learning=-"
Lester Policarpio
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply