Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Restore Sql 200 database on Version 7

Status
Not open for further replies.

azwaan

Programmer
Jan 11, 2002
42

is there anyway i can restore a Sql server 2000 backup on version 7..or any other way i can use the same database on version perhaps by attching the database
 
Everything I have seen says you can't go backwards.

You can restore a SQL Server 7 to SQL Server 2000, but not the other way.

-SQLBill
 
Correct, you can not go backwards. To get a database from SQL 2000 to SQL 7 you will have to recreate the tables and DTS the data over.

Denny

--Anything is possible. All it takes is a little research. (Me)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top