What should you do?

You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKing A. The master database on AIOTestKing A becomes corrupted. AIOTestKing A contains several SQL Server Agent jobs. All databases are backed up regularly. You rebuild and restore the master database. You need to ensure that AIOTestKing A functions as it did before the database failure. What should you do?

You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKing A. The master database on AIOTestKing A becomes corrupted. AIOTestKing A contains several SQL Server Agent jobs. All databases are backed up regularly. You rebuild and restore the master database. You need to ensure that AIOTestKing A functions as it did before the database failure. What should you do?

A.
Re-create all SQL Server Agent jobs.

B.
Restore all user databases.

C.
Re-create all SQL Server logins.

D.
Restore the model and msdb databases.



Leave a Reply 0

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