Thanks again for the comments.

We actually proceeded with the patching yesterday and decided to have a full outage.

This is a list of the actual faiback times experienced when failong...

Our organisations policy is to apply all CUs so it's not something I can change. We did apply this in our test environment some weeks ago but no one...

I've reposted my query on Home » SQL Server 2008 » SQL Server 2008 High Availability after I realised this was a SQL2005 thread.

Steve

A question on cluster patching?

I'm about to patch a SQL 2008R2 SP2CU11 instance to CU12. I start by patching the passive node and once complete I failover the instance...

Thanks for responses everyone. No the databases are not being accessed at all except for configuring DR, test DR and actual DR scenarios. I've just happened to leave...

Do the DR databases have to be in standby/norecovery/read-only mode? I have several databases in DR which have been fully restored (as the data is static) I just wish...

Thanks for the response.

There was no Change Data Control enabled, but select name, log_reuse_wait_desc from sys.databases did flag the issue as replication.

I found a great article on http://blogs.msdn.com/b/sqlserverfaq/archive/2009/06/01/size-of-the-transaction-log-increasing-and-cannot-be-truncated-or-shrinked-due-to-snapshot-replication.aspx.

It...

Jeez, I've spent most of my career developing proper process and procedures to deliver quality software products as I had it beaten into me from day 1 that software engineering...