Thanks Lowell!

Your strategy certainly gave me a few thinks to think about. I've been trying to break this out in steps to get the calculation right. Just a...

I read the link you sent along previously.

Yes tempdb, databases and log files are on seperate drives (at the OS level). The drives are SAN raid 5...

Thanks for all the posts. So even though the database appeared totally "out of wack" - technical term, once the server was restarted the database seems good. I...

Thanks again... I'll post a follow up later.

When I run checkdb I get the same error above.

" The operating system returned error 21 (The device is not ready.) to sql server during a read at offset ....."

I'll...

Another related question - how can I remove the bad database now? Keep getting os 21 error when I try and delete the database....

Thanks everyone for the reply's, I do wish there was another option though - good to know what to do but the recovery will take some time ...

Thanks!

Yes I have a backup - the log is on a different drive. Do you think the only option is to start restoring? SQL was running the entire...

Wow Wayne Thanks,

Another reason to love this forum and its many contributors. This gives me a lot to work with - thanks for your time.

I really need to take...

As far as the text editors go try TextPad, http://www.textpad.com. It's pretty fast and can save using different uncoding options.

Good luck.

This all sounds good. I have been testing transactional replication with a small database. Another question I have is when I start transactional replication with an initial snapshot...

The sp is just a single simple insert. The values to be inserted are passed as parameters. Just insert into table values ...

Thanks everyone for there posts and...

There are no tiggers on the table. I think that the issue is size related because everything runs fine and has been running fine until a few weeks ago...

I have presized the database so autogrowth shouldn't be the issue. I'm running out of ideas. There is a stored proc that does the insert row by row....

Yes it does autogrow and there is a lot of free space on the drive to grow.