Re: Question about restore replication database

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

What is "sync with backup option"? Also, I looked in BOL and could not find
sp_replrestart. I am interested in this because we are seeting up a new
merge publication and am interested in how it affects backup/restore.
Thanks.

David

"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:%23GOSOVNOHHA.780@xxxxxxxxxxxxxxxxxxxxxxx
Ideally your publication and distribution database would be in lock step
by using the sync with backup option.

Otherwise you should use sp_replrestart to get around problems like this.

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



"Iter" <Iter@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:63B4A13A-87EC-48B3-8867-EBD74B228A24@xxxxxxxxxxxxxxxx
Hi Guys,
I got a trouble that I tried to restore a database that has a replication
created on and I got an error after restore. In log reader agent and
distribution agent became red color and error message like "Could not
execute
sp_repldone/sp_replcounters.." Sorry I cannot remember error message
exactly, and I am unable to restart the agent. I guess the reason might
be
that I didn't restore distributiuon because I didn't backup this
database. Do
I need to restore distribution databse when I restore publication
database?
thanks.






.

Relevant Pages

  • RE: brick level restore problem on exhcange 5.5 mailbox
    ... we backed up and restored using arcserve with exchange ... backup option, arcserve are no help, as far as they are ... concerned about doing another restore, ... to investigate this mailbox (preferably without shutting ...
    (microsoft.public.exchange.admin)
  • Re: Ghost or Backup
    ... Use the image to restore your PC ... A new file-based backup option which enables you to backup and restore ... individual files and folders, like your My Documents folder or a specific ...
    (alt.os.windows-xp)
  • Re: Filemaker Bento
    ... Is there a corresponding option to restore? ... There's a revert to backup option which opens an open dialog box. ...
    (uk.comp.sys.mac)