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 4.0.0
Enterprise Console 4.5.0
Enterprise Console 4.7.0
Enterprise Console 4.7.1
Enterprise Console 5.0.0
Sophos Enterprise Manager 4.7.0
Sophos Control Center 4.0.0
Sophos Control Center 4.0.1
Sophos Control Center 4.1
Enterprise Console 5.1.0
Enterprise Console 5.2.0
Sophos Enterprise Console (SEC)
Note: As of Enterprise Console 5.0, the main Sophos database, e.g. SOPHOS52, is referred to as the 'Core' database.
Database name(s) | Version | Database name(s) | File names * |
| 5.2 | SOPHOS52, SOPHOSPATCH52, SOPHOSENC52, SophosSecurity | SOPHOS52.mdf, SOPHOS52_log.LDF, SOPHOSPATCH52.mdf, SOPHOSPATCH52_log.LDF, SOPHOSENC52.mdf, SOPHOSENC52_Log.LDF (SOPHOSENC52.LDF on upgrade),
SophosSecurity.mdf,
SophosSecurity_log.LDF
|
5.1
| SOPHOS51, SOPHOSPATCH51, SOPHOSENC51
| SOPHOS51.mdf, SOPHOS51_log.LDF, SOPHOSPATCH51.mdf, SOPHOSPATCH51_log.LDF, SOPHOSENC51.mdf, SOPHOSENC51_Log.LDF |
5.0
| SOPHOS50, SOPHOSPATCH
| SOPHOS50.mdf, SOPHOS50_log.LDF, SOPHOSPATCH.mdf, SOPHOSPATCH_log.LDF |
4.7.x
| SOPHOS47
| SOPHOS47.mdf, SOPHOS47_log.LDF |
| 4.5.x | SOPHOS45
| SOPHOS45.mdf, SOPHOS45_log.LDF |
4.0.x (obsolete)
| SOPHOS4
| SOPHOS4.mdf, SOPHOS4_log.LDF |
3.x (obsolete)
| SOPHOS3 | SOPHOS3.mdf, SOPHOS3_log.LDF |
2.x (obsolete)
| SOPHOS2 | SOPHOS2.mdf, SOPHOS2_log.LDF |
| 1.x (obsolete) | SOPHOS | SOPHOS.mdf, SOPHOS_log.LDF |
Sophos Enterprise Manager (SEM)
| Version | Database name(s) | File names * |
4.7.x
| SOPHOS47
| SOPHOS47.mdf, SOPHOS47_log.LDF |
Sophos Small Business Edition (SBE)
| Version | Database name(s) | File names * |
| 4.x | SOPHOS4
| SOPHOS4.mdf, SOPHOS4_log.LDF |
2 (obsolete)
| SOPHOS2 | SOPHOS2.mdf, SOPHOS2_log.LDF |
| 1.x (obsolete) | SOPHOS | SOPHOS.mdf, SOPHOS_log.LDF |
* 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.