Recovering a database from a .DAT file 1

[dg043]

I had an installation of SQL Server 6.5 which maintained several databases. The server running this crashed and all I have left is the .DAT files which represent the data and log devices for each database. I have read that it is pssible to restore databases created in SQL Server 7.0 or above (i.e. .mdf and .ldf files) but is it possible to restore from 6.5 (.DAT files)? This restore process can be carried out on SQL Server 2005 if necessary, as I have now upgraded to that version.

Dan Griffiths
Software Analyst
National Grid plc

 

[mutley1]

Hi dg043,

I used this article ages ago - if you have all the system and user DAT files it is easier, but it can be done.

http://www.mcse.ms/archive81-2005-5-1644837.html

HTH,

M.

 

[dg043]

Great! Thanks for the help. If I can use DISK REINIT I will but we will probably just buy the Auto Recovery software

Dan Griffiths
Software Analyst
National Grid plc