I have two databases db-1 (primary) and db-2 secondary now I moved all files location on DB-2 (system databases and default location in DB settings) to be :Q instead of :D the problem is when I create new availability group on primary replica DB-1 I find that files created in old location (:D) on secondary replica ! how can I solve this issue so that when I create new AG files will be created automatically in the new drive :Q not :D on the secondary replica DB-2

Thanks in advanced

  • Welcome to Stack Overflow. Please take the tour. We need to see exact error messages, relevant code snippets.
    – above_c_level
    Jul 19 '20 at 12:21
  • Thanks in advanced?
    – Mast
    Jul 21 '20 at 12:02

If you want the file locations to be different on the secondary, which you should not do if possible, you must manually restore a backup of the primary database. Instructions are here: Prepare a secondary database for an Always On availability group

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy