I have transactional replication configured in production. I have heard about the replication retention period, but what is the significance of this. Would there be any impact to my replication configuration if data is not synchronized with the subscriptions within the retention period?
2012-04-17
3,053 reads
I have transactional replication configured in production. I am wondering if we could rename the publication database in transactional replication without having to drop and recreate the replication set up. Also, is it possible to rename the database files of the publication database without affecting the replication configuration.
2012-04-10
2,618 reads
One of the great features with SQL Replication is the ability to initialize a subscription from backup instead of from a snapshot. The official use for this is to take a database backup and restore it to a subscriber then replicate any additional changes to the backup.
2012-04-02
1,927 reads
2012-02-16
1,885 reads
2012-01-30
1,884 reads
2012-01-12
1,884 reads
I have transactional replication configured in my production environment with multiple subscribers. The business team has requested that one of the subscriptions be reinitialized, because they think there is some missing data. In this tip we look at the different options that you can use to reinitialize a subscription for transactional replication.
2011-12-27
2,872 reads
I have transactional replication configured in my production environment. The business team has requested that I do not replicate delete operations on certain articles. In this tip we look at a couple of options to not replicate DELETE commands.
2011-11-04
2,963 reads
Learn how you can update multiple servers in a single bound with this technique from Kimberly Killian.
2011-10-24
3,915 reads
Automatically capture replication conflicts and generate an automated email notification.
2016-02-05 (first published: 2011-10-17)
3,524 reads
By John
Failing to plan is planning to fail. When organizations first begin implementing Azure networking,...
Like any good mystery, some SQL Server problems look spooky on the surface but...
By Steve Jones
As I use containers more and more to run various things, I decided I...
I maintain an application written years ago, where the database is on a Windows...
Comments posted to this topic are about the item The Duplicate Cursor
Comments posted to this topic are about the item Concerns over AI Chat Privacy
Can I run this code:
DECLARE ANewTable CURSOR FOR SELECT * FROM ANewTableSee possible answers