DSQLServer (1/22/2014)

---

I have a server that doesn't have kerberos setup and isn't using sql ID and it all works. Since it works, I've not checked the finer related details...

Thats not correct, see my post above.

SFW HA has VCS cluster resource...

All nodes must be part of the same cluster.

You can have an AO group span different clusters but its only supported for migration purposes.

david.alcock (1/22/2014)

---

May I ask another question Perry. With regards to AlwaysOn, is it possible to have a 2 node cluster, availability group configured accordingly and then add a secondary...

As far as I'm aware you cant. If you try to enable .NET role without internet access you have to use cmd line to disable online checks

As follows

ALTER DATABASE olddata ADD FILEGROUP newFG

ALTER DATABASE olddata ADD FILE(NAME=somename, FILENAME...

SQL Server data compression would be my preference over NTFS compression

Yes but what was the free space inside...

The diff generally wouldnt be too large to do that

I'm guessing by the sudden stunned silence you have fixed it 😀

the first step you need to do is to increase the frequency of your t-log backup. Hourly is definitely not frequent enough, try half hourly or quarter hourly and STOP...

if you use sql server auth that will work. For the Windows auth to work you'll need to setup the SPNs and enable Kerberos

The only issue ever caught me was the .net framework install on a machine with no internet access (typical when deploying on a VM), you have to install it via...

Akayisi (1/22/2014)

---

Perry Whittle (1/22/2014)

---

In this case you can fix the missing tran log backups issue by taking a differential backup on the...