1) When performing a full restore over an existing database, SQL Backup sometimes reports that the database cannot be restored because it is currently in use. http://www.codeproject.com/Articles/292135/Fixing-database-is-in-use-error-while-restore-data
2) Another common error is Error 3154: The backup set holds a backup of a database other than the existing database SSMS
3) Possible Media Errors During Backup and Restore (SQL Server)
4) Responding to SQL Server Restore Errors Caused by Damaged Backups
Hi,
For Database restoration you can look at the TechNet artcile available over MSDN
https://technet.microsoft.com/en-us/library/ms190952%28v=sql.105%29.aspx
Another good link which can help you out is over stackoverflow
http://stackoverflow.com/questions/18699463/sqlserver-restore-database-error
In meanwhile can you let us know what is the exception you are getting in restoring the database . It is essential to
provide you better solution .
Thanks
Abhishek
- Proposed as answer by Simon_HouMicrosoft contingent staff, Moderator 15 hours 1 minutes ago