Database Mirroring

  • Abi Chapagai

    SSCrazy

    Points: 2666

    Comments posted to this topic are about the item Database Mirroring

  • Ron McCullough

    SSC Guru

    Points: 63877

    A very good, clear, concise question.

    Found out I knew something.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • Koen Verbeeck

    SSC Guru

    Points: 258941

    Nice question, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • UMG Developer

    SSChampion

    Points: 13482

    Thanks for the question, it is always good to research and learn something new!

  • Gobikannan

    SSCrazy

    Points: 2735

    Good question with clear history...

    -----------------
    Gobikannan

  • tejaswini.patil

    SSCommitted

    Points: 1782

    Thanks for the question. It was a learning for me. 🙂

  • SanDroid

    SSChampion

    Points: 10068

    Good question. If you know a little bit about the system, catalog, and DMV's on SQL server the answer was easy.

    Looking at the answers given, I think several people don't know the differance between the Catalog View's and DMV's.

    The Following are SQL Databases and Files Catalog Views:

    sys.database_mirroring

    sys.backup_devices

    sys.database_files

    sys.databases

    sys.database_recovery_status

    sys.masterfile

    There is a full listing of Catalog Views here:

    http://msdn.microsoft.com/en-us/library/ms174365.aspx

    Dynamic Management Views here:

    http://msdn.microsoft.com/en-us/library/ms188754.aspx

    Full listing of system tables by topic is here:

    http://msdn.microsoft.com/en-us/library/ms179932.aspx

    Have fun! 😎

  • SQLRNNR

    SSC Guru

    Points: 281210

    Thanks for the question.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • M&M

    SSC-Insane

    Points: 21679

    Good question. Thank you:-)

    M&M

  • scottm30

    Ten Centuries

    Points: 1094

    Nice question, thanks.

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

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