SQL Server Performance

Restore corrupted database - any clause using RESTORE statement?

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Aug 5, 2007.

  1. Anonymous New Member

    Do you know you can try restore a corrupted database backup using simple clause within RESTORE statement. You may be aware that SQL 2005 version can perform an optional computation a backup checksum on the backup stream; if page-checksum or torn-page information is present on a given page, when backing up the page, BACKUP also verifies the checksum and torn-page status and the page ID, of the page. SQL Server supports three types of checksums: a checksum on pages, a checksum in log blocks, and a...(<a href="http://sqlserver-qa.net/blogs/tools/archive/2007/08/05/restore-corrupted-database-any-clause-using-restore-statement.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=1258" width="1" height="1">

Share This Page