Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-02-24 : 07:57:22
|
| Adrian writes "I am trying to upgrade a v7 (sp3?) server to SQL 2000 Enterprose Edition. The installation fails after the "Executing scripts 1 of 18" popup, returning a popup with "Error. messages.sql". What is causing this and what do I do to complete the upgrade (now restarted several times with the same error). Any suggestions appreciated." |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-02-24 : 13:38:49
|
| How are you doing the upgrade? Are you using the wizard? If so, have you tried just detaching your 7.0 database then attaching it to the 2000 SQL Server? The detach/attach causes an upgrade to happen as well. Another way to perform the upgrade is using BACKUP/RESTORE. I only use the wizard for 6.5 to 7.0 or 6.5 to 2000. The wizard isn't needed for the other types of upgrades.Tara |
 |
|
|
|
|
|
SQL 2000 upgrade failed in messages.sql