The worst part is: I can already guess what you're linking to, but still get the song stuck in my head just by thinking...

... aaaaand now I have the soundtrack of Frozen into my head. Thanks. :crazy:

Sergiy (12/14/2016)

---

Koen Verbeeck (12/14/2016)

---

sknox (12/14/2016)

---

The question is written as "How can you identify any differences?"

However, 3 of the four answers fit that question as written.

The question should have been...

sknox (12/14/2016)

---

Koen Verbeeck (12/14/2016)

---

sknox (12/14/2016)

---

The question is written as "How can you identify any differences?"

However, 3 of the four answers fit that question as written.

The question should have been...

sknox (12/14/2016)

---

The question is written as "How can you identify any differences?"

However, 3 of the four answers fit that question as written.

The question should have been "How can you...

As...

There shouldn't be. Always expect the latest (officially released) version of SQL Server, unless explicitly stated otherwise.

Toreador (12/14/2016)

---

Even with...

Great question Grant, definitely learned something.

Thanks for the question.

Thanks for the question.

Uwe Ricken (12/9/2016)

---

Hi Koen,

NO - TDE is EE only. Extract from the official resource:

Feature | EE | SE | ..

TDE | Yes...

According to the official resource it's indeed Enterprise only.

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

TimCarrett (12/8/2016)

---

I think the question could be ambiguous as I took it that you only wanted the backup to occur on the Secondary hence I choose Secondary_Only.

"I want to set...

Easy one, thanks.

Easy one, thanks.