Multiple choice sql-server

You must restore the MASTER database from a backup on a SQL 7 computer. You attempt to start the restore process but receive an error message. What must you do before you can restore the MASTER database?

  1. Run the rebuild.exe program

  2. Drop the MASTER database

  3. Run the reblddb.exe program

  4. Run the sqlservr.eve program with the -m option
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

To restore the master database, SQL Server must be started in single-user mode using the sqlservr.exe command with the -m option. This prevents other connections from interfering with the restore operation. The master database cannot be restored while SQL Server is running normally.

Keep practicing — related questions