Object DB2 (previous name: DB1) failed in event OnRestore

Hi,

I got the below error after restoring the Farm backup though I had provided the correct username and password.

Object DB2 (previous name: DB1) failed in event OnRestore

In the sprestore log I got the error as below

sprestore log error

[12/12/2012 2:38:05 PM] FatalError: Object DB2 (previous name: DB1) failed in event OnPostRestore. For more information, see the spbackup.log or sprestore.log file located in the backup directory.

                SPException: Cannot attach database to Web application. Use the command line tool or Central Administration pages to attach the database manually to the proper Web Application.

We couldn’t get the reason for occurring this error.

But we noticed that particular DB has not been restored and it’s throwing an error while restoring.

So the workaround is we had added DB name through ‘Manage Content databases’ in Central Administration as below

 Select the appropriate web application before adding the content database as below

Enter Database server/Alias Name, Database Name that has been failed after Restoring the database as below. Click Ok

After this we were able to browse the site without any issues.