I finished swapping out all of my shared drives on two clusters and was able to run cluster validation without error. 🙂

I tested complete network failure as described above and...

Perry,

Thank you for the info.

The SAN Guy finished creating a new set of LUNs for two SQL cluster servers and our VM Guy is currently creating the RDMs. I'll let...

"Use of Microsoft Cluster Service requires that each cluster disk resource is in its own LUN"

I believe this requirement has everything to do with Persistent Reservations

...Looks like I have to...

We are attaching a LUN and we...

The shared disks are created from LUNs attached to the ESX servers from a SAN.

Typically, more than 1 shared disk is created from a single LUN.

Perry,

I do not have a Test Environment just for SQL 2008 R2 Clustering.

I am performing tests on an environment that has not had Sharepoint Setup on it yet (which would...

Hi Perry,

The VM's are on separate physical hosts.

I think the vswitch is host based (I would have to know how to verify)

Storage is presented via SCSi controller (LSI Logic SAS)...

This Split-Brain issue is re-creatable.

In a separate environment, I have another 2 Node SQL Cluster.

By interrupting network communication on the active node for 1 minute, I caused the same...

Thank you Perry for the script.

That Really Big Table that I moved to a new file group?

Well, I sort of moved it. The Primary Key Index and the Table went...

Ug. I was hoping I would not have to do that (move all tables to a new filegroup).

The following finished:

DBCC SHRINKFILE (N'FileGroup1File1' , EMPTYFILE)

I then ran the following

ALTER DATABASE MyDatabase...

The problem filegroup (set as default) which I will call Filegroup1 only had one ndf file in it. So all 50 table objects in the database are in FileGroup1File1 minus...

Perry,

I was not clear in my original post. I tried to clear it up a bit in following posts.

The 300GB Table that had mass deletes performed was copied to a...

I dropped a 300GB Table.

All the other tables are very small in this filegroup, and I ran rebuilds on all the remaining tables in the entire database.

EMPTYFILE 77% complete. Lucky...

I am specifying the size to shrink it to (1024)...and it does not work past 52GB

Rebuilds were done on all tables in the file group

The total actual data size for...

According to :

http://msdn.microsoft.com/en-us/library/ms189493.aspx

Shrinking below initial size will only work if the database file is empty.

My guess is that as soon as you add data (before shrink), you will...