Hi Vincent,

Sounds like its rebuilding a bunch of indexes after removing some data pages. Btw - everything that repair does is fully logged, regardless of your recovery model.

What were the...

Unfortunately there are no good resources available to really diagnose these issues in-depth. On all the customer systems I've seen, there has been a fault found when SQLIOsim reported errors.

All...

This means that your I/O subsystem is causing corruptions. What does it say in the extended description for these errors?

Is this a new system? If not, have you ever seen...

May Anne Duran (10/15/2008)

---

Hi Gil,

OK I get your point.

Yes, I have a backup that i can rstore from. But a half day's worth of data would be lost because backup...

Sysdepends - don't remember in 2000 - and I don't have a 2000 server handy to try it on.

May Anne - if your database is in the FULL recovery model...

Why did you do that? And how did you delete the log? Using BACKUP LOG... WITH NOLOG or actually rebuilding it with DBCC?

Your log is probably growing because you're not...

Well, the best course of action is to restore from your backups. I'm guessing you don't have any because you took the destructive step of rebuilding your transaction log. If...

This isn't a data coruption problem - this is an issue with your application logic or table schema...

Its not needed to run DBCC CHECKDB - not sure whether Agent sets it or not in 7.0 or 2000.

Someone (or some application) turning on the trace flag that allows trace output to go to the console rather than the errorlog.

Read the blog post - it explains all about emergency mode and emergency mode repair. Thanks

See http://www.sqlskills.com/blogs/paul/2008/08/29/TechEdDemoCreatingDetachingReattachingAndFixingASuspectDatabase.aspx

And I should have mentioned, even if you can hack the database into the server with a similar process to the one I blogged yesterday, the database is still completely...

Game over I'm afraid - there's no way around that.

This feels to me that something stomped on an extent's worth of pages starting at 1:598 in msdb. I'd follow David's advice around checking out your IO subsystem. You could...