locked
Mirror multiple sql 2008 DBs from principle to mirror server RRS feed

  • Question

  • SSMS can mirror a single DB but how does one mirror,say, 15 DBs? 

    TIA,

    edm2

    Friday, October 13, 2017 2:55 PM

Answers

  • Yes you are correct. in t-sql prepare all the 15 databases mirror steps and execute it.

    Thanks, Satish Kumar. Please mark as this post as answered if my anser helps you to resolves your issue :)

    • Marked as answer by edm2 Friday, October 13, 2017 8:11 PM
    Friday, October 13, 2017 5:18 PM

All replies

  • Your question is nor clear, SSMS is a tool.

    can you please elaborate your question.


    Thanks, Satish Kumar. Please mark as this post as answered if my anser helps you to resolves your issue :)

    Friday, October 13, 2017 3:23 PM
  • Sorry to be unclear. What I meant what that using SSMS one can setup database mirroring -- for one database at a time. But suppose I want to mirror 15 databases.  I don't want to use SSMS to "right-click database > Tasks> Mirror" 15 times. I'm thinking a script can do this  part of the mirroring setup.

    edm2

    Friday, October 13, 2017 5:15 PM
  • Yes you are correct. in t-sql prepare all the 15 databases mirror steps and execute it.

    Thanks, Satish Kumar. Please mark as this post as answered if my anser helps you to resolves your issue :)

    • Marked as answer by edm2 Friday, October 13, 2017 8:11 PM
    Friday, October 13, 2017 5:18 PM