CV Troubleshooting DB

Hi ​@SSchmidt,

The error [100] for the [Troubleshooting] database suggests that Commvault is unable to read the transaction log usage. This could be due to one or more of the following issues:

* Corruption or inconsistency within the database
* Log file issues (e.g., large unbacked log, uncommitted transactions)
* Permission issues or the database being in an inaccessible state (e.g., offline or suspect)

If you have access to SQL Server Management Studio on CommServ Machine, please log in and verify the state of the Troubleshooting database (Online/Offline/Suspect). Also, check whether the recovery model is set to FULL or SIMPLE.

You can run the following command to check for database integrity issues: DBCC CHECKDB ([Troubleshooting]) WITH NO_INFOMSGS, ALL_ERRORMSGS;

If needed, you can shrink the database from the SQL Server side follow this doc after taking a backup of the DB : Shrink a database in SQL Server

Before shrinking the database, please review the CommServDR logs for any errors related to Validation of the DR export path or Upload issues to Metallic Cloud (if enabled)

Regards,
Dheeraj

hi,

thanks for your quick response. The problem was solved after dbmaintanance full and creating an new share for the disc backups.

Glad to hear the issue has been resolved after creating a new share and running DBMaintenance Full, which successfully shrunk the database.

Regards,

Dheeraj