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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment