You need to return the Sales database on SQLTEST1 to normal operation as quickly as possible

You are managing two SQL Server 2008 computers called SQLTEST1 and SQTEST2,
which include a copy of a database named Sales. The database is replicated between SQL1
and SQL2 by using transactional replication. A full backup of each database is performed
every night.
Transaction log backups are performed every hour. Replication latency is typically less than
two minutes. One afternoon, the Sales database on SQLTEST1 becomes corrupted. You
are unable to repair the database. The Sales database on SQLTEST2 is unaffected. You
need to return the Sales database on SQLTEST1 to normal operation as quickly as possible.
You must ensure a minimum loss of data and minimal impact to users of either server.
What should you do?

You are managing two SQL Server 2008 computers called SQLTEST1 and SQTEST2,
which include a copy of a database named Sales. The database is replicated between SQL1
and SQL2 by using transactional replication. A full backup of each database is performed
every night.
Transaction log backups are performed every hour. Replication latency is typically less than
two minutes. One afternoon, the Sales database on SQLTEST1 becomes corrupted. You
are unable to repair the database. The Sales database on SQLTEST2 is unaffected. You
need to return the Sales database on SQLTEST1 to normal operation as quickly as possible.
You must ensure a minimum loss of data and minimal impact to users of either server.
What should you do?

A.
You should reserve the most recent full database backup and the whole transaction logs
made since the past backup could be made.

B.
You should reserve only the newest transaction log backup.

C.
You should detach the Sales database on SQL2. Copy the database file to SQL1, and
link the database on both servers.

D.
You should reserve a full database backup on SQL2. Reserve the backup to SQL1.



Leave a Reply 0

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