shrink transaction log file 2

[jianbo]

One of my database's transaction log file increase to an unbielivable 7GB. I wonder how I can shrink it. And Which operation will cause the transAction log file increasing?
Thanks.

 

[JamesLean]

Have a look at this FAQ:

Shrinking Databases and Logs - SQL 7 and Higher
faq183-1534

--James

 

[JohnBates]

jianbo,

Be careful that you don't have 'Full Recovery' model - that is the default when you create a db in 2000.

Right-click the db name --> Properties--> options.

Full will eat up disk space quickly. But it depends on your needs.

John

 

[jianbo]

Spent some time to understand the content of the help resource, finally I shrink my log file successfully. Thanks,JamesLean and JohnBates.