Is there any way to back up a non readable secondary replica database to restore in a dev environment and then do dbcc checkdb? Will appreciate any help!
asked Jun 2, 2018 at 1:09
Add a comment
|
1 Answer
Backups are only allowed in readable secondaries, so not really.
Also you need to take in mind that running checkdb might be considered a production workload if you don't run it in production too.
You should be running checkdb on all your databases regardless primary or secondary and also your backups, that way you wouldn't have to license the instance where you restore your backups and run checkdb on them (you are validating backups, not production databases), otherwise MS can make you pay for that, but I'm not a licensing expert, so better ask to confirm this point.
