Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2003
    Posts
    2

    Unanswered: problem upgrading sql 7.0 to sql 2000

    I am having a problem upgrading sql 7.0 to sql 2000 i keep getting
    "Error running script: upgrade.sql(1)" I search and the only fix I found was to download an updated setup.ins file. I tried that and I still get the error message. The install of sql 7.0 is set to "binary" for the collation.
    I uninstalled sql 7.0 on my test server and reinstalled 7.0 using "generic unicode and ran the sql 2000 upgrade again and it went through with no problems. But my production server is sql 7.0 with "binary" collation and I need to know if there is any way to upgrade it to sql 2000.
    Please can someone help me. Thanks Mike

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Where exactly you're getting this error during upgrade?
    Search for more information on SQLSTP.LOG file.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Apr 2003
    Posts
    2
    Originally posted by Satya
    Where exactly you're getting this error during upgrade?
    Search for more information on SQLSTP.LOG file.
    The setup gets to 100% and then it says
    "setup is initalizing the server for the upgrade process" then I get the
    "Error running script: upgrade.sql (1) I checked the sqlstp.log and I not sure what to look for. I attached the sqlstp.log file so you can have a look if you like.

    Thanks for the reply,
    Mike


































































    i
    Attached Files Attached Files

Posting Permissions

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