Log Shipping - Monitor Server

Question

Post reply

Log Shipping - Monitor Server

Raghavendra Mudugal

SSChampion

Points: 10658
More actions
December 4, 2012 at 9:06 pm

#267784

Comments posted to this topic are about the item Log Shipping - Monitor Server
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
December 5, 2012 at 12:54 am

This was removed by the editor as SPAM

Viewing 11 posts - 1 through 10 (of 10 total)

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

Lokesh Vij SSChampion Points: 10836 More actions · Answer 1

Nice question Raghu! Thanks for posting 🙂

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com[/url]

Follow me @Twitter

Jan Van der Eecken SSCrazy Eights Points: 9029 More actions · Answer 2

Maybe I should have read the question properly? I knew you can configure the monitor server to record the status and historic information about log shipping jobs. But that's not what the question was. It says CANNOT monitor.

Wondering how many more people will make that mistake. 😎

--------------------------------------------------------------------------
A little knowledge is a dangerous thing (Alexander Pope)
In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 3

Nice easy question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

TomThomson SSC Guru Points: 104773 More actions · Answer 4

TomThomson

SSC Guru

Points: 104773

December 5, 2012 at 1:03 am

#1565593

interesting question.

Tom

DugyC Hall of Fame Points: 3804 More actions · Answer 5

Jan Van der Eecken (12/4/2012)
Maybe I should have read the question properly? I knew you can configure the monitor server to record the status and historic information about log shipping jobs. But that's not what the question was. It says CANNOT monitor.
Wondering how many more people will make that mistake. 😎

+1

Bak 2 Skool for me, learn to read again :doze:

_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]

SanDroid SSChampion Points: 10068 More actions · Answer 6

Nice easy question. Good to note this about log shipping:

"To monitor a log shipping configuration, you must add the monitor server when you enable log shipping. If you add a monitor server later, you must remove the log shipping configuration and then replace it with a new configuration that includes a monitor server. "

I am sure this is what the question author was thinking about when he wrote the question.

😎

lptech Hall of Fame Points: 3208 More actions · Answer 7

Here is a link of how to add monitoring after the fact:

http://www.mssqltips.com/sqlservertip/2799/steps-to-add-log-shipping-monitor-into-an-existing-sql-server/

Ken SSCoach Points: 17191 More actions · Answer 8

Nice question. Yet another topic for me to read up on.

(Bob Brown) SSCrazy Points: 2705 More actions · Answer 9

(Bob Brown)

SSCrazy

Points: 2705

December 6, 2012 at 4:08 am

#1566082

Thanks for the question.