Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Replication crashes on dump tran/dbcc checktable (syslogs)

Posted on 1997-09-15
1
Medium Priority
?
604 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 400 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Suggested Courses

564 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