Our PT environment is SQL AlwaysOn just like our Prod environment. App Team now wants to drop a PROD BAK weekly, and maybe some Daily prior to a release; then restore to the PT AO AG.

Not wanting to use a Linked Server, what other ways could I drop the secondary DB

  1. Check if Primary node
  2. Remove DB from AG (puts secondary DB in restoring and which needs dropped)
  3. Restore DB to Primary
  4. Set to full (stand alone)
  5. Auto-seeding will sync to other node

1 Answer 1


use dbatools - its free, opensource and highly customizable.

What I would recommend depending downtime and disk space you have available (I do it daily for 15TB daily using dbatools)

Reference : Refresh SQL Server Always On Availability Group databases using DBATools PowerShell

  • Thanks, exactly what was used! Jun 14, 2023 at 14:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.