Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 3 replies
  • Subscribers 1 subscriber
  • Views 1259 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Upgrade fails with SQL error

amcmis

I have 3 instances of SEC running at 3 sites, and while they should all have been identical upgrades (from 4.0 to 4.7) one site failed with the following installDB.LOG. The installer went through some rollbacks, warning me that I will need to re-run the installer. Now the installer fails with a statement that I need to fully removeUpdate Manager first. So I guess it was not a thorough rollback?

InstallDB SERVER2\SOPHOS SERVER2 SOPHOS47 InstallDB.log
Started
Tue 05/31/2011
01:09 PM
==========
Msg 945, Level 14, State 2, Server SERVER2\SOPHOS, Procedure From3To47, Line 34
Database 'SOPHOS3' cannot be opened due to inaccessible files or insufficient memory or disk space.  See the SQL Server errorlog for details.

Any ideas for recovery? Any danger in uninstalling manually from Add/Remove?

:13551


This thread was automatically locked due to age.
  • 0

    HI Amcmis

    If the 'Sophos Update Manager' is inthe Add/Remove programs, uninstall it.

    I suspect you will still get the same issue.

    Install SQL Management Studio and remove the Sophos3 db.

    (Please do a backup first)

    Once the Sophos3 DB has been removed, try the upgrade again.

    :)

    :13557
  • 0

    SUM was missing from add/remove, but I followed another posts instructions to find a reg entry and directly launched uninstaller from msiexec, which appeared to work. I then did indeed get the same issue. I am wondering what is going on here, as I have 3 basically identical sites following the same timeline, all starting with a 3.x console that was upgraded to 4.0 some time ago.

    Does this mean I lost the DB? Or I will be able to take the output of backupdb and restore the new version? I will tell you I am tempted to toss this and start with a clean setup, if it were not for the exempted devices we have built up over time, with no way to export and import just that. (So sez Sophos...)

    :13565
  • 0

    Hello  amcmis,

    I then did indeed get the same issue

    sorry I did not reply earlier - this was expected. There's a specific procedure for the upgrade from sourceVersion 3, 4, or 45. The installer should use the highest existing version.  It seems it has an issue here. If you are able to locate the advisor's output (Sophos_Upgrade_Assistant_Log.txt ) it should indicate server, instance, existing databases and the "correct" one from the DB connection string.

    Question is - why does it think it has to upgrade from SOPHOS3 instead of SOPHOS4. It probably won't help just dropping the SOPHOS3 DB. So this has to be addressed first.

    Your databases (which one do you have - SOPHOS3 and SOPHOS4?) should be intact. As long as you have a (recent) backup you can start all over. The exact steps depend on what's there and what's not. 

    Christian

    :13569