mercoledì 2 maggio 2012 12:23
SQL Server 2008
We have a rather large 11TB Publication replicating to two subscribers using transactional replication. This also replicates a table with over 8,000,000,000 records (yes I got the commars correct) :)
To fix a long term bug we wish to modify about 9% for these records (about 720,000,000) records.
In the past whenever we have done any work that gives a large transaction (i.e. update 10,000,000 records) it causes our transaction replication publication to halt as it attempts to execute the batch, this causes replication delays and a rather unhappy client.
So we have an idea of creating a store procedure and replicating that.
This Store Procedure will be updating a table that is already marked for transactional replication. My understanding is if this Store Procedure is executed and replicated, it will not mark the records changed as Transactional Replication, but for Store Procedure replication, bearing in mind we have Transaction Replication (Insert, Update and deletes) on the same table.
Can anyone please confirm if this statement is true ?
Tutte le risposte
mercoledì 2 maggio 2012 13:43ModeratoreYes, changes to the published table caused by the stored procedure execution will not be replicated, only the stored procedure call will be replicated. Changes to the published table caused by other user processes will be replicated.
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
- Contrassegnato come risposta Peter The Spate giovedì 3 maggio 2012 10:26