Dear All,

I've got confuse with my SQL Server Database. Let's say that my database name is "Security".
At the first time, I've set the size of the database to 150 MB, and the transaction log file to 20 MB ( 10-15 % from 150 MB ).
But, I've forgot to uncheck the Automatically grow file at Transaction Log Tab. So, now, my Transaction Log size has growth to 100 MB ( out of my control ).
For your information, I've now unchecked the automatically grow file. But, I can't resize the Transaction Log to the lower size.

My question is, can I reset my Transaction Log file to the lower size, let's say I want to resize it to 20 MB again ???

How can I do that ???

For your information too, I've done this statement below, but it doesn't work out...

DUMP TRANSACTION database_name WITH NO_LOG

Is there any other way to resize ???

Thx,
BRgds,
Wen Lie