Hi Allen,

I know that if my log and index drives fail, then I would have to restore my last backup, but I cannot apply the logs that were generated after...

Could someone please help me with this, I need to set up a server today, asap. Thank you!

Have you rebooted the server? This is a long shot, but I had the same issue before and it drove me crazy for two days. I rebooted and...

Just wanted to say that the upgrade was done seamlessly. Everything seems to be working. Thanks for all of your inputs everyone.

It is a terrible "bug" in my opinion. A lot of my tables had very different counts than those that EM showed. Some tables had thousands more rows...

Thank you for your input everyone. I will be doing the upgrade after-hours pacific time. If I see anything interesting worth sharing, I will post it here. ...

Thank you for your input everyone. I will be doing the upgrade after-hours pacific time. If I see anything interesting worth sharing, I will post it here. ...

I defintely will. Thank you.

Thank you Allen!

Now I know that I do not have to mirror drive 1. If the restored system databases did not recognize the databases on other drives, then I...

Thanks for your responses. I am not sure if the way I put the question is understandable. So, I am going to give it another shot:

Drive 1 has:...

This did the trick:

DBCC UPDATEUSAGE (DB_NAME(),'TableName') WITH COUNT_ROWS

Thanks for your input everyone!!

I look at the counts in EM through the table properties. In QA, I run a simple "select count(1)" statement.

I have already ran a "Update statistics" statement. But...

Can you please tell me how this works in detail? I am thinking that if you have a full database backup and some log backups and your log drives...

Hi. I just tried this and I still get the same error message. Thanks for your help.

Thanks everyone.