Automatic mirroring creation after database creation RRS feed

  • Question

  • Hi,

    Is there any automation possible for creating a mirrored database after a new database has been created.


    A customer logs onto a website and takes up a trial period of the software we sell.  This creates a database for them on our SQL 2008 R2 Standard Edition server.  As this could happen at any time of the day or night, I would like the mirroring to happen automatically.  I am currently using a Witness server and going through the manual backup and restore of database then apply mirroring.

    Many thanks for your assistance.

    Friday, March 1, 2013 1:27 PM


  • This would have to be part of your provisioning process, meaning you will have to add custom code to make this happen.

    David A. Bermingham, MVP, Senior Technical Evangelist, SIOS Technology Corp

    Friday, March 1, 2013 4:51 PM

All replies