Return
-
Title
MSSQL repository not truncating the logs when taking a full backup -
Description
Why are SQL Server repository log are not getting truncated after a full backup?
-
Cause
-
Resolution
Truncating the logs when taking a full backup and how to move the MSSQL 2005 database file to another disk are procedures independent of Foglight and the responsibility of the DBA and customer. These procedures are outside the scope of Quest Support.
The Management Server requires a database repository. This can be either the embedded database included with Foglight or an external database. When an external database is used, you are responsible for its procurement, installation, and management.Detailed information regarding Database and Supported Versions is available in the Release Notes
-
Additional Information
http://support.microsoft.com/kb/907511 http://social.msdn.microsoft.com/Forums/sqlserver/en-US/98a70bc6-7fbe-4b1d-8c8e-90ca0639a884/transaction-log-does-not-truncate-and-shrink-using-a-sql-server-2005-maintenance-plan?forum=sqldatabaseengine