sql server replication: I am trying to copy the MSSQL7 Database from one Server to Another.

On Server "A", the MSSQL7/Data Directory is on the "D:" Partition.

On Server "B", the MSSQL7/Data Direcotry is on the "E:" Partition.

I have copied the entire Data directory from Server "A" to Server "B".

Now when I try to start the MSSQL Service on Server "B". the ERRORLOG shows
that the Model.mdf could not be found at: "D:\MSSQL7\Data\Model.mdf". And,
the MSSQL Service fails to start.

Is there a way to tell MSSQL Server that all of the databases that were on
the "D:" partition are now located on the "E:" Partition?

Thank you Paul.
The documentation there is very thorough, except for one thing. I have read
through similar documentation, and am performing a move very similar to the
situation in the link you provided. However, in the examples they are
documented in cases where the Logical Drive is the same (i.e. moving from a
"D:" drive on ServerA to a "D:" drive on ServerB).

In my situation, i need to move from a "D:" Drive on ServerA to a "E:" Drive
on ServerB. I cannot rename the drives because of other (backup) software
that is already installed on the "D:" Logical Drive on this server. In my
case, when I try to start SQL Services, the LOGERROR shows an error of:
"Unable to find D:\MSSQL7\DATA". That is because it is now on the "E:"
drive...

Thank you for your information. The steps in the link you provided were
much more in depth than what I was doing, and I did learn a couple of things
in there.

-- Will G.


[quoted text, click to view]

Will,
things are a fair bit more complicated than just moving the directories.
Vyas has compiled a series of information and links that can help you:
http://vyaskn.tripod.com/moving_sql_server.htm
HTH,
Paul Ibison (SQL Server MVP)

[quoted text, click to view]