I have a mix of seeding options.  I started with Automatic while I was setting up, then switched to manual on a single AG  to practice the manual seeding I...

I have an issue when adding multiple databases with Automatic Seeding.  I have synchronous and asynchronous replicas. It's the synchronous replica that loses its place.  It stops restoring databases somewhere...

I appreciate the article - I've had developers anxious to try entity, and we've experienced each of these issues ad-naseum. Performance was terrible, and the 'new and improved' applications...

That was interesting.

I believe MASTER is usually set to SIMPLE on default.  I've never heard of any argument for setting it to FULL logging, but apparently you can.

SIMPLE is another...

Say your malicious person deletes your symmetric key?  You can restore a master key, but I've seen nothing that tells me how to restore a symmetric key.

You can recreate the...

I got it to work.

I put it in a stored procedure, but the key was to grant CREATE ASYMMETRIC Key rights to the user.

Under securables, select DATABASES as the type...

A Microsoft rep swore they could do this, but I am yet to find a way to either restore or recreate an assymmetric key.  If you lose it, any data...