October 25, 2011 at 8:30 am
Hi Friends,
I need you idea for setting up alrets:hehe: for Logshipping, If Last restore does not happened from last 5 hours i am not receiving alert, I need some solutions on this? Can any one help on this . we need to setup a alert job to monitor the restoring backs ups on secondary server. If possible can you please send the script for creating the job?
October 25, 2011 at 8:50 am
when you configure log shipping the alert jobs are created for you.
Please post the full results of the following executed against your secondary instance
sp_help_log_shipping_monitor_secondary
@secondary_server = 'secondary_server',
@secondary_database = 'secondary_database'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 25, 2011 at 10:32 am
Hi Perry,
i excucted on Master DB and did not get any values in tables, there are no values in tables.
so what to do next?
October 28, 2011 at 7:54 am
Hi Perry,
Any Suggestion from your side? i sent the reply. I excuted the script you had given and it dint given any data, Just empty columns.
Thnaks,
Maddy.
November 4, 2011 at 12:03 am
You need to create an operator & alert for configuring alert job.so that you can recieve a mail when your log shipping will get out of sync.
for more clarification please follow the link:
http://www.ideaexcursion.com/2009/01/05/configuring-sql-server-agent-operators/
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply