Hello Gurus
I was wondering other than bouncing the server is there a way to limit
or flush a log when it becomes to large say like 11 gigs
We had a log several months ago that was over 25 gigs this caused the
log to fail to grab some of the entries, this stopped us from verifing a
problem
Is there a method to flucsh or limit the size of the log now I am not
talking tranlog but the sqlserver log under management tab in enterpise
manager??


William Orova


*** Sent via Developersdex http://www.developersdex.com ***

More importantly why did it get that large to begin with? If you are in FULL
recovery mode you need to issue regular Log backups to free and reuse the
space in the log. Otherwise consider changing to SIMPLE recovery mode.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Bill_Orova" <nospam@devdex.com> wrote in message
news:%23rKN2$vpIHA.4848@TK2MSFTNGP05.phx.gbl...
>
> Hello Gurus
> I was wondering other than bouncing the server is there a way to limit
> or flush a log when it becomes to large say like 11 gigs
> We had a log several months ago that was over 25 gigs this caused the
> log to fail to grab some of the entries, this stopped us from verifing a
> problem
> Is there a method to flucsh or limit the size of the log now I am not
> talking tranlog but the sqlserver log under management tab in enterpise
> manager??
>
>
> William Orova
>
>
> *** Sent via Developersdex http://www.developersdex.com ***

Mr. Kelly,
Thanx for the response
That direction is for the tran log I am talking about the sql server
logs that are located under management tab in enterprise manager. The
tran log is fine it is the sql server log that grows very large
They to my knoqwledge are not the same thing....Right?


Wisord

*** Sent via Developersdex http://www.developersdex.com ***

Sorry I didn't catch that originally. You most likely have auditing turned
on which is bloating the log. Do you have a lot of entries listing
successful logins? If so and you don't need this turn that off via the
server properties in EM. But you can run sp_cycle_errorlog on a regular
basis to keep the log files in check.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Bill Orova" <kwiso@msn.com> wrote in message
news:uE3VJ$SqIHA.1872@TK2MSFTNGP04.phx.gbl...
> Mr. Kelly,
> Thanx for the response
> That direction is for the tran log I am talking about the sql server
> logs that are located under management tab in enterprise manager. The
> tran log is fine it is the sql server log that grows very large
> They to my knoqwledge are not the same thing....Right?
>
>
> Wisord
>
> *** Sent via Developersdex http://www.developersdex.com ***