Multiple choice sql-server

You start SQL-Server with the -f option. Unfortunately now you can't establish a connection to your SQL-Server. What should you do?

  1. Rebuild Master database

  2. Edit registry

  3. Run regrebld.exe

  4. Restore registry from backup
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The -f flag starts SQL Server with minimal configuration, which may exclude network libraries. regrebld.exe rebuilds the registry entries for SQL Server, restoring proper network configuration. Rebuilding the master database (A) is extreme and would lose all configuration. Manually editing (B) or restoring (D) the registry is risky and unnecessary when regrebld.exe automates this correctly.

Keep practicing — related questions