Mirroring

  • Hi experts,

    what are the commonly used system tables for mirroring

  • Err, don't understand the question

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • 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]

  • I'm generally a system table king of guy, but for mirroring all I have ever used were sys.databases and sys.database_mirroring. For SQL 2012 AlwaysOn it's a completely different story.

Viewing 4 posts - 1 through 3 (of 3 total)

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