subject: Solving Error 2579 and repairing MDF file in MS SQL Server 2008 [print this page] Run DBCC CHECKDB: If the backup method does not solve the problem, then you should run DBCC CHECKDB with the suggested clause. This SQL repair tool will deallocate the extent from the IAM page.
If the error still persists, then you should use a third-party SQL repair software to repair SQL database. These non-destructive MDF repair tools have rich user interface that make SQL repair safe and secure.
Talking of SQL repair tools, Stellar Phoenix SQL Data Recovery is one such tool that repairs SQL database from all instances of logical corruption. This MDF file repair software recovers various database objects such as stored procedures, NDF files, triggers, tables, collations, defaults, etc. Specifically devised to repair MDF files created for MS SQL Server 2008, 2005, 2000, and 7.0, this MS SQL Server repair utility also preserves the relationships among different tables. It is compatible with Windows 7, Vista, Server 2003, XP, and 2000.
Solving Error 2579 and repairing MDF file in MS SQL Server 2008
