What should you do?

You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKing A. AIOTestKing A is configured to automatically perform transaction log backups, database integrity checks, and other maintenance tasks on a regular basis. Another administrator uses the SQL Server Surface Area Configuration tool to reconfigure AIOTestKing A. You notice that AIOTestKing A no longer performs the automated maintenance tasks. You need to ensure that the maintenance tasks on AIOTestKing A are completed automatically. What should you do?

You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKing A. AIOTestKing A is configured to automatically perform transaction log backups, database integrity checks, and other maintenance tasks on a regular basis. Another administrator uses the SQL Server Surface Area Configuration tool to reconfigure AIOTestKing A. You notice that AIOTestKing A no longer performs the automated maintenance tasks. You need to ensure that the maintenance tasks on AIOTestKing A are completed automatically. What should you do?

A.
Manually perform a full backup of the msdb database.

B.
Reconfigure the server so that the SQL Server Agent service starts automatically.

C.
Reconfigure AIOTestKing A to use Windows Integrated authentication.

D.
Reconfigure the SQL Server service to log on by using an administrative user account.



Leave a Reply 0

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