Re: msdb recreate cause replication problems
- From: renedevries@xxxxxxxxx
- Date: 5 Oct 2006 01:06:13 -0700
Eventually called MS Tech Support. The goal was to het replication
working at all, never mind the jobs or the previous state. But since
all relevant tables in msdb where gone, the whole thing was in limbo
The only REAL option is indeed a fresh install of SQL. However, they
where able to help me out, though a number of steps which involved
removing repliation from the database, dropping the distribution db,
and some other assorted trickery. But eventually we got it to work.
Turns out that if you re-create the distribution database all the
associated msdb tables and jobs are also recreated. Fortunately ;)
Lesson: make sure you keep good, validated backups of msdb at all
times. Bitten once again :(
Rene
Hilary Cotter schreef:
I take it you mean you want your jobs to pick up where they left off.
Dropping and recreating the publications and subscriptions should do that.
If you mean the replication table in msdb, they are created there when you
install sql server.
--
.
- References:
- msdb recreate cause replication problems
- From: renedevries
- Re: msdb recreate cause replication problems
- From: Hilary Cotter
- msdb recreate cause replication problems
- Prev by Date: Re: Remote-Agent Activation
- Next by Date: Re: I need help about two server configuration
- Previous by thread: Re: msdb recreate cause replication problems
- Next by thread: Troubleshooting replication errors in SQL Mobile 2005
- Index(es):
Relevant Pages
|
