dimanche 1 mars 2015

How can I run a SQL 2000 database on SQL Server 2005 Express with a different location for files


I am trying to help a client out after a server crash. The temporary replacement server has different drive letters and data file locations.


Here are the system details as I understand them:


Crashed server: MS Small Business Server, MS SQL 2000, Data - E:\path\SQLDATA\Data Temp working Server: MS Small Business Server, MS SQL Server 2005 Express, C:\Program Files...\Data


In addition, they can't find the original disks to install MS SQL Server 2000. They do have a copy of SQL Server 2005 Express.


I have tried to copy the data files (.mdf and .ldf) over and start the server. It (up) converted the master, with some "error 946" (a few times) but finished with version 611.


The model conversion did not go, as it ran into error 17207, and several others about not being able to open the file (E:...\Data\model.mdf)


Similar errors (17207) with all the other mdf/ldf files (unable to open).


Eventually it could not open the tempdb, so it shut the server down.


Is there a way for me to force it to reference the new temp server directory structure?


If so how, if not, any suggestions on recovering the data.


Thanks.





Aucun commentaire:

Enregistrer un commentaire