The tables below show the various database names, file names and associated console versions.
Applies to the following Sophos products and versions Enterprise Console 5.5.0Enterprise Console 5.5.1Enterprise ConsoleEnterprise Console 5.5.2
Note: As of Enterprise Console 5.0, the main Sophos database, e.g. SOPHOS[version], is referred to as the Core database.
SOPHOS540, SOPHOSPATCH52, SophosSecurity
5.2.1 (retired) 5.2.1 R2 (retired) 5.2.2 (retired) 5.3.0 (retired) 5.3.1
* To locate the database files on disk, the following command can be run against the SQL Server instance to create the file C:\databases.txt.
sqlcmd -E -S (local)\SOPHOS -Q "SELECT name, filename from sysdatabases" > C:\databases.txt
Note: The above command should be run on the computer hosting the Sophos databases. It assumes that a local default SOPHOS instance name is in use. For more information on determining your instance name, refer to Sophos Enterprise Console: How to locate the SQL server instance used by the Sophos management server.
Once run, open C:\databases.txt in a text editor to view the file name, path and database name.
If you've spotted an error or would like to provide feedback on this article, please use the section below to rate and comment on the article. This is invaluable to us to ensure that we continually strive to give our customers the best information possible.
Every comment submitted here is read (by a human) but we do not reply to specific technical questions. For technical support post a question to the community. Or click here for new feature/product improvements. Alternatively for paid/licensed products open a support ticket.