Restore .DAT file on sql server 2000 or 2005

• ALIF-662928

  SSCertifiable

  Points: 6054

  More actions

  November 13, 2009 at 11:14 am

  #216708

  Hi All,

  We have a sql 6.5 version database files abc.dat and abclog.dat,

  can anyone tell how to restore it on sql 2000 or sql 2005 server, i tried many options but didnt work, please let me know if anyone knows about it.

  Thanks

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737981

  More actions

  November 13, 2009 at 11:28 am

  #1079147

  I think you'll need to install a v6.5 server, attach those files, and then upgrade. If I remember right, you need to create a database in 6.5 using the correct disk file sizes and names, then shut down the service, and copy your files to those locations. From there, upgrade

  http://msdn.microsoft.com/en-us/library/aa197932%28SQL.80%29.aspx

  From here: http://msdn.microsoft.com/en-us/library/ms189625%28SQL.90%29.aspx, v6.5 database files cannot be attached to SQL 2000 and above.

• ALIF-662928

  SSCertifiable

  Points: 6054

  More actions

  November 13, 2009 at 11:32 am

  #1079150

  Thanks Steve,

  But is there any other way to restore this files to sql 2000 or 2005. or again thts the only way as u said.