locked
Mirroring & logshipping tables RRS feed

  • Question

  • Hello ,

    Can any one of the forum users provide me with the list of tables used to query the logshipping and mirroring .

    DEST 
    Friday, December 4, 2009 1:03 AM

Answers

  • Hi

    Long back saved these information check this it might be useful  . For the description and details of each table please refer BOL .

     

    Primary 

     

    select * from msdb..log_shipping_databases

    select * from msdb..log_shipping_monitor

     

    secondary 

    select * from msdb..log_shipping_plan_databases

    select * from msdb..log_shipping_plan_history

    select * from msdb..log_shipping_plans

    select * from msdb..log_shipping_monitor

    select * from msdb..log_shipping_plan_history where source_database='servername' order by end_time desc

    select * from msdb..log_shipping_primaries

    select * from msdb..log_shipping_primaries where primary_server_name='server name'

    select * from msdb..log_shipping_secondaries

    select * from msdb..logshipping_config

    select * from msdb..logshipping_audit

     

    Logshipping tables for Yukon

    select * from msdb..log_shipping_monitor_alert 

    select * from msdb..log_shipping_monitor_error_detail

    select * from msdb..log_shipping_monitor_history_detail order by log_time desc

    select * from msdb..log_shipping_primaries

    select * from msdb..log_shipping_primary_databases

    select * from msdb..log_shipping_primary_secondaries

    select * from msdb..log_shipping_secondaries

    select * from msdb..log_shipping_secondary

    select * from msdb..log_shipping_secondary_databases

     select * from msdb..restorehistory order by restore_date desc

     

    Mirroring :
    Please go through the following URL :
    http://syntaxhelp.com/sqlserver/mirroring “Handy”

    -----
    Thanks,Suhas V

    • Marked as answer by DestT Monday, December 7, 2009 5:42 AM
    Friday, December 4, 2009 8:10 AM
  • Refer the following too  :

    http://msdn.microsoft.com/en-us/library/ms175106.aspx  " Log Shipping Tables and Stored Procedures"
    http://msdn.microsoft.com/en-us/library/ms180076.aspx " Endpoints catalog views "

    -----------
    Thanks,Suhas V

    • Marked as answer by DestT Monday, December 7, 2009 5:42 AM
    Saturday, December 5, 2009 4:55 AM

All replies

  • Log shipping tables - http://technet.microsoft.com/en-us/library/ms190355.aspx

    DATABASE MIRRORING:

    select * from sys.database_mirroring

    select * from sys.database_mirroring_endpoints

    select * from sys.database_mirroring_witnesses

    select * from sys.dm_db_mirroring_connections

     

     


    Thanks, Leks

    Friday, December 4, 2009 1:26 AM
    Answerer
  • Hi

    Long back saved these information check this it might be useful  . For the description and details of each table please refer BOL .

     

    Primary 

     

    select * from msdb..log_shipping_databases

    select * from msdb..log_shipping_monitor

     

    secondary 

    select * from msdb..log_shipping_plan_databases

    select * from msdb..log_shipping_plan_history

    select * from msdb..log_shipping_plans

    select * from msdb..log_shipping_monitor

    select * from msdb..log_shipping_plan_history where source_database='servername' order by end_time desc

    select * from msdb..log_shipping_primaries

    select * from msdb..log_shipping_primaries where primary_server_name='server name'

    select * from msdb..log_shipping_secondaries

    select * from msdb..logshipping_config

    select * from msdb..logshipping_audit

     

    Logshipping tables for Yukon

    select * from msdb..log_shipping_monitor_alert 

    select * from msdb..log_shipping_monitor_error_detail

    select * from msdb..log_shipping_monitor_history_detail order by log_time desc

    select * from msdb..log_shipping_primaries

    select * from msdb..log_shipping_primary_databases

    select * from msdb..log_shipping_primary_secondaries

    select * from msdb..log_shipping_secondaries

    select * from msdb..log_shipping_secondary

    select * from msdb..log_shipping_secondary_databases

     select * from msdb..restorehistory order by restore_date desc

     

    Mirroring :
    Please go through the following URL :
    http://syntaxhelp.com/sqlserver/mirroring “Handy”

    -----
    Thanks,Suhas V

    • Marked as answer by DestT Monday, December 7, 2009 5:42 AM
    Friday, December 4, 2009 8:10 AM
  • Refer the following too  :

    http://msdn.microsoft.com/en-us/library/ms175106.aspx  " Log Shipping Tables and Stored Procedures"
    http://msdn.microsoft.com/en-us/library/ms180076.aspx " Endpoints catalog views "

    -----------
    Thanks,Suhas V

    • Marked as answer by DestT Monday, December 7, 2009 5:42 AM
    Saturday, December 5, 2009 4:55 AM
  • Refer the following too :

    http://msdn.microsoft.com/en-us/library/ms175106.aspx " Log Shipping Tables and Stored Procedures"
    http://msdn.microsoft.com/en-us/library/ms180076.aspx " Endpoints catalog views "

    -----------
    Thanks,Suhas V


    It's very useful, What you shared helps me understand it.
    Thursday, January 20, 2011 2:40 AM