oh - just realized you said 2005 - this is a 7.0 and 2000 specific forum - there's another 2005 specific forum.

ok - could be transient problems in the IO subsystem? Can you post the output from CHECKDB when it does find errors? Is this the same for all DBs or...

Sounds like it's not actually running in your maintenance plan properly if you can manually run it and it takes longer. How do you have your maintenance plan setup? Custom...

Did you try killing the spid manually with 'kill '?

Have you tried setting the database to single-user mode?

ALTER DATABASE yourdb SET SINGLE_USER WITH ROLLBACK IMMEDIATE or WITH NOWAIT

That only works if the database was cleanly shut down - i.e. the transaction log doesn't have any transactions that need to be rolled back. In this case the database...

My bet is there's a ton of transaction log being recovered. Can you check the disk IOs on the log drive?

Beware of trusting the estimated completion times in the dm_exec_requests...

ok - that acronym still doesn't mean anything as far as SQL Server is concerned. MDF, NDF, LDF are the acronyms people use for the primary file, secondary files, and...

Yup - AdventureWorks is a 2005+ database.

Regular database files (mdfs, ndfs, ldfs) are never sparse. Period.

The only files that SQL Server creates that are sparse are those used by database snapshots - either explicitly created or...

Can you post the CHECKDB output I requested so I can see how the record is corrupted? Then I might be able to help you.

ok - a few misconceptions need to be corrected here.

"Since backups are just from committed transactions"

"A restore restores the data, not the log. It sets the log file size, but...

What is a DBF database?

Are these the only errors in the output from CHECKDB? If not, please post the entire output.

Thanks!

fyz (5/16/2008)

---

Hi tuanta55,

If necessary, I think you can try a utility called Advanced Access Repair[/url] to repair your Access file. It works rather well for my corrupt Access files....