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 Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can I convert SQL Server 2000 db backup file to 7.0?

Status
Not open for further replies.

malexanian

IS-IT--Management
Nov 10, 2000
36
US
Is there any way to convert a backup of a database in SQL Server 2000 to 7.0 format so I can do a database restore in 7.0 of the file? I get a version error when I try to restore the file in SQL Server 7.0.

I cannot access the instance of SQL Server 2000 to use DTS or BCP; all I have is the full database backup. There is no other instance of SQL Server 2000 I have access to that I could restore to and DTS from. Please let me know if there are any utilities that perform this file conversion.
 
only way is restore that backup on any sql 2000 box and then do a copy database thru DTS or export it.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top