Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can the Transaction Log space allocated be resized?

Status
Not open for further replies.

Guest_imported

New member
Joined
Jan 1, 1970
Messages
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.
 
This article explains a sure fire way to shrink the log.


You can also find information and code in the following MS KB article.

INF: How to Shrink the SQL Server 7.0 Transaction Log

These methods really work if done properly. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top