Sophos Enterprise Console: associated database names

  • Artikel-ID: 17323
  • Aktualisiert: 26 Sep 2014

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.2
Enterprise Console 5.2.1
Enterprise Console 5.2.0
Enterprise Console 5.1.0
Enterprise Console 5.0.0
Enterprise Console 4.7.1
Enterprise Console 4.7.0
Enterprise Console 4.5.0
Enterprise Console 4.0.0

Sophos Enterprise Console (SEC)

Note: As of Enterprise Console 5.0, the main Sophos database, e.g. SOPHOS[version], is referred to as the 'Core' database.

Database name(s)
Version Database name(s)  File names *
5.2.1
5.2.1 R2
5.2.2
SOPHOS521, SOPHOSPATCH52, SOPHOSENC52, SophosSecurity SOPHOS521.mdf, SOPHOS521_log.LDF, SOPHOSPATCH52.mdf, SOPHOSPATCH52_log.LDF, SOPHOSENC52.mdf, SOPHOSENC52_Log.LDF (SOPHOSENC52.LDF on upgrade),
SophosSecurity.mdf,
SophosSecurity_log.LDF
5.2.0 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

* 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.

 
Wenn Sie weitere Informationen oder Unterstützung benötigen, wenden Sie sich bitte an den technischen Support.

Artikel bewerten

Ungenügend Hervorragend

Anmerkungen