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.
If you need more information or guidance, then please contact technical support.
How did the article rate?
Did this solve your problem?
Help us improve this article
© 1997 - 2014 Sophos Ltd. All rights reserved.