Strange. I will do some more tests with other db's on this environment. But pretty confident copy only didn't allow me to take a log backup.

Yes the database has only been restored to this environment recently. Therefore the only Full backups ever taken have been done on the replica's with Copy Only specified.

Hi Gail

I just tested what you suggested and found the Copy only backup did not allow me to perform a log backup, as before it complained about not having a...

Thanks for your reply. I understand that Copy Only backups do not affect the LSN.

In order to take a log backup you must first have a full backup of...

Is it the Principal or secondary that is having downtime?

Security without a doubt. Starting with TDE to encrypt the data at rest and getting ready to utilise Always Encrypted for the sensitive data. Auditing SQL account permissions, monitoring failed...