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

Open SQL Management Studio.
Check the Commvault databases to see if any of it is stuck in the Restoring... mode.
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
```