Tuesday, March 20, 2012

Re-run snapshot?

I deleted the Indexes from several tables. Should I force a re-run of the
snapshot agent?
You should reinitialize if
1) you want the same indexes replicated to the subscriber and are
replicating unclustered indexes - make sure run a sp_refreshsubscriptions
2) you have evaluated the performance impact of your replication solution by
having additional indexes on your subscriber. Additional indexes will slow
inserts, updates, deletes
Merely re-running the snapshot may not do anything.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Earl" <brikshoe@.newsgroups.nospam> wrote in message
news:u0VNsYHNFHA.2464@.TK2MSFTNGP10.phx.gbl...
> I deleted the Indexes from several tables. Should I force a re-run of the
> snapshot agent?
>
|||Thanks Hilary.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OD18VcHNFHA.1040@.TK2MSFTNGP12.phx.gbl...
> You should reinitialize if
> 1) you want the same indexes replicated to the subscriber and are
> replicating unclustered indexes - make sure run a sp_refreshsubscriptions
> 2) you have evaluated the performance impact of your replication solution
> by
> having additional indexes on your subscriber. Additional indexes will slow
> inserts, updates, deletes
> Merely re-running the snapshot may not do anything.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Earl" <brikshoe@.newsgroups.nospam> wrote in message
> news:u0VNsYHNFHA.2464@.TK2MSFTNGP10.phx.gbl...
>

No comments:

Post a Comment