Can you restore a backup made in SQL 6.5 to a SQL 7.0 server? If so, how can it be done?
Tim Gill
Gill Consulting
Tim Gill
Gill Consulting
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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Restore 6.5 Backup to 7.0 Server?
- Thread starter timgill
- Start date
Nope. From Books Online:
It is not possible to restore a database backup created using Microsoft® SQL Server™ version 6.5 or earlier. Database backups created using SQL Server 6.5 or earlier are in a format incompatible with SQL Server 7.0. To convert a database created using SQL Server 6.5 or earlier to SQL Server 7.0, you can:
Upgrade SQL Server to 7.0.
Any databases are upgraded automatically. New backups from the upgraded computer running SQL Server can now be restored into another computer running SQL Server 7.0.
Use the Data Transformation Services Import and Export wizards to copy data from one computer running SQL Server directly to another.
Use the bcp utility to copy data from a computer running SQL Server 6.5 or earlier to a data file, and then copy the data from the data file into a computer running SQL Server 7.0. Robert Bradley
Coming Soon:
It is not possible to restore a database backup created using Microsoft® SQL Server™ version 6.5 or earlier. Database backups created using SQL Server 6.5 or earlier are in a format incompatible with SQL Server 7.0. To convert a database created using SQL Server 6.5 or earlier to SQL Server 7.0, you can:
Upgrade SQL Server to 7.0.
Any databases are upgraded automatically. New backups from the upgraded computer running SQL Server can now be restored into another computer running SQL Server 7.0.
Use the Data Transformation Services Import and Export wizards to copy data from one computer running SQL Server directly to another.
Use the bcp utility to copy data from a computer running SQL Server 6.5 or earlier to a data file, and then copy the data from the data file into a computer running SQL Server 7.0. Robert Bradley
Coming Soon:
- Status
Similar threads
- Question
