# 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

×

Loading...