Our Test (and Dev) instances are supposed to be the same as Prod, and the business has quite high expectations for recoverability. In most cases (across all environments) we have...

Agreed.

I've used the fridge...

sysadmins can connect to any database/AG via any listener. Accounts with more restricted permissions cannot. Therefore I'd always set up one listener for each AG. If you don't, and the...

Being primarily a developer, I don't know exactly which licensing you're speaking of.  I do know, however, that our vendor OKs & recommends a test system, and we do...

> restoring to our test system and making sure our main business application works.

Any reason you don't do a DBCC on the test instance while you're there? Seems like...

Such a good point, David Poole.

Always at the back of my mind is a former manager who said to me "Ah, but DBAs never do anything else". He was trying...

This won't help you much but a few weeks ago I asked in another thread about the same thing. It's a SQL 2017 instance that is technically part of a...

Nice one, Brandie.

That's a good point too, although it's only really an issue if you use differential backups in your environment. If you do, the SAN snapshots need to be copy-only (so...

Sorry, I was slow to post Submit- I see Thom has already got there.

It's supported at the moment. If you were to upgrade to SQL 2019 it might not be then, but they won't remove that option in SQL 2017.

https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-compatibility-level?view=sql-server-2017

To echo what's said above, you need to be so careful with VSS snapshots where SQL databases are involved because a record that *looks* like a full database backup is...

• This reply was modified 6 years, 4 months ago by Beatrix Kiddo.

Bear in mind that if you query the other replica you may be liable for an additional license cost.

June 17th 2019.

Ah yes, Production In Lieu Of Testing (PILOT).

I drink because I've spent two days trying...