Replikation on SQL 2000 distribution DB is too big!!
Posted on 2008-10-21
I have two servers with Windows Server 2003 SP1 and SQL Server 2000 SP4 where I have a Replication (Transactional publication)
Now, somehow, 20 days ago, the replication stoped and the distribution DB started to grow. Yesterday the SQL stoped and I have following Application-Event Error from the MSSQLSERVER
Event ID: 17052
The log file for database ' ' is full. Back up the transaction log for the database to free up some log space.
I deleted the abonnement on Server 2 and recreated a newone. Then I started a snapshot.
The Replication is now active again.
But now my question:
- Why did this happen? There is plenty of free space on th disk.
- The distribution DB (distribution.MDF) has still 3.5 GB, but there are no open transactions. (Replikation is synchonized) How can I shrink it?