Copying Entire Database

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?
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)
[vbcol=seagreen]
|||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.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:uKn0QvisEHA.2556@.tk2msftngp13.phx.gbl...
> 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)
>
>