<div>
If you backup file *.bak is corrupt, then try the one below<br />
<br />
<a href="http://blogs.msdn.com/sqlserverstorageengine/archive/2007/03/05/oh-no-my-backup-is-corrupt-too-help.aspx" rel="ugc">http://blogs.msdn.com/sqlserverstorageengine/archive/2007/03/05/oh-no-my-backup-is-corrupt-too-help.aspx</a><br />
<br />
If your *.mdf or *.ldf is corrupt, then try this below<br />
<br />
<a href="http://blog.sqlauthority.com/2008/04/10/sql-server-2005-restore-database-using-corrupt-datafiles-mdf-and-ldf-part-2/" rel="ugc">http://blog.sqlauthority.com/2008/04/10/sql-server-2005-restore-database-using-corrupt-datafiles-mdf-and-ldf-part-2/</a>
</div>


If you backup file *.bak is corrupt, then try the one below

http://blogs.msdn.com/sqlserverstorageengine/archive/2007/03/05/oh-no-my-backup-is-corrupt-too-help.aspx [http://blogs.msdn.com/sqlserverstorageengine/archive/2007/03/05/oh-no-my-backup-is-corrupt-too-help.aspx]

If your *.mdf or *.ldf is corrupt, then try this below

http://blog.sqlauthority.com/2008/04/10/sql-server-2005-restore-database-using-corrupt-datafiles-mdf-and-ldf-part-2/ [http://blog.sqlauthority.com/2008/04/10/sql-server-2005-restore-database-using-corrupt-datafiles-mdf-and-ldf-part-2/]

<div>
Sorry .... question was a bit vague.<br />
<br />
Microsoft recommends restoring from backup rather than dbcc checkdb <br />
<a href="http://msdn.microsoft.com/en-us/library/ms176064.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms176064.aspx</a><br />
<br />
why is that?<br />

</div>


Sorry .... question was a bit vague.

Microsoft recommends restoring from backup rather than dbcc checkdb
http://msdn.microsoft.com/en-us/library/ms176064.aspx [http://msdn.microsoft.com/en-us/library/ms176064.aspx]

why is that?


<div>
thanks - I didn't know that it clears the plan cache as well - that helped me with another issue I am having - you should get double points :)<br />

</div>


thanks - I didn't know that it clears the plan cache as well - that helped me with another issue I am having - you should get double points :)


<div>
<div class="content wysiwyg-content">
Hi Folks,<br />
<br />
I was just looking at the documentation for dbcc checkdb and I took notice of the REPAIR OPTIONS. It recommends that to repair errors you should restore from backup. To my way of thinking that would defeat the purpose of running the command anyway. If the db was corrupt wouldn't restoring from a good backup fix all your problems anyway? Is there any good doco on this?<br />
<br />
Kind Regards<br />
<br />

</div>
</div>


Hi Folks,

I was just looking at the documentation for dbcc checkdb and I took notice of the REPAIR OPTIONS. It recommends that to repair errors you should restore from backup. To my way of thinking that would defeat the purpose of running the command anyway. If the db was corrupt wouldn't restoring from a good backup fix all your problems anyway? Is there any good doco on this?

Kind Regards



REPAIRING A corrupt sql database

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.