move ms/sql database files to another disk
Posted on 2005-04-21
I have an MS/SQL server (7.0) installed on one machine, says the production machine.
All databases are on its D: drive.
For test purpose, I have installed a fresh MS/SQL server on another (test) machine. But on this machine, there is no space enough on the D: drive. I need to have everything says on the F: drive.
I have no problem to dump/restore databases but I want to know if there is another way. I mean. I have stopped the production machine and copied all the database physical files d:\mssql7\data to the other machine f:\mssql7\data through a network connection.
But when I start the test machine, it does not find other database than the master. I suppose that the physical location of the other databases is somewhere indicated in the master and this says D: not F:
So how to easily change that so that it finds all these databases on F: ?