Actually having had a re-think, perhaps, as you say, i would utilise the VM HA clustering. My wording needs amending and actually I think I need to have a single...

Perry Whittle (2/12/2015)

---

FCIs are created as completely separate cluster roles and failover independently.

It may pay you to read through my AlwaysOn stairway starting at this link[/url] to get a better...

Thanks Perry,

slk55guy (2/12/2015)

--------------------------------------------------------------------------------

• Two Nodes per FCI (Total = 8 FCIs x 2 nodes per FCI = 16 Nodes)

Starting to sound over engineered, glad it's not my budget being spent...

How many availability groups can you have on the Primary server?

In the real world, you may have one or more associated databases that would be required to fail over...

Can anyone tell me why the calculation for usable size is (v1.percent_free, v1.size_gb * .8 AS usable_size_gb).

I know it's got to do with the initial disk formating and so...

Yes, that has fixed it. Thank you. 🙂

I wonder why this happened.

I have narrowed it down. Removing the Primary Key from the table vol_space and allowing NULLS on the server_name field inserts records but without a server name. Somewhere the server\computer...

Yeah throughout the debugging, the @dt variable never appeared to have a value assigned. All other variables were populated, including server name etc

Hi, getting an error in the write-VolToDb

Exception calling "WriteToServer" with "1" argument(s): "Column 'server_name' does not allo

w DBNull.Value."

At C:\Bin\Write-VolToDb.ps1:89 char:28

+ $bulkCopy.WriteToServer <<<< ($dt)

...