JoshDBGuy (8/18/2015)

---

We have a database that does require a failover if something goes wrong. However, the data isn't important enough to require point of time recovery. Am I able to...

are your backups preferred on the primary or a secondary?

how often do the full backups run?

worker thread exhaustion can be an issue, can you provide more detail on the number of databases on the instance configured for HADR?

depends how busy the instances using DTC will be, if you expect high volume then 1 per...

It involves a special LS configuration and requires in depth knowledge

find out why the data movement is being suspended in the first place, can you provide more detail as to what exact messages you receive, stop the sync issues to...

can you provide a resource dependency report please using the following

get-clusterresourcedependencyreport -group YourAG_Name | copy-item -destination drive:\somefolder

RonKyle (8/14/2015)

---

Thanks for that clarification. So if I don't need the instance to act within an Always On group or cross domains, a virtual service account should be sufficient,...

atulyan.aries (8/14/2015)

---

Hi,

Kindly let me know apart from the following what else is required

2 for private network

2 for public network ......

1 for virtual server/windows cluster ip which is...

have you checked the local settings, for example HBA settings and firmware

it's still CTP at present and I think will change, the CTP is a taster of what's coming 😉

with the introduction of basic AO groups in standard edition of sql server 2016 I...

RonKyle (8/13/2015)

---

1. Create a managed service account. This is created at the domain level and assigned to a single computer to run a service. The name has a $...

JManuelN (8/14/2015)

---

Hi,

Also check the first lines in the error log if there are messages related to SPN registration like this one.

--The SQL Server Network Interface library could not register...

Jonathan AC Roberts (7/24/2015)

---

Hi Christopher

The script only calls xp_fixeddrives if the version of SQL server is below 2008, When the version is 2008 or higher it uses dm_os_volume_stats and reports...