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…

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?