Re: Log Question

Tech-Archive recommends: Fix windows errors by optimizing your registry

Truncate away, you will not affect anything especially not any transactions.
For immediate updating the transaction is applied on the publisher first and
then the subscriber. For queued updating triggers will log the transaction
in a queue, not the log.
--
http://www.zetainteractive.com - Shift Happens!

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"CLM" <CLM@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B27535D0-1036-463F-92E2-96556F32F53D@xxxxxxxxxxxxxxxx
We've got 2000 SP4 servers with transactional immediate replication. One
of
the subscribing databases is in simple mode with a log that is about 70G
and
all of that is used. This is strange but we don't back up that database -
it's not worth it to management right now - so how can I shrink that log
file? If I truncate the log, could I possibly blow away transactions that
contain replicated data? Again, keep in mind that this subscribing
database
is in simple mode and is not backed up now. Thx.


.

Relevant Pages

  • Re: Should Trans-Log be on its own RAID volume?
    ... I thought Tran log gets truncated at checkpoint no matter how full its is, ... it gets rid of committed transactions ... > mode it will truncate when the log gets about 70% full and will only ... It's not the size but the volume and way the transactions get ...
    (microsoft.public.sqlserver.server)
  • Re: Transaction Log Filling Up - SQL 2000
    ... The best solution is to issue a log backup to cleanly backup the ... transactions and truncate the inactive portion of the log. ... This script is ALTERing many tables to ADD a column ...
    (microsoft.public.sqlserver.programming)
  • Re: Log Question
    ... Perhaps I wasn't clear enough in my previous message I'm trying to explain that you can backup the log (with truncate_only or not) but you shouldn't truncate the physical log file because you will have problems if you do that. ... could I possibly blow away transactions that ...
    (microsoft.public.sqlserver.replication)
  • RE: Lights needed on the T Log management
    ... "Chris V." wrote: ... > Transations are kept in the log until the log is or backed up or truncate, ... > The size will be reduce will DBCC SHRINKxxx ... > append to the log which will keep growing, or will the new transactions be ...
    (microsoft.public.sqlserver.server)
  • Re: truncate transaction log
    ... The physical size of the log file will not shrink when you truncate the ... size that will hold all of the transactions in between log backups. ... time the log backup will truncate the committed transactions ...
    (microsoft.public.sqlserver.server)