How to script mirroring from SSMS ?

  • I setup database mirroring in SSMS following /Tasks/Mirror...

    What I need is to generate scripts for that, particularly security configuration. No matter when I click Script button before or after actual settings, I always get a message "There is no action to be scripted".

    How can I generate scripts ? Alternatively, where can I get a set of script samples for mirroring setup ?

    Thanks.

  • I cannot guarantee that the code is correct but here is the link.

    http://www.sqlservercentral.com/scripts/Disaster+Recovery/66265/

    It is for 2005 but it should work on sql 2008.

    If you search the sqlservercentral site, you should be able to find more mirroring info, if these scripts are not suitable.

    Good Luck

    ~Silverfox~

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply