Results 1 to 12 of 12

Thread: Error 956 : Cannot open database version 525

  1. 11-26-2002, 09:42 AM #1
    koc
    koc is offline Registered User
    Join Date
    Nov 2002
    Location
    MD
    Posts
    26

    Error 956 : Cannot open database version 525

    I have copied a SQL Server 70 database to SQL Server 2000. Got error message during copying - 'unable to attach db' and when click on the db on SQL Server 2000, go erro - error 946 cannot open database version 525. Upgrade the database to the latest version. Anyone has any idea??
    Reply With Quote Reply With Quote
  2. 11-26-2002, 10:09 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    How did you copy that? Try backup/restore or dts.
    Reply With Quote Reply With Quote
  3. 11-26-2002, 10:11 AM #3
    koc
    koc is offline Registered User
    Join Date
    Nov 2002
    Location
    MD
    Posts
    26
    I use copy database wizard from the 2000 server and copy the database from the 70 server.
    Reply With Quote Reply With Quote
  4. 11-26-2002, 10:14 AM #4
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    I found that it works fine for copying db between sql2k servers. To copy sql7 db, I prefer other means.
    Reply With Quote Reply With Quote
  5. 11-26-2002, 10:19 AM #5
    koc
    koc is offline Registered User
    Join Date
    Nov 2002
    Location
    MD
    Posts
    26
    Thanks rmaio.

    So, what you are suggesting is that to run a backup on SQL Server 70 and restore it to the SQL Server 2000 and run db_compatibility 80??

    Thank you so much for your help.
    Reply With Quote Reply With Quote
  6. 11-26-2002, 10:22 AM #6
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Don't need to run 'db_compatibility 80' since restore will upgrade sql7 db to sql2k.
    Reply With Quote Reply With Quote
  7. 11-26-2002, 11:10 AM #7
    koc
    koc is offline Registered User
    Join Date
    Nov 2002
    Location
    MD
    Posts
    26
    rmaio,

    I tried restore the 70 database backup file to SQL Server 2000 and got error messages:

    Restore database abnormally.
    Converting database from version 515 to the current version 539
    Database running the upgrade step from version 515 to version 524.
    Database running the upgrade step from version 524 to version 525.
    Database running the upgrade step from 525 to version 526.

    Any ideas??

    Thank you!
    Reply With Quote Reply With Quote
  8. 11-26-2002, 11:53 AM #8
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Upgrade steps are normal. Does restore finish? Able to access it?
    Reply With Quote Reply With Quote
  9. 11-26-2002, 12:58 PM #9
    koc
    koc is offline Registered User
    Join Date
    Nov 2002
    Location
    MD
    Posts
    26
    NO, the restore didn't work at all.
    Reply With Quote Reply With Quote
  10. 11-26-2002, 01:15 PM #10
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    How did you do restore? What's complete error message? Did you create db on sql2k?
    Reply With Quote Reply With Quote
  11. 11-26-2002, 01:18 PM #11
    koc
    koc is offline Registered User
    Join Date
    Nov 2002
    Location
    MD
    Posts
    26
    I did create the db on my 2000 server first, then I do all task and restore database from device. I pick the backup files from a local disk and restore. The restore did started buy failed later.
    Reply With Quote Reply With Quote
  12. 11-26-2002, 03:21 PM #12
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Try restore with sql statement in query analyzer.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules