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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Restoring a SQL2000 database to SQL7.0
- Thread starter bessebo
- Start date
- Thread starter
- #3
Thanks for the reply. So, if I only have SQL 7 on my machine and want to take a backup of a SQL2000 database from another machine, the only way I can get that database on my machine is to install SQL2000 first and restore to SQL2000. Is there any way of converting a SQL2000 database to a SQL7 format and then restoring?
BTW, thanks for responding so promptly...
Regards,
Bessebo
BTW, thanks for responding so promptly...
Regards,
Bessebo
Before you back up the SQL 2k DB, set its compatibility level to 70 with sp_dbcmptlevel. This MAY waxor some of the stuff in your db. This can't be combatted, except by making a dupe and backing that up. Then you can probably restore from the backup your 2k server makes.
- Status
Similar threads
- Locked
- Question
- Locked
- Question