Multiple choice sql-server

You've just installed SQL Server 7 on a NT server using the Typical Installation option. When you start SQL for the first time, you get an error and it will not start. Where is one place you would check to see what is causing the error?

  1. C:MSSQL7LOGERROR.LOG

  2. C:MSSQL7ERROR.LOG

  3. C:MSSQL7SQLSTP.LOG

  4. Windows NT Event Log-Application Log

  5. Windows NT Event Log-System Log
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

When SQL Server fails to start on a Windows NT/2000 system, the Application Log within the Windows Event Viewer is the primary place to find service-level errors. While SQL's own ERRORLOG is useful, the Event Log captures the initial service startup failure details.

Keep practicing — related questions