LOG FILE

My SQL Transa Log file reached 50 gb.
For some reason I am not able to lauch SQL Server Agent
hence i can not schedule a job that 'clean up' the log.
Is there any other way to Truncante it ?The sql agent may be a permissions thing.
Has the password changed on the account used by the agent or
has the account been disabled or anything else happened to it?
"FREDYCOREA" <fredyCorea@.hotmail.com> wrote in message
news:0e7201c3917f$e12a3660$a301280a@.phx.gbl...
> My SQL Transa Log file reached 50 gb.
> For some reason I am not able to lauch SQL Server Agent
> hence i can not schedule a job that 'clean up' the log.
> Is there any other way to Truncante it ?
>|||Do you want to empty the file or shrink it. All agent does is executing SQL commands. To empty the
file:
BACKUP LOG dbname WITH NO_LOG
To shrink the file:
DBCC SHRINKFILE
DBCC SHRINKDB
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"FREDYCOREA" <fredyCorea@.hotmail.com> wrote in message
news:0e7201c3917f$e12a3660$a301280a@.phx.gbl...
> My SQL Transa Log file reached 50 gb.
> For some reason I am not able to lauch SQL Server Agent
> hence i can not schedule a job that 'clean up' the log.
> Is there any other way to Truncante it ?
>

Log Agent fails "could not execute sp_repldone / sp_replcounters"

The Log Reader Agent has failed again with the error "Could not execute
sp_repldone/sp_replcounters.." and we are unable to restart the agent.
MSrepl_transactions table holds two entries on the Distribution database one
dated 9-24 and the other 10-10, and the xact_id is not the same as the one
listed with sp_replcmds run on the publisher. What can we do to restart the
Log Agent and not loose any transactions?
Please help...
Thanks,
Fidel Arbizu.
enable logging as per this kb and post the log back here.
http://support.microsoft.com/default...b;en-us;312292
"farbizu" <farbizu@.discussions.microsoft.com> wrote in message
news:8903046C-0E27-4200-AED8-C411BDF18E34@.microsoft.com...
> The Log Reader Agent has failed again with the error "Could not execute
> sp_repldone/sp_replcounters.." and we are unable to restart the agent.
> MSrepl_transactions table holds two entries on the Distribution database
> one
> dated 9-24 and the other 10-10, and the xact_id is not the same as the one
> listed with sp_replcmds run on the publisher. What can we do to restart
> the
> Log Agent and not loose any transactions?
> Please help...
> Thanks,
> Fidel Arbizu.
>

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?.
>