November 13, 2009 at 11:14 am
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
November 13, 2009 at 11:28 am
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.
November 13, 2009 at 11:32 am
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply