You work as a database administrator for MiracleInfocom .com. MiracleInfocom .com is a book distributor and its network consists of a single Active Directory domain named MiracleInfocom .com. All servers on the MiracleInfocom .com network run Microsoft Windows Server 2003 and the database servers run Microsoft SQL Server 2005. Your job description at MiracleInfocom .com includes the administration of the database servers named MiracleInfocom -DB01 and MiracleInfocom -DB02 respectively. MiracleInfocom -DB01 is on the internal network and MiracleInfocom -DB02 is on the perimeter network. Both these servers are configured to make use of transactional replication with immediate -updating subscribers to replicate the BookTitle table and the InStock table of the Inventory database. You have a suspicion that the replicas are non-convergent. Now you need to check which of the rows are different. What should you do?
A. You should run sp_publication_validation utility.
B. You need to run tablediff utility.
C. You need to enable the replication: Subscriber has failed data validation alert.
D. You need to enable the Validate Subscriptions option on the publication.
Answer:B
You work as a database administrator for MiracleInfocom .com. MiracleInfocom .com is a book distributor and its network consists of a single Active Directory domain named MiracleInfocom .com. All servers on the MiracleInfocom .com network run Microsoft Windows Server 2003 and the database servers run Microsoft SQL Server 2005. Your job description at MiracleInfocom .com includes the administration of the database servers named MiracleInfocom -DB01 and MiracleInfocom -DB02 respectively. MiracleInfocom -DB01 is on the internal network and MiracleInfocom -DB02 is on the perimeter network. Both these servers are configured to make use of transactional replication with immediate -updating subscribers to replicate the BookTitle table and the InStock table of the Inventory database. You have a suspicion that the replicas are non-convergent. Now you need to check which of the rows are different. What should you do?
A. You should run sp_publication_validation utility. B. You need to run tablediff utility. C. You need to enable the replication: Subscriber has failed data validation alert. D. You need to enable the Validate Subscriptions option on the publication.