A better option would be to point the op to the stairway on this site

not necessary or advisable either!

to clarify if the restore is on the same server the above...

Thanks for your offline idea, and for sp_who2.

It was "Something" from Redgate that caused the trouble. I have uninstalled, and used your trick, and the db is up and...

depends on your current licence model, but yes you'll need a licenced edition for each replica.

If you have enterprise agreement with software assurance you can get licence concessions for availability...

We are self hosting sql servers, we are not using Azure for sql servers. and we would like to do encryption on data that is at rest for multiple...

a little more info on the AWS config would be nice, such as type and cpu resource allocation.

and theyre definitely sql user not db or app role or some other entity?

Basic AG supports only 2 replicas with 1 database, you can have a listener in basic AG.

what was the original version of this database, im guessing it came from a very early version.

You're saying you dropped all users from the database but sysusers still shows 2...

im not sure either, you’re...

Thank you Perry, sorry for the typo, corrected. This answers my question clearly, I see some articles asked to backup DMK and save it to a safe place, not...

btw who’s Peter?

Hi Peter and others,

So it sounds we just create DMK on each server instead of using restore backup of DMK from another server? since you mentioned ensure the DMK...

What networking restrictions are there in place, there are a number of ports required for the nodes to fully communicate, are there any firewall devices