Log Shipping Monitor - 2005

Is the "Log Shipping Monitor" that was avaialable in SQL Server 2000
Enterprise Manager still available with SQL Server 2005. I installed Log
Shipping on a 2005 server and selected the monitor option but I can not find
the nice Log Shipping monitor that give you status on log shipping. I also
searched through the Books Online documentation and several online resources
and I have not found a definitive answer.
Please help.
Thanks!
Chris
Hi Chris
"Cgal" wrote:

> Is the "Log Shipping Monitor" that was avaialable in SQL Server 2000
> Enterprise Manager still available with SQL Server 2005. I installed Log
> Shipping on a 2005 server and selected the monitor option but I can not find
> the nice Log Shipping monitor that give you status on log shipping. I also
> searched through the Books Online documentation and several online resources
> and I have not found a definitive answer.
> Please help.
> Thanks!
> Chris
In SQLServer 2005 there is a standard report called "Transaction Log
Shipping Status" that gives you the current status.
http://msdn2.microsoft.com/en-us/library/ms181149.aspx (steps 1-4) currently
gives information on how to show the report prior to SP2. You will need to
show the Object Explorer tab (view menu and select Object Explorer detals) to
get the reports button (on the tab's toolbar). The list of reports are
sensitive to the context which you have selected in the object explorer (F8)
so if you don't see this report you are probably not on the node for the
instance.
After SP2 you can right click the node for the instance and select
Reports/Standard Reports/Transaction Log Shipping Status
HTH
john
|||John,
Thanks for the quick response.
I knew about the report that you referenced but I was hoping that there was
more. The report has no where near the functionality and usability of the
"Log Shipping Monitor" that came with SQL Server 2000.
Please let me know if there are any other tools for monitoring Log Shipping
beyond the report.
Thanks!
Chris
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:9C6B2961-67CB-4B3A-A822-C73899577EBD@.microsoft.com...
> Hi Chris
> "Cgal" wrote:
>
> In SQLServer 2005 there is a standard report called "Transaction Log
> Shipping Status" that gives you the current status.
> http://msdn2.microsoft.com/en-us/library/ms181149.aspx (steps 1-4)
> currently
> gives information on how to show the report prior to SP2. You will need to
> show the Object Explorer tab (view menu and select Object Explorer detals)
> to
> get the reports button (on the tab's toolbar). The list of reports are
> sensitive to the context which you have selected in the object explorer
> (F8)
> so if you don't see this report you are probably not on the node for the
> instance.
> After SP2 you can right click the node for the instance and select
> Reports/Standard Reports/Transaction Log Shipping Status
> HTH
> john
|||Hi, Chris,
I guess that you would like to add a monitor server in your log shipping
environment.
If I have misunderstood, please let me know.
In SQL Server 2005, to monitor log shipping configuration, adding the
monitor server is required. If you do not have a monitor server, you may
need to manually run the system procedures such as
sp_help_log_shipping_primary_database,
sp_help_log_shipping_primary_secondary,
sp_help_log_shipping_secondary_database, and
sp_help_log_shipping_secondary_primary etc to query the status of your log
shipping.
For more detailed information, you can refer to this article:
How to: Enable Log Shipping (SQL Server Management Studio)
http://msdn2.microsoft.com/en-us/library/ms190640.aspx
Understanding Log Shipping
http://msdn2.microsoft.com/en-us/library/ms187103.aspx
Monitoring Log Shipping
http://msdn2.microsoft.com/en-us/library/ms190224.aspx
Hope this helps. If you have any other questions or concerns, please feel
free to let me know. It is my pleasure to be of assistance.
Best regards,
Charles Wang
Microsoft Online Community Support
================================================== ===
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
|||Hi, Chris
Just check with you to see if the suggestions were helpful. Please let us
know if you would like further assistance.
Have a great day!
Charles Wang
Microsoft Online Partner Support
PLEASE NOTE: The partner managed newsgroups are provided
to assist with break/fix issues and simple how to questions.
We also love to hear your product feedback!
Let us know what you think by posting
- from the web interface: Partner Feedback
- from your newsreader:
microsoft.private.directaccess.partnerfeedback.
We look forward to hearing from you!
================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====