Guest_imported
New member
- Jan 1, 1970
- 0
This is my problem: I have a database that have a transaction log allocated space accidently expanded to 642MB! and I am using only 10MB.
I have tried the steps to shrink transaction log found in FAQs but it did not help much. I read some document that says the transaction log can not shrink smaller than the size of the log's allocated space, is this true? If yes, is there a way around for me to resize the allocated space (in MB) of the transaction log to 30MB for example instead of having now 642.
I appreciate your helps.
I have tried the steps to shrink transaction log found in FAQs but it did not help much. I read some document that says the transaction log can not shrink smaller than the size of the log's allocated space, is this true? If yes, is there a way around for me to resize the allocated space (in MB) of the transaction log to 30MB for example instead of having now 642.
I appreciate your helps.