Exit 70-447 UPGRADE:MCDBA Skills to MCITP DB Admin by Using MS SQL 2005
Question 1 of 5
0% complete
Q1 Single choice

You are an administrator of 12 SQL Server 2005 computers. Users report that one of the SQL Server computers named Company 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 Company 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 sqlServer agent command to start the SQL Server Agent service.

Previous Next