What should you do first?

You are the network administrator of a CPA firm.

You install Microsoft Windows Small Business Server 2003 with Microsoft SQL Server on a network computer.

You configure and install the data files by using SQL Server. Employees use these files to provide all accounting reports to customers. You maintain the data file on one disk and the transaction log file on a separate disk. The disk with the data file fails.

You want to recover the data completely.

What should you do first?

You are the network administrator of a CPA firm.

You install Microsoft Windows Small Business Server 2003 with Microsoft SQL Server on a network computer.

You configure and install the data files by using SQL Server. Employees use these files to provide all accounting reports to customers. You maintain the data file on one disk and the transaction log file on a separate disk. The disk with the data file fails.

You want to recover the data completely.

What should you do first?

A.
Replace the failed disk.

B.
Restore the full database backup.

C.
Back up the current active transaction log.

D.
Restore each required transaction log in sequence.



Leave a Reply 0

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