Date - 05/2011
Affected Product & Version - Backup 8.0 and later
Affected Module & Version - AM for MS SQL Server Version 5.0 and later
OS Version - Windows 2000/2003/2005/2008
Application Information - SQL Server 2000/2005/2008
Description:
Restored SQL Server database can't be accessed upon successful restore.
Symptoms:
After the SQL Database is restored, the database status remains as "Restoring…" and it can't be accessed.
Make sure to select "with RECOVERY" restore option when restoring the last backup (differential/tail-log, or even when restoring standalone Full backup) so that recovery process completes upon restore and the restored database becomes ready for access.
