DBA_007 (11/17/2016)

---

We are receiving the below Error message in Mirroring and principal server is failovering automatically to Mirror Server.

Database mirroring connection error 4 'The connection was closed by the remote...

you'd have to break the mirror and re initialise it

Luis Cazares (11/10/2016)

---

This might help: http://download.microsoft.com/download/8/A/2/8A2BC8C5-BBA0-4A9C-90BC-AC957D3454D9/SQL_Server_2016_Editions_datasheet.pdf

The improvement on window functions and error handling.

Native compressed backups, which would speed up your maintenance process.

Extended events to mostly replace traces.

New cardinality estimator.

Improved...

log backups are not encrypted at this version unless TDE in use or using 3rd party backup solution.

SQL 2014 offers encrypted backups

josh-1127203 (11/10/2016)

---

Wow, seriously? So it will just keep adding space to the table?

If that's the case, what is the best approach to deal with this type of situation? I use...

as already discussed,...

ramyours2003 (11/9/2016)

---

I need to resize the t-log by using the index size as the db is in simple recovery , can any one help to identify the index...

see

https://msdn.microsoft.com/en-us/library/ms191233.aspx

https://msdn.microsoft.com/en-us/library/ms178117.aspx

is this an asynch or synch mirror session, is there a witness present?

What in particular are your team reporting a mismatch on?

alex.sqldba (11/8/2016)

---

Morning All,

I have a database, with a filegroup that is 2TB of documents (blob data).

I frequently have restore this database elsewhere, for various reasons that are mostly sub-optimal, but...

szejiekoh (11/9/2016)

---

Perry Whittle (11/8/2016)

---

why on earth do you want the synch to...

szejiekoh (11/9/2016)

---

Can you elaborate further if there are 2 DNS entries per AG listener, what if the DNS resolution (round-robin) resolves to the IP/subnet in the secondary replica node ?...

marcjell (11/8/2016)

---

I'm trying to build a cluster without a domain (a so-called Workgroup Cluster) using the instructions found here: https://blogs.msdn.microsoft.com/clustering/2015/08/17/workgroup-and-multi-domain-clusters-in-windows-server-2016/

I am building entirely within Azure. I spun up two...

why on earth do you want the synch to stop??

most common reason ive seen for node dropping out of the cluster is co-stop on the ESX host, but normally get a different message.

What is the current status on the...