You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKingA. Backups of all system databases are performed on Saturday nights. Backups of all user databases are performed on Sunday nights. All backups are stored in an off-site facility. AIOTestKing A unexpectedly turns off due to a power outage. When AIOTestKing A is brought back online, the SQL Server service fails to start. You view the SQL Server error log as shown in the exhibit.
You need to return AIOTestKing A to working order as quickly as possible. What should you do first?
A.
Restore all of the user databases from backup.
B.
Insert the SQL Server 2005 installation CD and run the setup utility to reinstall the default instance.
C.
Restore all of the system databases.
D.
Run Setup.exe from a command line and specify a rebuild of the master database.
Explanation:
The log indicates that the master database (master.mdf) can not be found. Run Setup.exe to rebuild, verify, and repair a SQL Server instance, and rebuild the system databases. This procedure is most often used to rebuild the master database for a corrupted installation of SQL Server.