Post reply

System Tables for Database Mirroring

  • August 18, 2014 at 6:18 am

    #397215

    Does anyone know the names of the system tables that contain database mirroring information?

    Google keeps throwing me links on how to create database mirrors and how to do mirror monitoring. I'm just trying to identify the involved system tables that keeps all this information. Can someone help?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • August 18, 2014 at 6:22 am

    #1738820

    Nevermind. Finally found a link with them listed.

    sys.database_mirroring

    sys.database_mirroring_endpoints

    sys.database_mirroring_witnesses

    sys.dm_db_mirroring_connections

    Thanks anyway.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • August 18, 2014 at 6:26 am

    #1738824

    Ah, you beat me to it! I finally knew something, too :-D.

  • August 18, 2014 at 6:29 am

    #1738828

    Beatrix Kiddo (8/18/2014)

    Ah, you beat me to it! I finally knew something, too :-D.

    I appreciate the thought. @=)

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

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