Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
 Posted - 2009-05-04 : 12:29:21
|
| I have configured replication with a dozen publications each containing a number of articles. The actual replication is (was)working. My issue is that the log file on the source database won't shrink because it has some replication pending per sys.databases. Is there some technique that can get the various publications to commit in sync so that the log file can be brought under control. Currently, since it is growing beyond available disk space (350GB), I have had to abort the replication.Many thanks.=======================================Men build too many walls and not enough bridges. -Isaac Newton, philosopher and mathematician (1642-1727) |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2009-05-04 : 13:44:10
|
| Unfortunately, my decision to delete the replication was an emergency response. I'm going forward by implementing each publication one at a time and seeing where the issue arises.=======================================Men build too many walls and not enough bridges. -Isaac Newton, philosopher and mathematician (1642-1727) |
 |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-05-05 : 10:48:13
|
| for future purposes, you should be setting up Alerts on replication to notify if jobs fail or if latency increases beyond a certain time frame etc.. which are the symptoms of a developing storm.. :)Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2009-05-05 : 13:55:49
|
| In Re: "which are the symptoms of a developing storm"Well put, sir.=======================================Men build too many walls and not enough bridges. -Isaac Newton, philosopher and mathematician (1642-1727) |
|
|
|
|
|
|
Replication and Log File Reuse