DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 873235 - Last Review: July 12, 2013 - Revision: 9.2

INTRODUCTION

Full transaction logs can make your Microsoft SQL Server database unusable. This article describes how to truncate and shrink the transaction logs when they grow too large. This article also describes how to prevent the transaction logs from growing unexpectedly.

More information

Step one: Reduce the transaction log size

Step two: Truncate the inactive transactions in your transaction log

Step three: Shrink the transaction log file

Step four: Prevent the transaction log files from growing unexpectedly

More information about transaction log files

More Resources

For more information about how to reduce the transaction log size, visit the following Microsoft websites:


References

For more information about troubleshooting the additional disk space requirement during the recovery process, see the "Insufficient disk space" topic in SQL Server Books Online. For more information about the transaction log architecture, see the following topics in SQL Server Books Online:
  • Transaction log architecture
  • Transaction log logical architecture
  • Transaction log physical architecture
For more information about the recovery models in SQL Server 2000, see the following topics in SQL Server Books Online:
  • Selecting a recovery model
  • Simple recovery
  • Full recovery
  • Bulk-logged recovery
  • Switching recovery models


Applies to
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Workgroup Edition
Keywords: 
kbsqlsetup kbdiskmemory kbdisasterrec kbhowto kbconfig kbinfo kbcip KB873235
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support