You are the database administrator of your company. The company has a main office and five branch offices indifferent cities. Each branch office contains a computer running SQL Server 2008. The main office networkcontains an instance of SQL Server 2008 named SQL1 . SQL1 contains a database named Inventory . Your company wants to implement a new inventory tracking application that will access a table named Inventory_items in the Inventory database. You want to enable users in all the offices to update the
Inventory_items table. You decide to implement merge replication with SQL1 as the Publisher and instances ofSQL Server in the branch offices as the Subscribers. To minimize the disk space on the Subscribers, you want to ensure that only the Publisher is used to store conflictrecords.
Which system stored procedure should you run on SQL1 to configure this?
A.
the sp_addmergepublication system stored procedure with the @conflict_logging argument
B.
the sp_addmergesubscription system stored procedure with the @publication argument
C.
the sp_addmergepublication system stored procedure with the @centralized_conflicts argument
D.
the sp_addmergesubscription system stored procedure with the @centralized_conflicts argument
Explanation:
You should run the sp_addmergepublication system stored procedure with the @conflict_logging argument.The sp_addmergepublication system stored procedure creates a new merge publication. The @conflict_logging parameter specifies where conflict records are stored. The possible values for this parameterare publisher , subscriber , both , and
NULL . Specifying the publisher value for the @conflict_logging parameter ensures that the conflict records are stored at the Publisher. You should not run the
sp_addmergesubscription system stored procedure with the @publication or @centralized_conflicts argument because this stored procedure cannot be used to configure the Publisher tostore conflict records. The sp_addmergesubscription system stored procedure creates a push or pull mergesubscription. The @publication
argument specifies the name of the publication. The @centralized_conflicts argument is not a valid argument for the sp_addmergesubscription system stored procedure. You should not run the sp_addmergepublication system stored procedure with the @centralized_conflicts argument. The @centralized_conflicts argument has been deprecated and is only supported for backwardcompatibility. You should use the @conflict_logging argument to specify the location where conflict records arestored.Objective:
Implementing High AvailabilitySub-Objective:
Implement replication.References:
MSDN > MSDN Library > Servers and Enterprise Development > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Replication > Technical Reference > Replication StoredProcedures (Transact-SQL) > sp_addmergepublication (Transact-SQL) MSDN > MSDN Library > Servers and Enterprise Development > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Replication > Technical Reference > Replication StoredProcedures (Transact-SQL) > sp_addmergesubscription (Transact-SQL)