Dropping previous databases used by Enterprise Console

  • Article ID: 17508
  • Rating:
  • 13 customers rated this article 4.9 out of 6
  • Updated: 27 Apr 2016

When the management server is upgraded, database(s) from the previous version are not removed as part of the upgrade process.  This is by design as you may wish to archive the database in your own time once you are happy that the database upgrade has completed successfully. 

Note: For fresh installations, the presence of a previous Sophos database version can lead to installation problems; articles: 114097 and 113946 are examples of this.

Reasons to drop (delete) previous databases would be to reclaim disk space and to stop SQL Server loading databases no longer required.

Applies to the following Sophos product(s) and version(s)
Enterprise Console 5.4.0
Enterprise Console 5.3.1
Enterprise Console 5.3.0
Enterprise Console 5.2.2

What To Do

Determine the database location and SQL Server instance name in use by your installation, if you are unsure please see article 113030.

The next step is to determine the database names of previous versions you are now able to drop (delete).  The following article 17323 lists which database name corresponds to the version of the Console.

Important: Unless you have a backup of a database, once the database has been dropped (deleted) it can not be restored. Ensure that you are confident you are dropping the correct database or databases before continuing.  Before dropping the databases you may wish to take a backup of the databases first and securely store them.  For more information on doing this, see article 110380.

To drop (delete) the previous database(s) after a successful upgrade to a later version, you can run commands such as:


In the above example, the database SOPHOS51 and SOPHOSPATCH51, which comprise a Console 5.1 install will be dropped (deleted) from the local SOPHOS named SQL instance.  You may wish to do this following a successful upgrade to Enterprise Console 5.3.1.

If you need more information or guidance, then please contact technical support.

Rate this article

Very poor Excellent