Changing the data schema in Transactional replication

I am using concurrent snapshot - transactional replication. If I need to add
the column to the replicated table, do I need to drop and re-create
subscription everytime? The database is about 20Gb, it takes up to 4 hours to
re-create two subscriptions. Is there any easier way of changing the data
schema with this configuration?
Please look at sp_repladdcolumn in BOL. If you are using SQL Server 2005,
ALTER TABLE will do it.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||Nope, it will not help. The column need to be added into the table through
differnet software and then populated. I was doing drop article -
subscribtion then addarticle- subscription. But I had tables locked during
the snapshot creation. Then I unchecked the tables lock and received
concurrent snapshot. Drop article-subscription wokrs well, then add article
works too, but then when I add this article to the subscription I receive an
error message: needed to specify all articles? what about if I have about
100 tables-articles?
"Paul Ibison" wrote:

> Please look at sp_repladdcolumn in BOL. If you are using SQL Server 2005,
> ALTER TABLE will do it.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
>
|||Please can you post up the entire error message. Also, in order for me to
repro, can you tell me if there are any extra parts to the setup eg
anonymous subscribers that I need to know about. In fact, can you script out
the publication and I'll set up something similar tomorrow.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

changing recovery model to databases : replication

Using transactional replication and wanted to know if we change the recovery
model from simple to full or vice versa while replication is in place, does
it break anything ? Using SQL 2000
Thanks
nope, change away with no impact. However with full you will have to
maintain your log with more frequent dumps especially if your server is
under high load.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:uUrkgx54EHA.1404@.TK2MSFTNGP11.phx.gbl...
> Using transactional replication and wanted to know if we change the
> recovery
> model from simple to full or vice versa while replication is in place,
> does
> it break anything ? Using SQL 2000
> Thanks
>

Changing IP addresses

We are planning on changing IP addresses on two database
servers that have SQL transactional replication between
them. Before I get into any trouble, do you see any
problem that could occur regarding the replication
communication between the servers. My plan is to change
the IP addresses and reboot the servers. I won't know
until I do this if the replication will start back up
successfully.
replication is insensitive to IP address changes.
there are some caveats
1) if you are using the client network utility to associate the IP address with the machine name you will have to update the ip addresses
2) if you are using a hosts file for name lookup s to associate the IP address with the machine name you will have to update the ip addresses in this file
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Jeff Steinweber" wrote:

> We are planning on changing IP addresses on two database
> servers that have SQL transactional replication between
> them. Before I get into any trouble, do you see any
> problem that could occur regarding the replication
> communication between the servers. My plan is to change
> the IP addresses and reboot the servers. I won't know
> until I do this if the replication will start back up
> successfully.
>