Environment
NetIQ AppManager 6.x
NetIQ AppManager 7.0.x
NetIQ AppManager 7.0.x
Situation
SQL_LogSpace Knowledge Script provides inaccurate information.
SQL_LogSpace reports the log was greater than 100% full.
Log file exceeded limit.
Log file size is more than it has allocated.
SQL_LogSpace reports the log was greater than 100% full.
Log file exceeded limit.
Log file size is more than it has allocated.
Resolution
Contact your SQL Server Administrator to run the DBCC UPDATEUSAGE command against the SQL Server in question. DBCC UPDATEUSAGE reports on and corrects inaccuracies in the sysindexes table.
Cause
The sysindexes table has a problem that causes incorrect space usage reports by the SP_SPACEUSED system stored procedure. The SQL_LogSpace Knowledge Script runs the command DBCC SQLPERF(LOGSPACE) to determine a database's available log space and track log space usage, and that command calls the SP_SPACEUSED system stored procedure.
Additional Information
Formerly known as NETIQKB51691
For more information about DBCC UPDATEUSAGE, see SQL Server Books Online.
For more information about DBCC UPDATEUSAGE, see SQL Server Books Online.