Everyday we delete millions of rows, so this will cause some of the pages to be empty and new rows added to the new pages so that's the reason for...

Usually DR servers are used for reporting purposes. In stand by recovery mode we can access the database. On prod servers we usually don't give access to other ppl in...

No updates on this table.

fill factor is set to 100. It's the clustered index on primary key and it's an identity column. So when new data is added it will added at the end...

Sorry for the confusion. It doesn't release space to OS, I mean to say free space in the DB increases, when we rebuild PK. Probably the best way to handle...

Don't you think as million of rows are getting inserted and deleted daily can cause high fragmentation which causes the database size to grow. When rebuilt the fragmented space is...

Auto shrink on the database is set to false. I changed the threshold to rebuild index when greater than 10 , the database grew to 280 GB in no time....

So you mean to say if we rebuild clustered index it rebuilds non clustered index. I don't think it does.

As said by you- this is what happens in our environment...

Can you check whether replication is working or not? Probably add/modify a row in an article which is replicated.This might be a metadata issue in the distribution database. If possible...

I don't think we can reinitialize an article. If possible drop the article from publication and re-add it to the same publication. By doing this you can generate a snapshot...

Is there any other way we can do it other than CDC?

Distribution agent also gets created using the sql server agent account.

If you resolve the issue through microsoft, please update this thread.

I think this explains it all.........

http://social.msdn.microsoft.com/Forums/en/sqlreplication/thread/ee1f7a0a-6363-4a39-8c76-02272e3289dc

Thanks J.

Now we are on the same page. What I was thinking is, if replication is out of sync for some reason if we need to reinitialize what can we...

MysteryJimbo (9/18/2012)

---

Running a snapshot is not reinitializing. The only time this will generate any sort of snapshot is if you add 1 or more new articles then a snapshot...