Browse by Tags

All Tags » Replication (RSS)
Sorry, but there are no more tags available to filter with.

Transactional Replication, Deferred Updates and Triggers.

( SQL Server 2000 ) I sometimes think that as part of my performance tuning and optimisation work I encounter every obscure feature of SQL Server there is. I’ve created a customised transactional replication for a production database, which I’m not going...
Posted by GrumpyOldDBA | 2 comment(s)
Filed under:

Transactional Replication without a GUI

As I'd previously posted I had to be able to set up replication through T-SQL scripts only, my database to be replicated has identity columns and time stamps. The subscribing database has to be fully operational seperate to the publishing database, the...
Posted by GrumpyOldDBA | with no comments
Filed under:

Transactional Replication by T-SQL

Haven't forgotten about this but we're still considering which way we want to implement replication. It's proving very interesting and I will publish my findings.
Posted by GrumpyOldDBA | with no comments
Filed under:

Transactional Replication PT4 .. Setting the Distributor

In my case I have a cluster My publisher will also be the distributor The subscriber will be another server Default admin shares have been removed so the default share for replication must be defined I'm placing the distribution database files where I...
Posted by GrumpyOldDBA | with no comments
Filed under:

Transactional Replication PT3 - Dealing with identity columns

The database to be replicated was not designed with replication in mind. Tables contain identity columns and timestamps. The subscribing database must be fully functional and allow data input, data must not be updated at the publisher from the subscriber...
Posted by GrumpyOldDBA | 1 comment(s)
Filed under:

Invalid Descriptor Index error solved ( Replication )

This has been driving me mad ( ok really grumpy !! ) it's such a vague error - After installing replication the distribution agent failed with this error message. So thanks to Raymond Mak I found out that the sp had not updated the template mdf and ldf...
Posted by GrumpyOldDBA | with no comments
Filed under:

Transactional Replication PT2 - Getting table info

First task identifying which tables have identity columns and timestamps, the following query also checks for clustered indexes and primary keys. I'll need to know the name of the timestamp columns so I can create the filter commands. Tables without a...
Posted by GrumpyOldDBA | with no comments
Filed under:

Transactional Replication the hard way?

I've previosuly managed articles through T SQL in replication, anyone who has had to make changes to a replicated table will know the pain I'm sure. When there are lots of articles and data is in the hundreds of gigabytes the whole process of making changes...
Posted by GrumpyOldDBA | with no comments
Filed under: