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