Hello, I am facing an issue with the restoration of the "MBAM Recovery and Hardware" database to another SQL server with some other instance name. The old SQL server doesnot have any instance name and the new SQL server to which the database has to restore has an instance name. the restoration of the database "MBAM Compliance status" is a success but while the restoration of the database "MBAM Recovery and hardware" failed with an error as:- Restore failed for Server "MBAM-DBMOVE\r2". (Microsoft.Sqlserver.SmoExtended) Additional Information: system.data.sqlclient.Sql Error:The file "RecoveryAndHArdware_log" failed to initialize correctly. examine the error logs for more details. (Microsoft.SqlServer.Smo) For the restoration scenario, I have backed up the certificate "MBAM Recovery Information certificate along with the private key by using the following SQL query: backup certificate [MBAM Recovery Information Certificate] to file = 'C:\SQLSERVERINSTANCECERTIFICATEFILE' with private key ( file = 'C:\SQLSERVERINSTANCECERTIFICATEPRIVATEKEY', encryption by password = 'password!1' ) The certificate and the key get backed up successfully. Then moved the certificate to the new SQL server and crreated a new certificate there with the following SQL query:- drop certificate [MBAM Recovery Information Certificate] create certificate [MBAM Recovery Information Certificate] from file = 'C:\SQLSERVERINSTANCECERTIFACEFILE' with private key ( file= 'C:\SQLSERVERINSTANCECERTIFACEFILEPRIVATEKEY', decryption by password = 'password!1' ) Then tried to restored the database "MBAM Recovery and Hardware" database. But failed. Can someone suggest the exact ways as how to move the MBAM database "MBAM Recovery and Hardware". I am following the following guide for the MBMA DB move:- http://www.scribd.com/doc/77750131/32/How-to-Move-MBAM-Features-to-Another-Server Gaurav Ranjan

Hi, Please check if the following article is helpful. http://msdn.microsoft.com/en-us/library/ms345408.aspx Meanwhile, I suggest posting a new thread to SQL Server forum to get more insights. http://social.technet.microsoft.com/forums/en-us/category/sqlserver/Niki Han TechNet Community Support

Thanks for the help. Somehow there is something realted with the LDF files created when we install the MBAM database Features. due to some extra troubleshootings, somehow the LDF file was deleted. that's why i was recieving the error"= Restore failed for Server "MBAM-DBMOVE\r2". (Microsoft.Sqlserver.SmoExtended) Additional Information: system.data.sqlclient.Sql Error:The file "RecoveryAndHArdware_log" failed to initialize correctly. examine the error logs for more details. (Microsoft.SqlServer.Smo) So at the time of restoration, the missing of the LDF file was detected and causing the database not to restore. The steps mentioned in this link has proper steps and if followed properly, Can be helpful for the restoration. http://www.scribd.com/doc/77750131/32/How-to-Move-MBAM-Features-to-Another-Server Gaurav Ranjan

thanks for the answer