Restoring backup from MSSQL6.5 in SQL Server 2000

#1 (**permalink**) 02-29-2008, 05:09 AM

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

#2 (**permalink**) 02-29-2008, 05:09 AM

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.kruk@poczta.onet.pl> wrote in message
news:chc222$hmm$1@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

#3 (**permalink**) 02-29-2008, 05:09 AM

Robert Kruk (r.kruk@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, esquel@sommarskog.se

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode