Blog Post

Azure Database Support Blog
1 MIN READ

Lesson Learned #335: BACKUP WITH COPY_ONLY cannot be performed until after the next automatic BACKUP

Jose_Manuel_Jurado's avatar
Jose_Manuel_Jurado
Icon for Microsoft rankMicrosoft
Mar 01, 2023
Today, we worked on a service request that our customer got the following error message: BACKUP WITH COPY_ONLY cannot be performed until after the next automatic BACKUP LOG operation [SQLSTATE 42000]...
Published Mar 01, 2023
Version 1.0
scpman365's avatar
scpman365
Copper Contributor
Jul 05, 2023

I waited a few hours but still got this error.

When I switch to my own KeyVault TDE key. 

I saw the old database encryption_state is 6

6: Protection change in progress (The certificate or asymmetric key that is encrypting the database encryption key is being changed.)

Any ideas? :sad: