• prem.balu (7/13/2014)


    Hi experts,

    what are the commonly used system tables for mirroring

    Hi,

    If you're looking for the tables that hold information about the status of mirroring, there are few in the MSDB database. I don't have access to instance with mirroring set up so I cannot check what they are. If I remember correctly they're undocumented and created only when you set up the mirroring, so look at the creation dates of your tables in the MSDB.

    Mika Sutinen, Senior DBA
    @SQLFinn on Twitter
    Blogging at SQLStarters[/url]