Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2010
    Posts
    1

    Unanswered: Microsoft SQL 2000cRestore error

    Hi everyone,

    I have this pressing problem. I want restore my sql database backuped from one server to another, but each time try to do that, following error prompts up:
    Microsoft SQL-DMO (ODBC SQLState:HY000
    Location: upgraddb.cpp:214
    Expression: tableIndex < Array_Len(upgradeMAP)
    SPID:9
    ProcessID:2080

    I am using Sql 2000, even though i have both 2000 and 2005 installed on the destination machine.

    I will be glad someone advise me on what to do to solve this.
    Thank you

  2. #2
    Join Date
    Feb 2003
    Location
    Auckland, NZ
    Posts
    150
    Hi There,

    This is possibly because you are trying to restore a SQL 2005 Database to a SQL 2000 Server. Can you confirm the version of SQL Server the backup was done on?
    JJ Kennedy
    Double J IT Solutions
    www.doublejit.co.nz

    VB 6, VB.NET, ASP.NET, MS SQL Server, MySQL, MS Access

Posting Permissions

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