Try looking up dbcc shrinkfile in BOL.

-----Original Message-----
From: Conahan, Patrick [mailto:Patrick.[Email Address Removed] Friday, June 14, 2002 2:51 PM
To: '[Email Address Removed] shrink transaction log


How can I shrink the transaction log .ldf file? I can't find this in
BOL.......
I shrank the database interactively thru EM, but the transaction log didn't
shrink any......

Patrick Conahan
Consultant
Project Implementation &
Database Support Services
The TriZetto Group
Office: 847-887-8080
Fax: 847-887-8001


---------------------------------------------------------------------
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page