Yon maintain a SQL Server 2008 instance that contains a database named Finance. The backup strategy for the Finance database specifies the following requirements:

Full database backup to a file named finance.bak is performed at 08:00

hours daily.

A transaction log backup to a file named finance_HHMM.trn is performed

every 15 minutes starting at 08:15 horns. The Finance database is being used in single-user mode. At 08:40 hours, a user reports that some important data was accidentally deleted by a query that was executed at 08:23 horns. You need to restore the database to its original state. Which Transact-SQL statement(s) should you use?

Question

Yon maintain a SQL Server 2008 instance that contains a database named Finance. The backup strategy for the Finance database specifies the following requirements:

Full database backup to a file named finance.bak is performed at 08:00

hours daily.

A transaction log backup to a file named finance_HHMM.trn is performed

every 15 minutes starting at 08:15 horns. The Finance database is being used in single-user mode. At 08:40 hours, a user reports that some important data was accidentally deleted by a query that was executed at 08:23 horns. You need to restore the database to its original state. Which Transact-SQL statement(s) should you use?

Accepted Answer

B. Option B

Answer

A. Option A

Answer

C. Option C

Answer

D. Option D

Yon maintain a SQL Server 2008 instance that contains a database named Finance. The backup strategy for the Finance database specifies the following requirements: - Full database backup to a file…

Question

Exhibit

Options

How the community answered

Community Discussion