Another thing to check... SQL Agent jobs. Are they all running OK? It has been some years ago but changing the server name used to break jobs...

Pete Rose.. # of games with the Reds 2722 LOL

John Mitchell-245523 (8/27/2014)

---

Some vendors are happy for you to do this; some aren't. At the very least, you should monitor performance and, where necessary, tweak the indexing or suggest...

Oh yes they are. I always install them and they are actually using them. That is why we know this is a problem.

You will need to know what kind of growth rate these two databases will have over the next year to 5 years unless your SAN admin will simply give you...

Update:

Well, Microsoft was really of no help. Call the vendor and they had the server team update the firmware for the node and all appears to be running fine...

I got an answer from Microsoft on the Patch Update Conference call. They said applying the patch to the inactive node, failing SQL over to it then patching the...

In the SQL Server install... fire it up and there is a place to check for updates. Click on that. I think it basically goes out to...

It all depends on your disaster recovery strategy and if these servers are database servers only or serve as the application code server as well.

We are just beginning to implement...

The way I have applied SPs and CUs is apply it to the inactive node, restart that node. Once you ahve time for an outage fail SQL Server over...

I opened a case with Microsoft Support. It all points to hardware, IO stack, storage.. something like that. However, server team and storage team so no issues. ...

Gail. I ran another backup with the with checksum and it ran good. I ran a verify of the backup, good. I restored it.. good. I...

I just opened a case with Microsoft. Something very bizzare is going on. On the production SQL Server I ran the database integrity check job and one of...

I am now having the storage team look into the IO and back end storage. There has to be an issue somewhere in one of the layers.

It depends like the last post stated. You should have a Non Production system that looks like your production system and run the SP on it first. That...