Viewing 14 posts - 16 through 29 (of 29 total)
Just send a Test Email through the Database Mail Profile which you have created and see if the test email lands in your MailBox.
Please let me know the O/P.
With Thanks,
Satnam
January 22, 2015 at 1:12 am
In fact I would advice you that if you are testing this on your test environment then disable either the Backup, Copy or Restore Job, then wait for 20 minutes,...
January 22, 2015 at 1:00 am
You shall receive the email only if the LogShipping Backup, Copy and Restore job is out of sync, in the code which I have submitted to you the threshold is...
January 22, 2015 at 12:54 am
You shall receive the email only if the LogShipping Backup, Copy and Restore job is out of sync, in the code which I have submitted to you the threshold is...
January 22, 2015 at 12:53 am
You will need to use the alter procedure dbo.sendlogshippingalertmessages
instead of
create procedure dbo.sendlogshippingalertmessages
Kindly try this out and do let me know the output.
With Thanks,
Satnam
January 22, 2015 at 12:20 am
create procedure dbo.sendlogshippingalertmessages
as
begin
SET NOCOUNT ON
declare @database_name varchar(100)
declare @time_since_last_backup int
declare @last_backup_file varchar(1000)
declare @time_since_last_copy int
declare @last_copied_file varchar(1000)
declare @time_since_last_restore int
declare @last_restored_file varchar(1000)
declare @server VARCHAR(100)
declare @i INT
declare @j-2 INT
declare @k...
January 21, 2015 at 8:53 pm
I have tested it thoroughly across our infrastructure and it really sends the alert emails very well.
I believe that your problem statement is different than mines.
Cheers,
Satnam
January 21, 2015 at 7:50 pm
Please refer the below.
http://www.sql-server-performance.com/2012/automating-sql-server-transactional-log-shipping-alerts/
With Thanks,
Satnam
January 21, 2015 at 6:48 pm
Why do you need Triggers on the Subscriber database. It can cause Violation of Primary Key constraint error message while replicating the Data and the Replication procedure can halt.
With Thanks,
Satnam
December 18, 2014 at 1:07 am
Recently when I was on a visit to the USA one of my customers mentioned the same problem. After a thorough investigation, it was noticed that the N/W through which...
December 17, 2014 at 4:15 am
Sometimes it happens that when you select a particular Backup File to Restore, you need to Select File Type as All Files in the Drop Down. I hope that works...
December 17, 2014 at 4:11 am
You can try this,
http://www.sql-server-performance.com/2014/dml-triggers-multiple-triggers/
With Thanks,
Satnam
December 17, 2014 at 4:08 am
The customer is a fortune 5 company in the US, IT budget itself is a 100 million + USD per year and therefore the number of instances is pretty high.
With...
November 5, 2014 at 9:18 am
Viewing 14 posts - 16 through 29 (of 29 total)