SQL 2005 Distriution Database

Posted on 2009-06-29
Medium Priority
Last Modified: 2012-05-07
I'm after some advice on the distribution database:
1. Would a distribution log file shrink cause the subscriber database to become out of sync?  And if so would the job the fail?
2. Does the synchronization job run continuously or is it scheduled?
3. What exactly is held in the distribution database and log file?
4. What would be the faster way to repair the distribution database and subscribers if q 1. is true?
Question by:Netstore
1 Comment
LVL 60

Accepted Solution

chapmandew earned 2000 total points
ID: 24736110
1.  Nothing causes the log to shrink by itself...you might have a db maint plan that truncates the log, which would hose you in this situation.
2.  Both...depends on how you have it setup.
3.  The distribution db holds the transactions before they're distributed to the subscribers.
4.  It depends on what the problem is.  

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
In this article, we will see two different methods to recover deleted data. The first option will be using the transaction log to identify the operation and restore it in a specified section of the transaction log. The second option is simpler and c…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

600 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