Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
Quote:> Sometimes my SQL Server is filling up logs, how can i automate the
> of logs, so that i can schedule it at night? What sPROC's or TSQL
> can i use to accomplish this? Btw, am using an old version of SQL (6.5 to
> precise) .
Our transaction log is filling up on the server being replicated to
(subscriber). We tried to backup the db, but it never seems to reach a
checkpoint. I was able to truncate the log, but of course that hosed
replication. What is the strategy for preventing the log from filling up.
Right now we have the db and log set to grow.