We use a management tool (Compaq Insight Manager) to do so.

You could also run a series of scripts on a regular basis which use the FileScriptingObject or a WMI...

This isn't a problem I've seen before, to be honest. If it is because you're reaching your limits on hardware (see below), that's why... my organization tends to really overbuy...

Is there anything in your SQL Server error logs, such as an error indicating a latch timeout?

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

If you are getting the error even on the local install, it sounds like something is crashing and taking out the session. In the SQL Server logs, are there any...

Sometimes you'll see these as a result of a failure in a component, in which case you'll see the debug results in the SQL Server logs.

Other times it's because...

The sp_ behavior is "by design" and is hardcoded into SQL Server. As a result, there's no getting around it. I've written about why this would cause recompiles:

http://www.sqlservercentral.com/columnists/bkelley/procedurecache.asp

K. Brian Kelley

http://www.truthsolutions.com/

Author:...

Just a quick check. When you brought up Profiler to see what was going on, were the connections being made using TCP/IP or Named Pipes. We saw time out issues...

Typically though, MS recommends running the cluster group on the first node the cluster was installed on. This isn't a "best practice" per se, just a recommendation. I asked this...

You can use federated databases, but that's not the usual reason for an Active/Active. If you do an Active/Passive cluster, unless you have another application to go on the second...

Sorry, my use of "node" was me typing too fast. If DTC is in one resource group and that resource group isn't available, then the other resource group wouldn't be...

Make sure you set up the ODBC connection to use the TCP/IP netlibrary.

Also, if you're going to expose a SQL Server, I'd advise changing the port SQL Server is...

From the technet webcast today... the Moderator (Jean-Claude armand) indicated they are trying to put into the next version of SQL Server a password expiration policy. Cross your fingers.

K. Brian...

How are you saving your DTS packages. If you are keeping them local to the server then they are stored in msdb. If msdb is backed up, so are they...

For our Active/Active clusters we've left MS DTC in the cluster group. If you need DTC and the SQL Server resource group it's in is down, then the other node...

Not exactly. Active/Active is right. But Active/Passive is nomenclature typically used for only one instance.

Active/Passive:

- Only one instance of SQL Server.

- Runs on one node (active).

- Other node is...