Results 1 to 5 of 5
  1. #1
    Join Date
    May 2003
    Location
    Washington DC
    Posts
    5

    Unanswered: MSDE to MS SQL restore

    I have a MSDE database that I am trying to restore into MS SQL 7.

    I am running the following restore from Query Analyzer;

    RESTORE DATABASE name
    FROM DISK = 'c:\mssql7\backup\name_backup'



    I am getting the following error

    Server: Msg 3624, Level 20, State 1, Line 1

    Location: upgraddb.cpp:214
    Expression: tableIndex < ARRAY_LEN (upgradeMap)
    SPID: 7
    Process ID: 748

    Connection Broken


    Is what I'm trying to do impossible or something I'm doing wrong. Any help would be much appreciated

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

    Re: MSDE to MS SQL restore

    I don't know if this will help.

    I had the same problem where I wanted to resore a MSDE database to SQL Server 2000. There was just no way. So I then used DTS to just transfer the Database to the SQL Server 2000.
    JJ Kennedy
    Double J IT Solutions
    www.doublejit.co.nz

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

  3. #3
    Join Date
    May 2003
    Location
    Washington DC
    Posts
    5

    Re: MSDE to MS SQL restore

    Originally posted by machado
    I don't know if this will help.

    I had the same problem where I wanted to resore a MSDE database to SQL Server 2000. There was just no way. So I then used DTS to just transfer the Database to the SQL Server 2000.
    I only have the backup file, I don't actually posess MSDE so as far as I know I can't actually connect to anything for a dts to work

  4. #4
    Join Date
    Feb 2003
    Location
    Auckland, NZ
    Posts
    150

    Re: MSDE to MS SQL restore

    MSDE can be distributed free and is included on the MS Office Prof. 2000/XP CDs.
    What I would suggest is installing MSDE on any other machine on your network and restoring the database to MSDE and then transfering the databse using DTS.
    JJ Kennedy
    Double J IT Solutions
    www.doublejit.co.nz

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

  5. #5
    Join Date
    May 2003
    Location
    Washington DC
    Posts
    5

    Re: MSDE to MS SQL restore

    Originally posted by machado
    MSDE can be distributed free and is included on the MS Office Prof. 2000/XP CDs.
    What I would suggest is installing MSDE on any other machine on your network and restoring the database to MSDE and then transfering the databse using DTS.
    So it is

    Thanks, I'm installing it now

Posting Permissions

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