Yep, tried backup WITH CHECKSUM. Restore still errored out just the same.

I messed up there by concatenating "Same thing happens..." with the message. Sorry.

This be wierd.

I

altered a database (previously restored to SQL2008R2 instance) to do page verification with CHECKSUM.

verified by looking in sys.databases.

rebuilt all indexes using a...

Thanks,

Then to the last question in the original post: Is there a TSQL command that can count the pages

that have (or don't have) a checksum? ...

On a big database running a maint plan to rebuild all the indexes can take a very long time. The, too, some indexes cannot be rebuilt. Seems...

Thanks to participants for your contributions. I think I have a couple of ways to approach failures now.

I'm still interested to know, if anyone has thoughts...

Getting closer. If found the Manage Connections tab. There are two choices.

1. Local Server Connection.

This has sa as the id and a blank password. If...

I'm not sure what is meant by "the connections to the local instance ". Maintenance

plans don't connect, except that they run a job via the SQL Agent....

One more curious thing:

I can log in to SSMS as sa with the new password. I can modify the maintenance plan.

I CANNOT delete the maintenance plan. Error...

Ok. We hit it. SQL 2008. Maintenance jobs fail. Code: 0xC00291EC

"Connection may not be configured correctly or you may not have the right permissions on...

A couple things I am unclear on:

1. It sounded like you were deciding between rebuilding and restoring. It seems to me that

a. If the instance was...

Cluster sandbox would be lovely, but won't happen any time soon. We're a big shop. Stuff happens slow or never happens at all. I couldn't get access...

I tested on a non-clustered instance. Separating the Master log and data is not an issue.

I put them on separate drives and all went well.

HOW ABOUT THIS?

I...

No, I did not. I will test on an unclustered instance, having log and data in different places. I may have tested that way originally, but I...

I missed something because it didn't work. App DBs moved ok. msdb, model , and tempdb moved ok. I then changed the startup parameters in Configuration...