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.
