Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Location
    Nottingham - UK
    Posts
    113

    Unhappy Unanswered: 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 !

    Donald

  2. #2
    Join Date
    Oct 2002
    Posts
    369
    RE: 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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •