I am trying to take a differential backup of my primary database by connecting to the primary replica, but I can't do that. We use SQL Server 2017 EE with latest CU. Database is in full recovery model and full backups are taken everyday at night. The Copy-only backup option and OK button are grayed out. Could someone help to understand why it is not possible to perform the mentioned action?
It's anybody's guess why the UI is preventing you from being able to use the copy-only checkbox. So I can't give you an answer and don't think it would be productive to throw out guesses. I can offer a workaround (and generally, this is a better way to accomplish just about anything a pointy-clicky UI tries to do for you):
- Press the
- Copy the script to a new query editor window
- Add the
If you want a definitive answer in addition to a workaround, you'll probably have to talk to Microsoft, who wrote the code, has source code access, can meaningfully debug if they can reproduce your scenario, etc.