- Why do you need your backup file?
- What version of SQL server?
My sql server backup database file has got damaged, please recommend any solution.
Sorry, there was an error in the link. The one below works.
It's best to search google with the most specific error message that is available. Just "damaged" and "corrupt" are too vague. Also, when asking in a forum, provide all relevant details, like what the type of the backup file is, what you did to restore it and what happened.
For example, both a copy of the existing database made in Windows Explorer (or with robocopy or syncback or such a tool) to your backup device (like an external hard disk) and an export from SQL Server Management Studio can be called a backup, but these are totally different things that need totally different ways to restore.
What is the error message?
You may try DBCC CheckDB with parameters REPAIR_REBUILD or REPAIR_ALLOW_DATA_LOSS to try to fix the corruption of your database.
If DBCC CheckDB cannot help to solve the problem, then you can try third-party tools. The one I have used in the past successfully is DataNumen SQL Recovery at http://www.datanumen.com/sql-recovery/
Hope this helps