In Brief about SQL Server™: MS SQL Server is used widely for many benefits in many possible ways. Here features like support for application and advanced database administration make this Server a choice of many. It is embedded with options like Fast Recovery and On-line Restoration; both are helpful in decreasing administrator overdue burden.
Corruption in SQL Server™: But, SQL databases are prone to corruption and can occur anytime due to issues from virus attacks, power outage, malfunctioning in OS, damage in page header etc. The outcome of corruption is losing access to vital components. To recover corrupt SQL database due to SQL Error 8909, utilize, outside solution.
CAUSE: The SQL Error 8909 occurred mainly due to header corruption in one of the database pages or due to incorrect operation in read or write
This would prevent you from accessing the records of the specified table. Corruption may spread to other parts and render the whole database inaccessible. In such situations, you may use a backup to restore the database. However, if the backup is unavailable, then you can go with MDF database recovery tool to resolve this header corruption error.