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

From: Bil Simser [MVP] (bsimser_at_shaw.ca)
Date: 02/16/05 

Date: Wed, 16 Feb 2005 03:21:18 +0000

Off the top of my head I can't remember the exact place to go, but just
take a look at the configuration in Enterprise Manager for your server.
It's either on the server or on the databases themselves. Check the help
file for information on configuring these but if you're not sure what
you're doing then you should get your DBA to help with the SQL config.
Otherwise it's part of having to run your server so it would be good to
get familiar with some of the features of SQL Server. 

--
Bil Simser
http://weblogs.asp.net
"cml9076" <cml9076@discussions.microsoft.com> wrote in message 
news:cml9076@discussions.microsoft.com:
> 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: Security Connection Problem
    ... If I am in the SQL ... Server Enterprise Manager and I can't connect to the server using the ... Axapta does not seem to understand the entire DNS name. ... was an error in an Axapta Configuration File. ...
    (microsoft.public.sqlserver.setup)
  • Re: Security Connection Problem
    ... If I am in the SQL ... Server Enterprise Manager and I can't connect to the server using the ... Axapta does not seem to understand the entire DNS name. ... was an error in an Axapta Configuration File. ...
    (microsoft.public.sqlserver.security)
  • Re: BizTalk server Topology & scalibilty
    ... BizTalk itself is 'stateless' and so can run on any machine that has access ... host instances is unrelated to the distribution of databases across SQL. ... could have all dbs installed on a single SQL server, or each on its own SQL ... > configuration of hosts. ...
    (microsoft.public.biztalk.server)
  • Re: BizTalk Server 2004 ConfigFramework.exe error
    ... I have problem to pass the SSO setup during the configuration process. ... > and trying to configure this server 2nd. ... > the SSO server needs to be the first server configured in a BizTalk group. ... Do you mean that your SQL Server is on different box from the ...
    (microsoft.public.biztalk.general)
  • Re: MSDE on flash memory
    ... Therefore you may end up corrupting the transaction log in top level but still have some "old" ... I was wondering if it is considerable for you to move the DB on a server? ... I don't think MSDE has any "embedded" specific integration including flash random writing or etc. Keep in mind that MSDE on XPE ... I don't think SQL CE has any flash related issues fixed either. ...
    (microsoft.public.windowsxp.embedded)