Post reply

Transaction Log Shipping Status Report

  • November 18, 2009 at 4:56 am

    #217756

    Hello,

    does anyone have encountered this while running the Transaction Log Shipping report?

    I am getting a wierd message as "User must be in master database" when I try to run the Transaction Log Shipping report on sql server 2005 standard edition.

    any tips would be appreciated.

    Thanks

    Arshad

  • December 9, 2009 at 3:52 pm

    #1090271

    [bump] I'm getting this too. Don't suppose you found a solution to this did you?

  • December 9, 2009 at 5:05 pm

    #1090284

    i havne't found it yet. let me know if you figure it out.

  • December 10, 2009 at 2:11 am

    #1090410

    Are you guys trying to run the Standard Report from the sql server dashboard or is it some other report?

    To make things easier user the query below for primary

    use msdb

    select * from log_shipping_monitor_primary

    and for secondary user:

    use msdb

    select * from log_shipping_monitor_secondary

    The dashboard is not always the quickest means of tracking log shipping problems.

    Let me know if this helps.

  • December 10, 2009 at 9:50 am

    #1090686

    That worked for me, thanks. I just which I had a better idea as to why the SSMS report doesn't work. Little things like that make me concerned that there could be other, more important things that aren't set up correctly either.

    Anyway thank you for the suggestion SQLBee.

  • December 10, 2009 at 10:16 am

    #1090708

    but it is bit of a pain monitoring log shipping in sql 2005 when compare to 2000.

    however SQL Server 2005 provides you with stored procedures that essentially equate to canned reports to assist you in the monitoring process. All of the stored procedures are located in master:

    • master.sys.sp_help_log_shipping_monitor: This stored procedure is the procedure you would most likely query to get the updated status about what is going on with log shipping. This essentially replaces the graphic monitor functionality that was available in SQL Server 2000. Because this is no longer available in Management Studio as a dialog, you will need to

    understand what this stored procedure is returning as its values.

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

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