I don't recall how or if I resolved the problem. Here are two links someone passed along to me that may be of some use.

http://support.microsoft.com/kb/306985/

http://support.microsoft.com/default.aspx?scid=kb;en-us;q323790

If...

My indexes are not spread over multiple files so the link does not apply in my case. That's what I find so confusing.

In terms of disk space I have...

Two questions.

Is it necessary to failover to the passive node in order to apply the patch?

Since Integration Services is installed separately on a passive node due to it not being...

The BOL instruction do not appear to be correct. I needed to follow "How to: Manually Uninstall a SQL Server 2005 Failover Cluster" and even that did not work...

We've been using Double-Take for a few years so I know it works well with SQL Server, however there is a possiblility the new version is not configured correctly. ...

We just had a Disaster Recovery test that experienced some problems with servers using a real-time replication software called Double-Take. Several databases came up as suspect, possibly due to...

I agree it is not ideal and I've only done that for a few older servers based upon recommendations from Microsoft engineers. For new systems our policy is to...

In our case we are using Double-Take to perform realtime replication of data and log files between production and DR. All that is needed if a production server dies...

Are you implying your C drive is not configured as RAID 1 or any other type of RAID configuration? If so, you should consider mirroring the OS and then...

Hi Steve,

We're recovering to build Production, QA and development environments from one master database. I know I can transfer logins, recreate backup devices, linked servers and database objects, but...

Problem solved...thought not necessarily understood.

It turns out each time you install a service pack SQL Server creates a new certificate. Why it doesn't delete the old certificate...

SSIS is installed.

Thanks

I know one .cer file is created when the instance is installed, but how is it used and why does one instance have three files?

Dave

Unfortunately that is difficult to prove. I've opened approximately 12 - 14 cases with Microsoft regarding SQL Server 2005. Only one of those cases did they admit it...

That's all I have found as well.