msdb recreate cause replication problems

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

We just went through a nasty experience whereby we had to recreate the
MSDB database.

System is now back, but replication is completely messed up. Is there a
way to get all the MS* tables back, in the MSDB? I tried to de-install
and install Replication, but that doesn't seem to generate all the
required tables and procs

SQL2005, SP1.

Any help much appreciated!

.

Relevant Pages

  • Re: How to change IDENTITY to NOT FOR REPLICATION?
    ... SQL Server MVP ... Columnist, SQL Server Professional ... IDENTITY NOT FOR REPLICATION? ... I don't want to drop the column and recreate ...
    (microsoft.public.sqlserver.programming)
  • Re: Source of Angle Brackets <> in Address book
    ... We thought maybe it was a replication error but even after ... Recreate the mailbox? ... exmerge all the old email into the new mailbox. ...
    (microsoft.public.exchange.admin)
  • Re: Logreader agent not being created
    ... and then recreate your publication and subscription. ... Looking for a SQL Server replication book? ... there will be a log reader agent on the publisher. ... >> It was setup for Immediate Updating and Queued Updating as a failover. ...
    (microsoft.public.sqlserver.replication)
  • Re: Stop Recreate Store Procedure
    ... disable the distribution agent. ... Exactly what do you mean by "without recreate the other new store ... Looking for a SQL Server replication book? ... delete without recreate the other new store procedure? ...
    (microsoft.public.sqlserver.replication)
  • Replication message
    ... I got the following message when after deleting the replication i tried to ... Subscription: SERVER1:SvrTT cannot be reinitalized automatically because it ... subscription you must drop and recreate it. ... from the SQL scripts that i generated earlier from the existing replication ...
    (microsoft.public.sqlserver.replication)