Solved

Replication crashes on dump tran/dbcc checktable (syslogs)

Posted on 1997-09-15
1
553 Views
Last Modified: 2012-06-27
I have running a replication mechanism using SQL6.5. It concerns about 15 user tables, grouped in several categories.

The replication is running alright and steady until the transaction log on the subscriber-database is dumped with DUMP TRAN <dbname> WITH NO_LOG, which is followed by DBCC CHECKTABLE (syslogs) to correct the number of pages assigned to syslogs.

Then the replication goes nuts, only to be recovered after installing the mechanism from the beginning.

I cannot leave the DBCC out, because this seems the only way of really emptying the syslogs table.

Martijn Rutte
OgilvyOne
Amsterdam
0
Comment
Question by:tinus
1 Comment
 
LVL 9

Accepted Solution

by:
cymbolic earned 200 total points
ID: 1088954
Just a guess, but see if your subscriber database has the option Truncate Log on Checkpoint set on. This may substitute for a manual dump, and/or may be conflicting with your manual dump command (I know, it shouldn't matter, but you don't really believe that SQL server always works correctly, do you?).  Also, I noticed some fixes in Service Pack 2 for DBCC and replication.  Have you installed it?
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

914 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now