Torn Page

[deepsheep]

I think I'm in over my head and really need some help.

I have a torn page problem. My co-worker was trying to help and detached the database. Loosing a bit of data will not be a problem. I just need it running ASAP.

Help!

I'm still looking on the internet, but I need simple instructions.

Thanks.

 

[deepsheep]

I should have mentioned that it is SQL 2000 running on Windows 2000 advanced server.

 

[Catadmin]

Per Books Online, you're going to have to restore the DB from the latest backups.

If a torn page is detected, an I/O error is raised and the connection is killed. If the torn page is detected during recovery, the database is also marked suspect. The database backup should be restored, and any transaction log backups applied, because it is physically inconsistent.

Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[ptheriault]

If you don't have a backup. you can run DBCC CHECKDB with allow data loss. But like Cat said, the best method is to restore from backup.

- Paul
- Database performance looks fine, it must be the Network!