Loading...

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

Last modified: 8/17/2020 2:56:28 PM