Merge Agent

SQL Server Enterprise manager showing Distribution database as SUSPECT and
in result replication monitor do not show any information about replication
agent(Merge agent etc).
I detach database and try to re attach but system showing that database cant
be attached as "log scan" to those file is failed(reflecting files
corrupted).
I attach backup of distribution mdf and ldf file, this time it attached
sucessfully.
BUT the problem remains same, i.e REPLICATION MONITOR IS NOT SHOWING ANY
INFORMATION ABOUT MERGE AGENT.
NOTE. now distribution databse have merge agents record in "msmerge_agents"
table.
Thanks in advance
Best thing to do is restore from back up. Other than that you might try a
sp_attach_single_file_db
Then follow these instructions
http://www.karaszi.com/SQLServer/inf...suspect_db.asp
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Anjaana Rahi" <anjaanarahi@.gmail.com> wrote in message
news:OgjgwZhBGHA.2704@.TK2MSFTNGP15.phx.gbl...
> SQL Server Enterprise manager showing Distribution database as SUSPECT
> and
> in result replication monitor do not show any information about
> replication
> agent(Merge agent etc).
> I detach database and try to re attach but system showing that database
> cant
> be attached as "log scan" to those file is failed(reflecting files
> corrupted).
> I attach backup of distribution mdf and ldf file, this time it attached
> sucessfully.
> BUT the problem remains same, i.e REPLICATION MONITOR IS NOT SHOWING ANY
> INFORMATION ABOUT MERGE AGENT.
> NOTE. now distribution databse have merge agents record in
> "msmerge_agents"
> table.
> Thanks in advance
>
>
|||Oops, sorry I missed the part about how your backup worked (but the merge
agents are now missing).
Try to script out the publications, then drop them and do a no-sync.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Anjaana Rahi" <anjaanarahi@.gmail.com> wrote in message
news:OgjgwZhBGHA.2704@.TK2MSFTNGP15.phx.gbl...
> SQL Server Enterprise manager showing Distribution database as SUSPECT
> and
> in result replication monitor do not show any information about
> replication
> agent(Merge agent etc).
> I detach database and try to re attach but system showing that database
> cant
> be attached as "log scan" to those file is failed(reflecting files
> corrupted).
> I attach backup of distribution mdf and ldf file, this time it attached
> sucessfully.
> BUT the problem remains same, i.e REPLICATION MONITOR IS NOT SHOWING ANY
> INFORMATION ABOUT MERGE AGENT.
> NOTE. now distribution databse have merge agents record in
> "msmerge_agents"
> table.
> Thanks in advance
>
>