Restoring backup from MSSQL6.5 in SQL Server 2000

[Robert Kruk]

Hello,
Recently I've tried to restore backup made on SQL Server 6.5.
Unfortunately, the only version of SQL Server I currently possess is SQL
Server 2000. I have access only to that backup, because I've made it a
few years ago, and the main db file doesn't exist any more ;( I would be
grateful if you could help me a little ;)
Regards
R.Kruk

[Oscar Santiesteban Jr.]

I am not 100% sure, but you can not restore a 6.5 to 2000.
I think you have to have 6.5 running, then setup a SQL 7 and transfer it
over.
Then you can backup/restore from 7 to 2000.

Oscar....
"Robert Kruk" <r.****@poczta.onet.pl> wrote in message
news:ch**********@news.onet.pl...

Hello,
Recently I've tried to restore backup made on SQL Server 6.5.
Unfortunately, the only version of SQL Server I currently possess is SQL
Server 2000. I have access only to that backup, because I've made it a
few years ago, and the main db file doesn't exist any more ;( I would be
grateful if you could help me a little ;)
Regards
R.Kruk

[Erland Sommarskog]

Robert Kruk (r.****@poczta.onet.pl) writes:

Recently I've tried to restore backup made on SQL Server 6.5.
Unfortunately, the only version of SQL Server I currently possess is SQL
Server 2000. I have access only to that backup, because I've made it a
few years ago, and the main db file doesn't exist any more ;( I would be
grateful if you could help me a little ;)

You need to get hold of SQL Server 6.5. SQL 2000 can do as much with
that backup as Oracle can - that is, nothing.

If you have access to MSDN Subscriber Downloads, SQL 6.5 is available there.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp