I have few questions?
1. Can I implement log shipping into two systems which has
a SQL Server Enterprise Manager.
2. We can installed monitoring server on the standby or
have to need the separate server.
Thanks
David
Yes, you can setup Log Shipping between two SQL Servers.
Here is some info:
314515 INF: Frequently Asked Questions - SQL Server 2000 - Log Shipping
http://support.microsoft.com/?id=314515
323135 INF: Microsoft SQL Server 2000 - How to Set Up Log Shipping (White
Paper)
http://support.microsoft.com/?id=323135
325220 Support WebCast: Microsoft SQL Server 2000 Log Shipping
http://support.microsoft.com/?id=325220
821786 Support WebCast: Microsoft SQL Server 2000: Using Log Shipping
http://support.microsoft.com/?id=821786
321247 HOW TO: Configure Security for Log Shipping
http://support.microsoft.com/?id=321247
329133 INF: Troubleshooting SQL Server 2000 Log Shipping "Out of Sync"
Errors
http://support.microsoft.com/?id=329133
I did not understand the second question.
Keith
"David" <anonymous@.discussions.microsoft.com> wrote in message
news:089c01c50314$f10bd180$a601280a@.phx.gbl...
> I have few questions?
> 1. Can I implement log shipping into two systems which has
> a SQL Server Enterprise Manager.
> 2. We can installed monitoring server on the standby or
> have to need the separate server.
> Thanks
>
> David
Showing posts with label shipping. Show all posts
Showing posts with label shipping. Show all posts
Wednesday, March 7, 2012
monitor Log Shipping
we are using sql server 2000 Log Shipping .Pl help me , tell me about how to
monitor Log Shipping and what are diffrent counters (performance and other )
Ritesh,
The best way to monitor SQL Server 2000 Enterprise Edition log shipping is
to use the built-in Log Shipping Monitor. There are no perfmon counters as
such for log shipping. But you can also monitor the SQL Agent jobs that do
the work.
Hope this helps,
Ron
Ron Talmage
SQL Server MVP
"Ritesh Gupta" <RiteshGupta@.discussions.microsoft.com> wrote in message
news:51A9CEB5-E966-4020-8FCC-9DEBF7781737@.microsoft.com...
> we are using sql server 2000 Log Shipping .Pl help me , tell me about how
to
> monitor Log Shipping and what are diffrent counters (performance and
other )
>
|||Hi Ritesh -
Please visit the link and let me know if it's helpful for you.
http://www.sql-server-performance.co...g_shipping.asp
Regards,
Surajit
"Ron Talmage" wrote:
> Ritesh,
> The best way to monitor SQL Server 2000 Enterprise Edition log shipping is
> to use the built-in Log Shipping Monitor. There are no perfmon counters as
> such for log shipping. But you can also monitor the SQL Agent jobs that do
> the work.
> Hope this helps,
> Ron
> --
> Ron Talmage
> SQL Server MVP
> "Ritesh Gupta" <RiteshGupta@.discussions.microsoft.com> wrote in message
> news:51A9CEB5-E966-4020-8FCC-9DEBF7781737@.microsoft.com...
> to
> other )
>
>
monitor Log Shipping and what are diffrent counters (performance and other )
Ritesh,
The best way to monitor SQL Server 2000 Enterprise Edition log shipping is
to use the built-in Log Shipping Monitor. There are no perfmon counters as
such for log shipping. But you can also monitor the SQL Agent jobs that do
the work.
Hope this helps,
Ron
Ron Talmage
SQL Server MVP
"Ritesh Gupta" <RiteshGupta@.discussions.microsoft.com> wrote in message
news:51A9CEB5-E966-4020-8FCC-9DEBF7781737@.microsoft.com...
> we are using sql server 2000 Log Shipping .Pl help me , tell me about how
to
> monitor Log Shipping and what are diffrent counters (performance and
other )
>
|||Hi Ritesh -
Please visit the link and let me know if it's helpful for you.
http://www.sql-server-performance.co...g_shipping.asp
Regards,
Surajit
"Ron Talmage" wrote:
> Ritesh,
> The best way to monitor SQL Server 2000 Enterprise Edition log shipping is
> to use the built-in Log Shipping Monitor. There are no perfmon counters as
> such for log shipping. But you can also monitor the SQL Agent jobs that do
> the work.
> Hope this helps,
> Ron
> --
> Ron Talmage
> SQL Server MVP
> "Ritesh Gupta" <RiteshGupta@.discussions.microsoft.com> wrote in message
> news:51A9CEB5-E966-4020-8FCC-9DEBF7781737@.microsoft.com...
> to
> other )
>
>
monitor Log Shipping
we are using sql server 2000 Log Shipping .Pl help me , tell me about how to
monitor Log Shipping and what are diffrent counters (performance and other )Ritesh,
The best way to monitor SQL Server 2000 Enterprise Edition log shipping is
to use the built-in Log Shipping Monitor. There are no perfmon counters as
such for log shipping. But you can also monitor the SQL Agent jobs that do
the work.
Hope this helps,
Ron
--
Ron Talmage
SQL Server MVP
"Ritesh Gupta" <RiteshGupta@.discussions.microsoft.com> wrote in message
news:51A9CEB5-E966-4020-8FCC-9DEBF7781737@.microsoft.com...
> we are using sql server 2000 Log Shipping .Pl help me , tell me about how
to
> monitor Log Shipping and what are diffrent counters (performance and
other )
>|||Hi Ritesh -
Please visit the link and let me know if it's helpful for you.
http://www.sql-server-performance.com/sql_server_log_shipping.asp
Regards,
Surajit
"Ron Talmage" wrote:
> Ritesh,
> The best way to monitor SQL Server 2000 Enterprise Edition log shipping is
> to use the built-in Log Shipping Monitor. There are no perfmon counters as
> such for log shipping. But you can also monitor the SQL Agent jobs that do
> the work.
> Hope this helps,
> Ron
> --
> Ron Talmage
> SQL Server MVP
> "Ritesh Gupta" <RiteshGupta@.discussions.microsoft.com> wrote in message
> news:51A9CEB5-E966-4020-8FCC-9DEBF7781737@.microsoft.com...
> > we are using sql server 2000 Log Shipping .Pl help me , tell me about how
> to
> > monitor Log Shipping and what are diffrent counters (performance and
> other )
> >
> >
>
>
monitor Log Shipping and what are diffrent counters (performance and other )Ritesh,
The best way to monitor SQL Server 2000 Enterprise Edition log shipping is
to use the built-in Log Shipping Monitor. There are no perfmon counters as
such for log shipping. But you can also monitor the SQL Agent jobs that do
the work.
Hope this helps,
Ron
--
Ron Talmage
SQL Server MVP
"Ritesh Gupta" <RiteshGupta@.discussions.microsoft.com> wrote in message
news:51A9CEB5-E966-4020-8FCC-9DEBF7781737@.microsoft.com...
> we are using sql server 2000 Log Shipping .Pl help me , tell me about how
to
> monitor Log Shipping and what are diffrent counters (performance and
other )
>|||Hi Ritesh -
Please visit the link and let me know if it's helpful for you.
http://www.sql-server-performance.com/sql_server_log_shipping.asp
Regards,
Surajit
"Ron Talmage" wrote:
> Ritesh,
> The best way to monitor SQL Server 2000 Enterprise Edition log shipping is
> to use the built-in Log Shipping Monitor. There are no perfmon counters as
> such for log shipping. But you can also monitor the SQL Agent jobs that do
> the work.
> Hope this helps,
> Ron
> --
> Ron Talmage
> SQL Server MVP
> "Ritesh Gupta" <RiteshGupta@.discussions.microsoft.com> wrote in message
> news:51A9CEB5-E966-4020-8FCC-9DEBF7781737@.microsoft.com...
> > we are using sql server 2000 Log Shipping .Pl help me , tell me about how
> to
> > monitor Log Shipping and what are diffrent counters (performance and
> other )
> >
> >
>
>
monitor Log Shipping
we are using sql server 2000 Log Shipping .Pl help me , tell me about how to
monitor Log Shipping and what are diffrent counters (performance and other
)Ritesh,
The best way to monitor SQL Server 2000 Enterprise Edition log shipping is
to use the built-in Log Shipping Monitor. There are no perfmon counters as
such for log shipping. But you can also monitor the SQL Agent jobs that do
the work.
Hope this helps,
Ron
--
Ron Talmage
SQL Server MVP
"Ritesh Gupta" <RiteshGupta@.discussions.microsoft.com> wrote in message
news:51A9CEB5-E966-4020-8FCC-9DEBF7781737@.microsoft.com...
> we are using sql server 2000 Log Shipping .Pl help me , tell me about how
to
> monitor Log Shipping and what are diffrent counters (performance and
other )
>|||Hi Ritesh -
Please visit the link and let me know if it's helpful for you.
http://www.sql-server-performance.c...og_shipping.asp
Regards,
Surajit
"Ron Talmage" wrote:
> Ritesh,
> The best way to monitor SQL Server 2000 Enterprise Edition log shipping is
> to use the built-in Log Shipping Monitor. There are no perfmon counters as
> such for log shipping. But you can also monitor the SQL Agent jobs that do
> the work.
> Hope this helps,
> Ron
> --
> Ron Talmage
> SQL Server MVP
> "Ritesh Gupta" <RiteshGupta@.discussions.microsoft.com> wrote in message
> news:51A9CEB5-E966-4020-8FCC-9DEBF7781737@.microsoft.com...
> to
> other )
>
>
monitor Log Shipping and what are diffrent counters (performance and other
)Ritesh,
The best way to monitor SQL Server 2000 Enterprise Edition log shipping is
to use the built-in Log Shipping Monitor. There are no perfmon counters as
such for log shipping. But you can also monitor the SQL Agent jobs that do
the work.
Hope this helps,
Ron
--
Ron Talmage
SQL Server MVP
"Ritesh Gupta" <RiteshGupta@.discussions.microsoft.com> wrote in message
news:51A9CEB5-E966-4020-8FCC-9DEBF7781737@.microsoft.com...
> we are using sql server 2000 Log Shipping .Pl help me , tell me about how
to
> monitor Log Shipping and what are diffrent counters (performance and
other )
>|||Hi Ritesh -
Please visit the link and let me know if it's helpful for you.
http://www.sql-server-performance.c...og_shipping.asp
Regards,
Surajit
"Ron Talmage" wrote:
> Ritesh,
> The best way to monitor SQL Server 2000 Enterprise Edition log shipping is
> to use the built-in Log Shipping Monitor. There are no perfmon counters as
> such for log shipping. But you can also monitor the SQL Agent jobs that do
> the work.
> Hope this helps,
> Ron
> --
> Ron Talmage
> SQL Server MVP
> "Ritesh Gupta" <RiteshGupta@.discussions.microsoft.com> wrote in message
> news:51A9CEB5-E966-4020-8FCC-9DEBF7781737@.microsoft.com...
> to
> other )
>
>
Saturday, February 25, 2012
Monitor Database Mirroring
Does database mirroring have any monitoring capabilities like Log shipping
to let the DBAs know the current status of the mirrored server i.e. how far
behind the principal it is,etc. ?See the DMV dm_db_mirroring_connections. See details from below URL:-
http://msdn2.microsoft.com/en-us/library/ms189796.aspx
Also see:-
http://msdn2.microsoft.com/en-us/library/ms365781.aspx
Thanks
Hari
"Hassan" <hassan@.hotmail.com> wrote in message
news:%23IQSavNeHHA.2332@.TK2MSFTNGP04.phx.gbl...
> Does database mirroring have any monitoring capabilities like Log shipping
> to let the DBAs know the current status of the mirrored server i.e. how
> far behind the principal it is,etc. ?
>
to let the DBAs know the current status of the mirrored server i.e. how far
behind the principal it is,etc. ?See the DMV dm_db_mirroring_connections. See details from below URL:-
http://msdn2.microsoft.com/en-us/library/ms189796.aspx
Also see:-
http://msdn2.microsoft.com/en-us/library/ms365781.aspx
Thanks
Hari
"Hassan" <hassan@.hotmail.com> wrote in message
news:%23IQSavNeHHA.2332@.TK2MSFTNGP04.phx.gbl...
> Does database mirroring have any monitoring capabilities like Log shipping
> to let the DBAs know the current status of the mirrored server i.e. how
> far behind the principal it is,etc. ?
>
Subscribe to:
Posts (Atom)