Very strange. Can you set this up on a 2nd drive and see if the schedule works?

If you run the schedule now (if you can), does it fail?

Is this one index or 4?

If you remove "no" and "id" what happens?

I would try a new file. You might have some bad blocks in there. The disk should handle it, but using the same file might cause issues. Have you tried...

Are you backing up to disk or tape?

Are you using devices or files?

Do you go to the same set every day? (not recommended)

You should not be looking at the files themselves in terms of managing SQL Server, other than seeing how large they are v how much disk space in free on...

Participate if you can add something. Not everywhere or every time, but become involved, at least where you have some ideas, skills, or strong opinions. Especially at work. I think...

Anders, move to Denver, I'll help you manage those older systems. I enjoyed v6.5!

A reply from Jay Nichols (he's having posting issues):

Create a function like this and your data will be parsed into a table which you can then use to update data...

Hey, it's a big election year, what can I say 🙂

Maybe a few politicians should read this one.:P

The default database set up for your login is not working. Before clicking "Connect", choose a database like master in the options tab.

Keep in mind that it's not the size of the db, it's the load, the number of transactions. Look at your log backup sizes and see if the bandwidth between...

top of the hill would be nice, edge of the gully better. Unfortunately some seem resistant to that training. Like in business, some are happy to drop where they eat...

First I'd be consistent with != and . Choose one.

Second, why the right join? Why not an inner join on the update? I suspect the problem is there, but I'm...

What are the data types? Is this 1 row only with 607 for Col4?

Perhaps a bad installation of it. I haven't seen this to be a problem on other machines.