Thank you Sean

Are you saying to use the ackup set table for all the servers in foreach loop? I though there could be a way either by using SQL or...

Thank you Sean.

This is the way I had earlier but now reqirements and scope have changed. I need to get the lastest backup file size from the backup server where...

Thank you for the reply Stephan.

You provided very good information which I wasn't aware being new to T-Replication.

One question I have is my select * from distribution.dbo.MSrepl_commands table is...

Hello All,

I get errors as:

Row not found for update or delete commands

PK constraint for insert commands (specially when I applied the data discrepency script from RedGate andd the record is...

No I am not. I donot want to. But received this message 'Snapshot is not available'. I am asking why this message is showing even after the snapshot is taken...

Any suggestions / thoughts?

Thanks,

This is for the existing article. Because the publication and subscriber was out of sync, I took a new snapshot. But still the message doesn't go away 'Initial snapshot for...

Hello,

Even after taking a new snapshot (100% completed status), the subscription shows message 'Initial snapshot for article X is not yet available'.

Can anyone help me with why do I still...

One more question- how do I change my filter criteria without dropping subscription or re-initializing?

sp_repldone will delete the transactions which are in distributor and didn't make it to subscriber yet. I will those transactions and my replication will be out of sync. Then I...

All the subscriptions failed because there I think there is only on Log reader agent for the distribution database which distributes the records to the subs.

Don't I have to drop...

Thanks.

Should I create all the pubs and subs? Or just the one having an issue and that will fix all the pubs.

How do I find which publication had an issue?...

Thank you.

This morning I encountered another issue on all the publicatios which I had built yesterday with the 'replication support only' subscriptions as I didn't want to generate new snapshot....

Thanks.

I never used the script in production but did try in development by turning OFF the immeadiate sync.

It worked without any issues.

How would I use filter on article if 3...

Hello All,

I know this post about removing a article from publication. I tried opposite of this as this is a requirement at my work.

Adding a article to the existing publication....