You work as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. You have received a report from the CIO stating that as soon as new sales transactions is inserted in a SQL Server 2005 database it results in an error A Domain.com user named Ally Wagner is a junior technician in the Sales department. You instruct her to investigate the error. Ally Wagner determines that a developer has accidentally deleted some data in a table that is critical for transaction processing in one of the databases.
The database makes use of the full recovery model. Ally Wagner needs to restore the table. You inform Ally Wagner to accomplish this goal without affecting the accessibility of other information in the database.
What should she do?
A.
The database needs to be restored to the point of the last full backup.
B.
Ally Wagner needs to restore the database from the existing backup files to a time prior to the data loss.
C.
Ally Wagner needs to back up the current transaction log.
Then she can restore the database with a different name and stop at the point just before the data loss.
Thereafter the table can be copied back into the original database.
D.
Back up The current transaction log needs to be backed up.
Thereafter Ally Wagner can restore the database to the point prior to the data loss.
Explanation:
Ally Wagner needs to restore the table that has been accidentally altered. All other suggestions to solution will restore the complete database. Therefore, you will lose data that may have been written to other tables after the point in time where you stop the recovery.