Mirroring

Question

Mirroring

prem.balu

SSC Enthusiast

Points: 152
More actions
July 13, 2014 at 12:24 am

#309069

Hi experts,
what are the commonly used system tables for mirroring

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

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

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

MikaS Ten Centuries Points: 1210 More actions · Answer 2

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]

Mike Good SSCertifiable Points: 7415 More actions · Answer 3

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.