The default SQL Server error log file paths are:


    • SQL Server 2000 (Enterprise or Standard):

      C:\Program Files\Microsoft SQL Server\MSSQL\LOG

    • The Raiser's Edge MSDE:

      C:\Program Files\Blackbaud\The Raisers Edge 7\MSDE\MSSQL$RE7_MSDE\LOG

    • The Financial Edge MSDE:

      C:\Program Files\Blackbaud\MSSQL$FE7_MSDE\LOG



    SQL Server Error log:



    The most current SQL Server error log is named ERRORLOG and contains information and error messages related to the SQL Server instance and attached databases. Open ERRORLOG in Notepad to review errors.



    SQL Server Agent Error log:



    The most current SQL Server error log is named SQLAGENT.OUT and contains information and error messages related to the SQL Server Agent and any scheduled maintenance or backups. Open SQLAGENT.OUT in Notepad to review errors.



    Note: Refer to Microsoft MSDN Troubleshooting Overview for troubleshooting tips.