Re: sql2005 merge subs suddenly expired--

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

OK, now i'm in the middle of piecing this back together... I can drop the
sub, & resubscribe...

but in repl monitor those wierd entris remain, I'm considering dropping &
recreating the publication--

http://162.39.41.50/temp/4.jpg

"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:O4Q2ddrdHHA.4964@xxxxxxxxxxxxxxxxxxxxxxx
They both have to be the same. Make history 31 days as well.

--
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



"S c o t t K r a m e r" <sckramer2000@xxxxxxxxxxx> wrote in message
news:5681b$461397c9$a227293b$8129@xxxxxxxxxxxxx
history retension: 48 hours... (this is in the distributor properties)--
are you talking about a different history retension?
subscription retension: 31 days

all subs sync daily--


"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:uwITpIrdHHA.4688@xxxxxxxxxxxxxxxxxxxxxxx
What is your history retention setting? This should be equal or greater
than your subscription retention setting.

There is no way to recover without re-initializing or re-subscribing.
There is an option to upload subscriber changes when doing a
re-initialization which will upload any changes which have occurred on
the subscriber since the last 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



"S c o t t K r a m e r" <sckramer2000@xxxxxxxxxxx> wrote in message
news:ac531$4612f883$a227293b$20710@xxxxxxxxxxxxx
Please help!

All my laptop subscribers suddenly expired? also the replication
monitor
looks strange... the sub names are blank

Anyone recover from this without re-subscribing?... no changes to the
server
for 27days...

Thanks!!




TITLE: Replication Monitor
------------------------------

Replication Monitor could not open the Detail Window.

ADDITIONAL INFORMATION:

Specified cast is not valid. (ReplicationMonitor)










.

Relevant Pages

  • Re: id manage problem with ID RANGES in merge.
    ... range at the sub was 700001-1400000. ... There is a bug when you drop the subscription the replication check ... You might not be able to delete the check constraints but you should be able ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: sql2005 merge subs suddenly expired--
    ... notice those empty entries still stick in repl monitor... ... Looking for a SQL Server replication book? ... than your subscription retention setting. ...
    (microsoft.public.sqlserver.replication)
  • Re: sql 2005 drop subscription
    ... The subscription works fine. ... subscriptions and need to get rid of them on the server. ... Replication ...
    (microsoft.public.sqlserver.replication)
  • Re: FileSystemWatcher advice required please
    ... Okay, you have a FileSystemWatcher which, I assume, is monitoring the ... The purpose of my service is to monitor the directories for any XML ... I call a sub to process each directory, ... Dim fsw As New FileSystemWatcher ...
    (microsoft.public.dotnet.framework)
  • Re: Replication Failures - Distrib.exe Application Error
    ... replication monitor to monitor your replication to see if there is any ... Microsoft Online Community Support ... or a Microsoft Support Engineer within 1 business day is acceptable. ...
    (microsoft.public.sqlserver.replication)