SQL Server performs various serious operations and hence it’s very much likely to get corrupted. Few most frequent causes of errors are as follows,
• Sudden shutdown.
• Link or network failure while performing any task.
• Database invalid file header
• Bad sector occurrence in the storage media.
• Happening of memory error or shortage
• Inaccessibility of partition or drivers.
• Media damage or corruption
• Transactional Deadlock of MS SQL database.
• Unknown errors like “0x80070218”, “CRC error”, SQL error 5171”, “MS SQL Webadmin error” or similar.
• Malfunctioning of hardware
Once your MS SQL server database gets corrupt it is really very difficult to repair it and restore data from it.
If you have available back-up then it’s easy to restore database objects.
But in case you don't have any backup then to repair corrupt SQL database and recover its data some third party repair tool must be used. I would suggest you to try SQL Repair Tool[/url]. This tool scans the damaged database and repairs to recuperate inaccessible objects in MDF and NDF database files. It recovers tables, keys, views, stored procedures, triggers, indexes, deleted records etc.