You could take the db offline then detach and then delete the log.
SQL server will create a new trans log once the db is back online.

Sincerely,

Justin






-----Original Message-----
From: jean-marc Ledgister
[mailto:mssqldba-ezmlmshield-x89048268.[Email address protected]
Sent: Friday, July 30, 2004 9:45 AM
To: LazyDBA Discussion
Subject: Spam:transaction log is ~ 50 Meg how do i trunk/comit the log?

transaction log is ~ 50 Meg how do i trunk/comit the log?
can i just delete the log?



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]



MS Sql Server LazyDBA home page