Which Transact-SQL statement(s) should you use?

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?

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?

A.
Option A

B.
Option B

C.
Option C

D.
Option D

Explanation:



Leave a Reply 0

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