Have you run the cluster validation tool to check for any setup issues on the Windows side? Those can frequently be the root of any SQL issues.

No, you're not missing anything. Sadly the log shipping report only gives you information for the primary or secondary. You're best bet is going to be a roll your own...

YaHozna (3/5/2012)

---

I had also forgotten to mention that all instances were left on their original installed RTM versions so an upgrade to SP3 is also imminent. Were there any memory-leak...

You shouldn't need to do anything with the browser service. Just have it run automatically or have it disabled (leave disabled if it's a default SQL install with no other...

Reporting services does this periodically. I'm not sure what can be done to resolve it.

You can absolutely do that, yes.

Except that there's an issue where PLE is reported as being the average across NUMA nodes and therefore isn't a great metric to work with any longer (see Paul Randal's...

How are you attempting to perform the database restore? And is it a native SQL Server backup?

I assure you, I'm no earlier and somebody else has your dollar, I...

You won't be able to use an alias as sp_send_dbmail uses SMTP to send emails, it doesn't actually connect to exchange. As such you'll need to use the full email...

To be honest you should never allow a file to autogrow by a percentage. Why Microsoft still push this as the default option is beyond me. You should always have...

What resource failed to come online? Are there other failures in the system or application event logs right around the time of that failure?

You might want to check that both the machines are listening on that port and that there are no firewalls between them.

Check that the computer you are trying to check for exists, that you have permission to access WMI and that there are no firewalls in the way.

Here's a real quick way to check space using powershell within a function http://sirsql.net/blog/2010/11/23/quick-powershell-disk-space-check.html.

This can be easily adjusted to load the information into a database for storage, alerting, reporting and...