-
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
-
-
Not help, Mongo...
Dear Mongo and Others,
I've read the article, but it doesn't help me. Well, sorry, I do said that DUMP TRANSACTION statement isn't work. But I don't mean that it's not really work.
Ok, let me make a clear here. What I'm gonna do is not trying to empty the transaction log. If it's only empty the transaction log, I know and I always use DUMP TRANSACTION statements.
But, What I'm gonna do know is to reset the max. transaction log size.
At the first time I set my database, I set the max. log size to 20 MB, but, now, it has growth to 100 MB.
So, how can I resize the maximum log size to 20 MB again ???
Thx,
BRgds,
Wen Lie
