Re: Why is my _SERV_log.ldf file so big?

From: cml9076 (cml9076_at_discussions.microsoft.com)
Date: 02/16/05 

Date: Tue, 15 Feb 2005 17:17:03 -0800

Not being that savy when it comes to SQL how do you turn off the transaction
logs?

"Bil Simser [MVP]" wrote:

> I've seen this on a lot of setups. One of the defaults in SQL when the
> transaction log is turned on is to let it grow forever. Just cut back on
> the size, reduce the amount of transactions you're logging, or if you
> have file level backups and don't need the transaction support turn it
> off (or clear the logs after a full backup).
>
> --
> Bil Simser
> http://weblogs.asp.net
>
>
>
> "cml9076" <cml9076@discussions.microsoft.com> wrote in message
> news:cml9076@discussions.microsoft.com:
> > I realize this is a transaction log file for SQL server and I know the
> > _SERV
> > database stores information for services, such as search and alerts that
> > are
> > provided by a portal site. Recently I did my best to configure searching
> > for
> > my portal and sites and, since then, this _SERV_log.ldf file has quickly
> >
> > grown to 12 GB. I'm guessing that its indexing too much data but I don't
> >
> > know how to tell for sure or how to reduce it in size, any help would be
> >
> > appreciated. Thanks.
>
>

Relevant Pages

  • Re: Distribution Agent Startup Parameters
    ... have a manageable log size when a concurrent snapshot is applied in ... transaction log for large tables? ... the SQL2000 index creation logic in the distribution agent is not very ... having problems with the transaction log growing so large on the ...
    (microsoft.public.sqlserver.replication)
  • Re: Distribution Agent Startup Parameters
    ... transaction bounding the delivery of a concurrent snapshot in SQL2000, ... SQL2000 index creation logic in the distribution agent is not very ... having problems with the transaction log growing so large on the ...
    (microsoft.public.sqlserver.replication)
  • RE: Exchange Logs SBS 2k
    ... I will explain the transaction log of exchange. ... perform a full online backup to free up your disk space. ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • Re: effect Replication has on transaction log
    ... Transactional replication has effects on the transaction log. ... they were with SQL 2000. ...
    (microsoft.public.sqlserver.replication)
  • Re: transaction log too large when applying snapshot ?
    ... option is for transactions or the snapshot. ... The transaction log will not grow as large and the snapshot ... snapshot I get several bcp files per table. ...
    (microsoft.public.sqlserver.replication)