Log Files - How To Clean Up

I had received a message that my log file is full and it do not enable to me to do a database backup before free up disk space. How do i clean up de log file (_log.ldf)?check 'dbcc shrinkfile' in BOL,

dbcc shrinkfile('db_log',size,truncateonly)|||Thanks, mallier, but my _log.ldf is on another disk driver under mssql\data folder. After executing the command you wrote, i got a message 'not found in the system files'|||run this query to get the log name in ur db


select *from sysfiles
-- u will get log name from name column with extension '_Log'

--replace that name in 'db_Log'|||ok, mallier, excuse me again, but the _log.ldf is 18GB great yet. Some system table was updated after the last command you wrote, but i need clean that _log.ldf to free up space in the disk drive.|||put the database in simple recoverry mode. Checkpoint the database. Backup the database. open QA. run "sp_helpdb (dbname). Find the file number for the log. execute dbcc shrinkfile(<file number for the log.).

LOG

Please help.
I received the mnessage below in my SQL server Agent
Error log file.
[LOG] Unable to read local eventlog (reason: The data
area passed to a system call is too small)
I run SQL 2k, SP3, on WIN (adnvanced)2k,SP3.
Please advice or help?.This should help :-
http://support.microsoft.com/?id=811484
--
HTH
Ryan Waight, MCDBA, MCSE
"Olutimi" <olutimi@.hotmail.com> wrote in message
news:3e7e01c37c2e$c79f1fa0$a501280a@.phx.gbl...
> Please help.
> I received the mnessage below in my SQL server Agent
> Error log file.
> [LOG] Unable to read local eventlog (reason: The data
> area passed to a system call is too small)
> I run SQL 2k, SP3, on WIN (adnvanced)2k,SP3.
> Please advice or help?.
>|||This happens when the eventlog service empties then eventlog (which is done regularly). Nothing to
worry about, IMO.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Olutimi" <olutimi@.hotmail.com> wrote in message news:3e7e01c37c2e$c79f1fa0$a501280a@.phx.gbl...
> Please help.
> I received the mnessage below in my SQL server Agent
> Error log file.
> [LOG] Unable to read local eventlog (reason: The data
> area passed to a system call is too small)
> I run SQL 2k, SP3, on WIN (adnvanced)2k,SP3.
> Please advice or help?.
>