Getting the Database Out of Restoring Mode

The database may need to be reset, if it is stuck in the Restoring State.

Symptom

CommServeLiveSync.log has the following message:

Res31548 738   11/29 11:43:39 ### CVSimpleDBConnObject::OpenSQLConnectionUsingConnectionString() - Connecting to the database failed - error returned was: INFO: [Login failed for user 'sqladmin_cv'.] [RecNum:1, State:28000, NativeErr:18456, Severity:-1, Spid:-1]

31548 738   11/29 11:43:39 ### CVSimpleDBConnObject::OpenSQLConnectionUsingConnectionString() - Retrying in [1] seconds.. 

Connecting to the database failed - error returned was: INFO: [Login failed for user 'sqladmin_cv'.]  

Solution

1. Open SQL Management Studio.

2. Check the Commvault databases to see if any of it is stuck in the Restoring... mode.

3. If a database is stuck, then use the following query to reset the database:

   RESTORE DATABASE [Database name] WITH RECOVERY

   The above query will not work if the database is locked by another user. Perform the following steps when the database is locked by another user:

   1. Flush off all other users and get exclusive access to the database using the following query:

      USE master
      
      GO
      
      ALTER DATABASE Database name
      
      SET SINGLE_USER
      
      WITH ROLLBACK IMMEDIATE

   2. Re-run the following query:

      RESTORE DATABASE [Database name] WITH RECOVERY

   3. Set the database back to multi-user mode using the following query:

      ALTER DATABASE Database name
      
      SET MULTI_USER
      
      WITH ROLLBACK IMMEDIATE