Sophos Database: significant files
| SOPHOS3.mdf and SOPHOS3_log.ldf | SOPHOS3.mdf holds the data and is the Master Database File (hence .mdf) for theSOPHOS3 database. SOPHOS3_log.ldf is the accompanying transactional log file. Location: C:\Program Files\Microsoft SQL Server\MSSQL$SOPHOS\Data\ |
| Sqlservr.exe | This file is the service ‘MSSQL$SOPHOS’. By default, in MSDE for example it runsunder the SYSTEM account but this can be changed if necessary. It is this servicewhich loads database files above. Location: C:\Program Files\Microsoft SQL Server\MSSQL$SOPHOS\Binn\sqlservr.exe |
| ERRORLOG | 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 |
| OSQL.exe | This is the osql utility Command line tool that can be used for for querying thedatabase. Location: C:\Program Files\Microsoft SQL Server\80\Tools\Binn\ |
| SVRNETCN.exe | Graphical tool for setting up the networking of SQL server, i.e. the protocols it listenson 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.
- Article ID: 36045
- Created: 18 Mar 2008
- Last updated: 23 Oct 2008
