Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Alert! Alert! Backup and Restore Baby! Expand / Collapse
Author
Message
Posted Sunday, December 28, 2003 12:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 06, 2007 4:24 AM
Points: 5, Visits: 1
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/jkadlec/alertalertbackupandrestorebaby.asp


Post #19588
Posted Friday, January 02, 2004 8:17 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, September 28, 2012 6:13 AM
Points: 380, Visits: 52
15CriticalBackupRestoreAlerts.sql I'm not finding a way to access this script.

Once these alerts are generated, how do you get notified? Do the DBAs read the error logs or get pages, etc?

Thanks,
Michelle





Michelle
Post #92855
Posted Friday, January 02, 2004 9:41 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 06, 2007 4:24 AM
Points: 5, Visits: 1
Michelle,

I will talk to someone at SQLServerCentral.com about the script. So look for it in the next few days. Sorry about that.

The Alerts would be setup in conjunction with Operators. This is a topic unto itself. In the 'SQL Server Agent Core Components' section I referenced a number of SQL Server Books Online articles that I think will answer your question. The primary article would be SQL Server Agent Service.

Please let me know if this answers your question.

Thank you,
Jeremy Kadlec
jeremyk@edgewoodsolutions.com
www.edgewoodsolutions.com





Post #92856
Posted Thursday, January 08, 2004 5:12 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, March 08, 2005 7:22 PM
Points: 337, Visits: 1

I've had this problem , where I would forget checking when transaction log backup ran last. I would check for failure of the job, but some one would have disabled the Xaction log backup for some reason and would have never turned it back. I finally wrote a script to send me alert if the Xaction Log backup had not run for more than 15min (Thats how often it is supposed to run). Here is the script hope this is useful

 

Declare @i_CurDate int,
 @i_CurTime int,
 @i_MaxDt int,
 @i_MaxTime int

--Get Last Run Date time of Xaction Log Backup
select @i_MaxDt = max(run_Date),
 @i_MaxTime = max(run_time)
 from sysjobhistory where job_id in (
select job_id from sysjobs where name ='BACKUPNAME')
and run_status=1

--Convert Current Date and Time to Int format
select @i_CurDate = Cast(convert(Char(20),getdate() ,112) as int)

select @i_CurTime =(Cast(left(convert(varchar(10),getdate() ,108),2) as int)* 100 +
 Cast(substring(convert(varchar(10),getdate() ,108),4,2) as int)
  *100 + Cast(right(convert(varchar(10),getdate() ,108),2) as int)

--If Difference between Last Run and Current Time > 1500(15 minutes), Then Notify
If (@i_CurDate-@i_MaxDt) + (@i_CurTime-@i_MaxTime) > 1500
Begin
 Exec master..xp_sendmail @recipients = 'recipients' ,@message = 'Check XXX Transaction Log backup', @subject = 'Check XXX Transaction Log backup',@no_output = 'TRUE'
End
 

 

Thanks

Sreejith




Post #94248
Posted Tuesday, January 13, 2004 8:23 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 26, 2004 7:53 AM
Points: 2, Visits: 1

Hi Guys:

Backups and Disaster Recovery are key ingredients to any business. Costs do a play part, but i think the costs of a disaster far outweigh the cost of the solution. Over the years, I have tried many solutions, but most have failed their tests on providing a seamless backup or restore with compression and encryption technology that delivers. I want to sleep at nite!!!!

Then I was introduced at a managed online service from www.evault.com... What a shocker!!! This service works seamlessly with all alerts received by mail..No need to tinker with backups anymore, it works seamlessly and it stores your data in their data centers securely, and it restores without any issues..

Aha!!! most DBAs or IT heads will say i want to own the process, but why do you do that when a managed service provides all the benefits of disk based backup through a subscription, and the technology works..Let the experts do the work!!!!

I am avid user of Evault, take me up on this, I guarantee you, you will never want to change to any other solution...

Thanks,

Bhavesh

 




Post #94863
Posted Tuesday, October 18, 2005 6:55 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 23, 2006 3:25 PM
Points: 4, Visits: 1

the link to 15CriticalBackupRestoreAlerts.sql script is still not working.  Any ideas where this can be obtained from?  Cheers.

Post #229964
Posted Thursday, May 06, 2010 12:35 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, August 21, 2013 8:21 AM
Points: 12, Visits: 138
The link is still dead and probably so is this thread. SSC fail :-(
Post #917304
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse