Solved

How to rebuild log ?

Posted on 2008-10-27
3
2,569 Views
Last Modified: 2008-11-06
I did a restore this morning to a database (full) involved in replication:

Database is now up and runing. The replication doen't work.

The error message I get sugest to do a rebuild to the log :

(I started receiving error message just after the restore)

"10/27/2008 14:22:04,spid91,Unknown,Replication-Replication Transaction-Log Reader Subsystem: agent DGRNDBVPITIJ03-EntidadesExternas-2 failed. The process could not execute 'sp_repldone/sp_replcounters' on 'DGRNDBVPITIJ03'.
10/27/2008 14:22:04,spid91,Unknown,Error: 14151<c/> Severity: 18<c/> State: 1.
10/27/2008 14:22:04,spid94,Unknown,An error occurred while processing the log for database 'EntidadesExternas'.  If possible<c/> restore from backup. If a backup is not available<c/> it might be necessary to rebuild the log.
10/27/2008 14:22:04,spid94,Unknown,Error: 9004<c/> Severity: 23<c/> State: 4.
10/27/2008 14:20:50,spid71,Unknown,Replication-Replication Transaction-Log Reader Subsystem: agent DGRNDBVPITIJ03-EntidadesExternas-2 failed. The process could not execute 'sp_repldone/sp_replcounters' on 'DGRNDBVPITIJ03'.

0
Comment
Question by:LuisGavinhos
  • 2
3 Comments
 
LVL 4

Assisted Solution

by:randy_knight
randy_knight earned 500 total points
ID: 22813687
You need to re-initialize the subscription.  It is looking for log entries that you do not have due to the restore.
0
 

Author Comment

by:LuisGavinhos
ID: 22813804
How to reinitialize subscription ?
0
 

Accepted Solution

by:
LuisGavinhos earned 0 total points
ID: 22856101
The problmem is fixed.

I restored the distribution database (with same date as full restore) and run sp_replrestart

All the best,

L
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question