Wednesday, March 28, 2012
How to ask a question...(MS KB Article)
http://support.microsoft.com/kb/q555375
At first I though this was hilarious, but there is actually some good information in here that is applicable on this forum as well as anywhere else. Perhaps Brett could add this as a sticky?
Regards,
hmscottI like it.|||I liked:
Do you have current backups? Why not?
I'll go add the link
Monday, March 19, 2012
How to add tabls to published article without recreating snapshot?
Hi experts:
We have 4 SQL SERVER 2000 servers linked via replication, and due to business changes we have to add one table to the published databases. And the existed database has more than 20g, recreating the snapshot and re-init replication is not allowed as the business cannot be stopped more than 1 hour. So my question is how to add tables to the published article without recreating the snapshot?
By that is not possilbe, can we publish one new article on the same database?
Thanks in advance!
Ron
Hi Ron,
If you are using merge replication, you have to regenerate the snapshot for the entire publication after you added the new article. For snapshot\transactional replication, the snapshot agent will only generate the snapshot for the new article if the immediate_sync property of your publication is set to 0. In any case, you can always put the new article in a separate publication instead.
Hope that helps,
-Raymond
Monday, March 12, 2012
How to add new article to publication?
I'm use MSSQL2000 SP3 with replication.
I want to know that Can i add new article to existing publication by
Enterprice Manager ?
someone told me that we can do that in older version but not now,right? :confused:In UI you have to rebuild your replication/subscription from scratch. You can however use sp_addarticle/sp_addmergearticle (depending on your replication type).
how to add new article to existing publication without reinitialization
I am working on sql server 2000 replication. I have an
existing publication from server1 to server2 which has 6
tables in the publication. Now I want to add two more
tables into this publication.
How can I do it without have to re-initialize it?
is it always better to re-initialize the replication every
time you add new articles to the publication?
many thanks
JJ
1) use a separate publication is there are no relationships between the new
articles and articles in the existing publication.
2) think about using sp_addarticle. When you use this only the new
article(s) is "reinitialized", the existing publication is not regenerated.
Here is an example:
sp_addarticle 'pubs','jobs', 'jobs'
go
sp_refreshsubscriptions 'pubs'
pubs is my publication jobs is my article name and jobs is the source table.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"JJ Wang" <anonymous@.discussions.microsoft.com> wrote in message
news:295d201c4654a$b05bfba0$a501280a@.phx.gbl...
> hi,
> I am working on sql server 2000 replication. I have an
> existing publication from server1 to server2 which has 6
> tables in the publication. Now I want to add two more
> tables into this publication.
> How can I do it without have to re-initialize it?
> is it always better to re-initialize the replication every
> time you add new articles to the publication?
> many thanks
> JJ
>
|||wow, I ought to try it out! thanks a lot Hilary.
JJ
>--Original Message--
> 1) use a separate publication is there are no
relationships between the new
>articles and articles in the existing publication.
>2) think about using sp_addarticle. When you use this
only the new
>article(s) is "reinitialized", the existing publication
is not regenerated.
>Here is an example:
>sp_addarticle 'pubs','jobs', 'jobs'
>go
>sp_refreshsubscriptions 'pubs'
>pubs is my publication jobs is my article name and jobs
is the source table.
>Hilary Cotter
>Looking for a book on SQL Server replication?
>http://www.nwsu.com/0974973602.html
>
>"JJ Wang" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:295d201c4654a$b05bfba0$a501280a@.phx.gbl...
every
>
>.
>
|||hi Hilary,
Is the sp_addarticle the same thing when I do it through
the replication wizard (click on the publication property
and add more article in the 'article' tab)? if I do in
the wizard, will still only the new articles get re-
initialized?
JJ
>--Original Message--
> 1) use a separate publication is there are no
relationships between the new
>articles and articles in the existing publication.
>2) think about using sp_addarticle. When you use this
only the new
>article(s) is "reinitialized", the existing publication
is not regenerated.
>Here is an example:
>sp_addarticle 'pubs','jobs', 'jobs'
>go
>sp_refreshsubscriptions 'pubs'
>pubs is my publication jobs is my article name and jobs
is the source table.
>Hilary Cotter
>Looking for a book on SQL Server replication?
>http://www.nwsu.com/0974973602.html
>
>"JJ Wang" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:295d201c4654a$b05bfba0$a501280a@.phx.gbl...
every
>
>.
>
|||Yes it is the same thing. However, thru EM, there is no
way to refresh only new articles in the subsriptions.
When you click on reintialize all subscriptions, it
reinitializes everything. At that time, you should use
SPRC sp_refreshsubscriptions. However, I haven';t seen
this proc working with PUSH subscription though. It only
works with PULL Subscriptions.
>--Original Message--
>hi Hilary,
>Is the sp_addarticle the same thing when I do it through
>the replication wizard (click on the publication
property[vbcol=seagreen]
>and add more article in the 'article' tab)? if I do in
>the wizard, will still only the new articles get re-
>initialized?
>JJ
>relationships between the new
>only the new
>is not regenerated.
>is the source table.
in[vbcol=seagreen]
>message
an[vbcol=seagreen]
has 6
>every
>.
>