Sophos Database: significant files

  • Article ID: 36045
  • Updated: 14 Apr 2011
SOPHOS4.mdf and SOPHOS4_log.ldf 

SOPHOS4.mdf holds the data and is the Master Database File (hence .mdf) for the SOPHOS4 database. SOPHOS4_log.ldf is the accompanying transactional log file.

Location: C:\Program Files\Microsoft SQL Server\MSSQL$SOPHOS\Data\

Note: SOPHOS4 is the database for Enterprise Console version 4. For later versions, replace the 4 with 45 for Enterprise Console 4.5, etc.


This file is the service ‘MSSQL$SOPHOS’. By default, in MSDE for example, it runs under the SYSTEM account but this can be changed if necessary. It is this service which loads the database files above.

Location: C:\Program Files\Microsoft SQL Server\MSSQL$SOPHOS\Binn\sqlservr.exe


This is a text-based log file which mainly logs the start-up of the SQL service.

Location: C:\Program Files\Microsoft SQL Server\MSSQL$SOPHOS\LOG\ERRORLOG


This is the osql utility command line tool that can be used for querying the database.

Location: C:\Program Files\Microsoft SQL Server\80\Tools\Binn\


A graphical tool for setting up the networking of SQL server, i.e. the protocols it listens on and the ports to use if using TCP/IP.

Location: C:\Program Files\Microsoft SQL Server\80\Tools\Binn\

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

Rate this article

Very poor Excellent