Dear Professional,

I would appreicate if anyone guide me how I know my database has Torn Page
problem and how to restore the specific torn page from my database backup?

Thanks

What version and edition do you have? If you have 2005 EE then you can
restore a single page and BooksOnLine will have info on that. If you are
using 2005 you really should have Checksum enabled not Torn Page. But you
might want to have a look at these:

http://www.sqlskills.com/BLOGS/PAUL/...rruptions.aspx

http://blogs.technet.com/tnspot/arch...rruptions.aspx

http://www.karaszi.com/sqlserver/inf...suspect_db.asp

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Noor" <naissani (AT) hotmail (DOT) com> wrote