Monday, March 12, 2012

HELP ! Database Restore version problem

I have a database that was backed up from SQL 7, restored onto SQL 2K - and now need to return it to SQL 7.

I have attempted this and get:

Error 3169: The backed-up database has on-disk structure version 539. The server supports version 515 and cannot restore or upgrade this database.

If anyone could let me know either way please do !

DonaldRE: I have a database that was backed up from SQL 7, restored onto SQL 2K - and now need to return it to SQL 7. I have attempted this and get: Error 3169: The backed-up database has on-disk structure version 539. The server supports version 515 and cannot restore or upgrade this database. If anyone could let me know either way please do !
Donald

Q1 [Can Sql Server 2k backup dumps be restored to Sql Server pre 2k versions]?
A1 No.

Q2 [How may one get a Sql Server 2k DB onto Sql Server pre2k]?
A2 Use DTS, or generate ddl sql scripts and then BCP data into your DB.

No comments:

Post a Comment