You are a database developer. You develop solutions by using SQL Server 2008 in an
enterprise environment. You are creating a SQL Agent job that uses Transact-SQL to
update data in two related databases on two different servers. You have the following
requirements: ·The job can only execute once each evening. ·The databases on each
server use the full-recovery model. ·Transaction log backups for the two databases occur at
different times. ·The job uses transactions to ensure that in the event of an error, all updates
are rolled back. You need to ensure that when you restore a database on either server, the
two databases are restored to a state that reflects the last time the job successfully
executed. What should you do?
A.
Use marked transactions. When a database failure occurs, restore both databases by
using a marked transaction.
B.
Ensure both databases are altered using the NO_WAIT termination clause.
C.
Use the Windows Sync Manager to ensure that the databases can never be out of
synchronization.
D.
Use saved transactions. When a database failure occurs, restore both databases by
using a saved transaction.