Log Size grows rapidly -- sql server clients

Farhan Iqbal
12/16/2005 6:52:02 PM

hi

I have implemented merge replication on my machine my question is that my
database log size is growing very rapidly. Can any one help me in this
regards why the log size grows in GB within 3 to 4 hours.

Waiting for reply anxiously

Farhan Iqbal

Mike Epprecht (SQL MVP)
12/16/2005 9:24:21 PM

Hi

Are you backing up your transaction log on a regular basis?

Run DBCC OPENTRAN to see if there are any long running transactions.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

[quoted text, click to view]

sql server clients : Log Size grows rapidly