Hi,sram24_mca,

When a MDF database file is corrupt, you can first use the SQL Server build-in command DBCC CheckDB and CheckTable to repair it, see:

http://technet.microsoft.com/en-us/library/ms176064.aspx

and

http://technet.microsoft.com/en-us/library/ms174338(v=sql.110).aspx

to get more information about the commands....

Hi,

Let me explain the case in more details.

The database comes from a customer. The customer sent the full backups on Oct 1(Oct_1.bak) and Oct 10(Oct_10.bak) and want to restore to...

You may try some third party tools. The one I have tried successfully in the past is DataNumen SQL Recovery at http://www.datanumen.com/sql-recovery/[/url] . You can use it to scan and...

You may make a backup of your database, then refer to the article at http://www.datanumen.com/sql-recovery/articles/dbcc-checkdb.htm to use DBCC CHECKDB to check your database, or try third-party tools such as DataNumen...

Which parameter is used to rebuild the database, 'REPAIR_ALLOW_DATA_LOSS' or REPAIR_REBUILD? If you use REPAIR_ALLOW_DATA_LOSS, then you must backup your database first since this parameter will cause data loss.

If REPAIR_ALLOW_DATA_LOSS...