Post reply

Log shipping info tables

  • August 28, 2006 at 1:54 pm

    #114228

    Hi

    There is logshipping congigured on a couple of servers. There is logshipping monitor thru which I can get the log shipping details.

    But I want to work with system tables in msdb which carry information of logshipping such as last file backed up, copied,..load delta,..alert threshold,..log shipping schedule.

     

    thanks

    Harris/

     

  • August 31, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • September 1, 2006 at 12:26 pm

    #658119

    For sql 2005:

    log_shipping_monitor_alert (Transact-SQL)

    Stores alert job IDs for log shipping.

    log_shipping_monitor_error_detail (Transact-SQL)

    Stores error detail for log shipping jobs.

    log_shipping_monitor_history_detail (Transact-SQL)

    Stores history details for log shipping jobs.

    log_shipping_monitor_primary (Transact-SQL)

    Stores one monitor record per primary database in each log shipping configuration.

    log_shipping_monitor_secondary (Transact-SQL)

    Stores one monitor record per secondary database in a log shipping configuration.

    log_shipping_primary_databases (Transact-SQL)

    Stores one record for the primary database in a log shipping configuration.

    log_shipping_primary_secondaries (Transact-SQL)

    Maps each primary database to its secondary databases. This

    log_shipping_secondary (Transact-SQL)

    Stores one record per secondary ID.

    log_shipping_secondary_databases (Transact-SQL)

    Stores one record per secondary database in a log shipping configuration.

    Hope this helps...Michelle

  • September 1, 2006 at 12:30 pm

    #658121

    Here is the link...

    http://msdn2.microsoft.com/en-us/library/ms175106.aspx

    ...Michelle

  • September 1, 2006 at 8:32 pm

    #658158

    Thanks Michel.

    But im working with SQL Server 2000 Enterprise Edition.

    Harris.

  • September 6, 2006 at 12:23 pm

    #658847

    Sorry, your message is posted in the SQL 2005 forum so I ASSUMED you were on that version ...

    This may be helpful...

    Where does SQL Server 2000 store log shipping information? A total of seven log shipping tables reside in the msdb database in SQL Server 2000 Enterprise and Developer editions:

    •

    log_shipping_plans

    •

    log_shipping_plan_databases

    •

    log_shipping_databases

    •

    log_shipping_plan_history

    •

    log_shipping_monitor

    •

    log_shipping_primaries

    •

    log_shipping_secondaries

    Each of these tables exists on the primary, secondary, and monitor servers. Each server uses only some of the tables to store data, depending on the role the server plays in log shipping.

    Regards,

    Michelle.

Viewing 6 posts - 1 through 5 (of 5 total)

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