After restoring SQL Database from Backup Exec backup, the database usually will be in “Warm Standby” state. So the following statement needs to be executed to bring the DB back online:
RESTORE DATABASE db_name WITH RECOVERY
>
> EXEC SP_DBOPTION ‘db_name’, ‘read only’, ‘false’
>
> EXEC SP_DBOPTION ‘db_name’, ‘dbo use only’, ‘false’
>
>