how to restore WITH CONTINUE_AFTER_ERROR

this absolutely saved me the other day, I had a bad page on a precious db backup from 5 years ago.. finally found a method to fix it!!!

http://social.msdn.microsoft.com/forums/en-US/sqldisasterrecovery/thread/f31fb497-ebb6-4c84-a824-0966390ad5c6/

RESTORE DATABASE [######] FROM DISK = N’C:ARC_##########.BAK’
WITH CONTINUE_AFTER_ERROR ,
etc

This entry was posted in SQL Server and tagged . Bookmark the permalink.