The tables below show the various database names, file names and associated console versions.
Known to apply to the following Sophos product(s) and version(s) Enterprise Console 5.2.2Enterprise Console 5.3.0Enterprise Console 5.3.1Enterprise Console 5.4.0Enterprise Console 5.4.1
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 5.3.0 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 see article 113030.
Once run, open C:\databases.txt in a text editor to view the file name, path and database name.
Every comment submitted here is read (by a human) but we do not reply to specific technical questions. If you need technical support please post a question to our community. Alternatively for licensed products open a support ticket.