SQL data recovery
How to repair a corrupted SQL Server databases
corruption is SQL Server database file byte error and repair a corrupted SQL Server databases by fix the bytes of file .(From data recovery perspective)
SQL Server database corruption may be caused by I/O error, or SQL engine bug, or virus, etc. But all these things get one result : database file losses consistency or integrity, This is a kind of file byte error, There should be 0X0a in somewhere of the SQL data file(mdf or ndf) ,But it is 0X0b . Then corruption happens to the SQL database file. How to fix SQL Server database corruption? Of cause we should modify the error bytes to correct bytes, The most common way is using DBCC CHECKDB command , This is a Transact-SQL command, is available that helps to check the consistency of database,It can repair links between pages, index pointers, structural content, index pages , etc. If DBCC CHECKDB command does not work,Then you can use a software called winhex , It is a powerful data recovery and forensics tool made by X-Ways Software Technology AG of Germany, is a powerful application that you can use as an advanced hex editor, a tool for data analysis, editing, and recovery, a data wiping tool. But you must familiar with SQL database file structures, such as 8KB page structures .There are many kinds of SQL database page, such as data page, index page, IAM page ,PFS page,GAM page,LOB page,etc. You can use winhex to modify the error bytes to correct bytes. If both DBCC CHECKDB and modifing bytes using winhex are failed, You should ask for professional service or use a third part SQL data recovery tool to get important table data out . (one of these is http://www.tomsqlrecovery.com/mdfview.zip).