Re: Distribution Data File Growth

Thanks. I had all of the pieces (msdb, distribution, master, etc.). All
databases were restored but since I didn't back up the publishers with the
keep_replication switch, I couldn't get replication 'kicked off' again. I
re-marked them after the restore for replication and all of the jobs were
succeeding. However, the log reader was not finding any transactions.

No open transactions in distribution. I'll see where Paul's suggestion leads
me...

"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:1113509425.813891.157720@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> run a dbcc opentran in your distributon database to see what happens.
>
> The keep replication switch was designed to be enable disaster recovery
> of your transactional replication solution. You can use it to restore
> publications on a server but only so you can script out the
> publications or view them. Don't expect to use the keep_replication
> swithc on a new server and have everything work. You need to restore
> the distribution, master, and msdb databases as well.
>


.

Relevant Pages

  • Re: Transactional Replication Post Restore
    ... Although I did restore the distribution and msdb databases, ... the keep_replication switch for the publishers when I restored them. ... > Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: t-sql to drop database unconditionally
    ... But I don't care, because as soon as I kill ALL the databases (distribution, ... How do I kill the users? ... > you just removed a DB that was involved in replication. ...
    (microsoft.public.sqlserver.security)
  • Re: Transactional Replication Post Restore
    ... Did you restore the distribution and msdb databases as well? ... restored the published databases, did you use the keep_replication switch? ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: backup question
    ... backup up (DTS Packages - as long as they are saved to SQL ... Server as the location) so backing up all of your databases ... Replication restore strategies depend on how you have ...
    (microsoft.public.sqlserver.security)
  • Re: newbie: how-to start a transactionnal replication ?
    ... Look under your SQL Server Agent. ... Now open the Replication Monitor and look to see if the Snapshot Agent has ... then check to see if the distribution agent has applied ... > - server A owns many populated databases ...
    (microsoft.public.sqlserver.replication)