Tool to configure mirroring RRS feed

  • Question

  • Apart from SQL Server Management Studio's "configure security" button on the database mirroring tab of the database properties dialog - are there any other tools or scripts that can be used to configure mirroring?


    If I can't find one, I'd like to write a script / tool that:

    0. paramterizes all the variables involved in database mirroring

    a. configures connections to the primary and mirrored SQL Servers

    b. does the backup / restore between servers

    c. configures endpoints / security

    d. checks possible pitfalls (can't connect, firewall, etc.)

    e. starts mirroring

    f. does all the above for a list of the databases I'd like to mirror (anywhere from 6 to 30 databases)


    SSMS wizards get me through most the above - it's just tiresome to repeat for each database.

    Tuesday, August 28, 2007 12:55 AM


All replies