What should you do?

You are an administrator of 12 SQL Server 2005 computers. Users report that one of the SQL Server computers named AIOTestKing F is unavailable for almost an hour starting at 16:00. One of the other SQL Server administrators reports that during this time, he performed a quick routine maintenance task that included a restart. You view the SQL Server logs on AIOTestKing F for the time period in question, as shown in the exhibit.

You need to ensure that this unavailability does not happen again. What should you do?

You are an administrator of 12 SQL Server 2005 computers. Users report that one of the SQL Server computers named AIOTestKing F is unavailable for almost an hour starting at 16:00. One of the other SQL Server administrators reports that during this time, he performed a quick routine maintenance task that included a restart. You view the SQL Server logs on AIOTestKing F for the time period in question, as shown in the exhibit.

You need to ensure that this unavailability does not happen again. What should you do?

A.
Instruct the other SQL Server administrators to use a Windows domain user account to start the SQL Server service.

B.
Instruct the other SQL Server administrators not to use the net start mssqlserver command to start the SQL Server service.

C.
Instruct the other SQL Server administrators not to start the SQL Server service in single user mode for routine maintenance .

D.
Instruct the other SQL Server administrators not to use the net start sqlserveragent command to start the SQL Server Agent service.



Leave a Reply 0

Your email address will not be published. Required fields are marked *