Transition Logs OK to Delete?

[mrook]

I've recently been thrown to the wolves in regards to SQL Server Admin. I have a transition log Approching 18GB. Is it ok to delete this file through the enterprise manager? If so will it recreate itself? What is an ideal size restriction on these transition logs?

Any info will be most helpful

 

[tlbroadbent]

Check out faq183-1534 "Shrinking Databases and Logs - SQL 7 and Higher" in the SQL Server forum.

The ANSI_SQL forum is for questions related to the standard SQL language not server administration of a specific RDMS. See faq220-1073 - "What is ANSI SQL? Why This Forum?"
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.