FAQ: My database transaction log is too large

If your database is getting too large, it is most likely because of the transaction log file.
If you have changed the default recovery model from "simple" to "Full" recovery model, this will cause your transaction log file to grow very large.

You can shrink your database by setting it to the "Simple" recovery model and setting it to auto-shrink.
This can be enabled by running the following queries against your database:

alter database dbname set RECOVERY simple
alter database dbname set AUTO_SHRINK ON

  • 3 Users Found This Useful
Was this answer helpful?

Related Articles

FAQ: Why is the design feature greyed out in Enterprise Manager?

The reason why you would not be able to use the design feature (greyed out), is because some...

FAQ: What can I use to connect to my MS-SQL database?

You can use any third party MS-SQL client like:-SQL Server Management Studio express (microsoft...

PRB: Cannot connect to SQL 2008 or 2012 using Enterprise Manager

Enterprise Manager is not compatible with SQL 2008 or 2012 and will therefore not allow you to...

FAQ: ODBC Connection String changes for SQL 2005

If you are getting errors connecting to the database from your code. If your ODBC connection...