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

Backup Scenarios for successful SQL Server Restores and Recovery Expand / Collapse
Author
Message
Posted Friday, June 25, 2004 3:54 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, June 28, 2006 10:13 AM
Points: 21, Visits: 1
Comments posted to this topic are about the content posted at http://www.sqlserver


Post #123119
Posted Wednesday, June 30, 2004 2:31 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 2:48 AM
Points: 912, Visits: 210

Good one!!!

I have a concern,

How can we check the backups.

Is there any tools available Or do we have to text them manually








My Blog: http://dineshasanka.spaces.live.com/
Post #123800
Posted Wednesday, June 30, 2004 2:31 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 2:48 AM
Points: 912, Visits: 210

Good one!!!

I have a concern,

How can we check the backups.

Is there any tools available Or do we have to text them manually








My Blog: http://dineshasanka.spaces.live.com/
Post #123801
Posted Thursday, July 1, 2004 11:31 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, September 29, 2014 2:44 PM
Points: 3,475, Visits: 583

Hello All,

I have a simple script that queries MSDB database sysjobs and sysjobhistory from a simple ASP page. Remove the appropriate quotes if you run it from query analyzer

strSQL = "select " & _
       " job_name = Substring(sj.name,1,20)," & _
   " step_name = Substring (' '+sjh.step_name,1,30)," & _
          " sjh.run_status," & _
          " sjh.run_date," & _
          " sjh.run_time," & _
          " sjh.run_duration" & _
  " from msdb.dbo.sysjobhistory sjh, msdb.dbo.sysjobs sj" & _
  " WHERE  (sj.job_id = sjh.job_id)" & _
 " and run_date >convert (int,(convert (char(8),getdate()-3,112)))" & _
 " ORDER BY run_date desc,run_time desc"

My script connects in a loop to my several servers and gives me a table of job completions in my browser. You may write a simple VB script that does the same and schedule it. You can also use FileSystemObject to check what date and time the files in the backup directory are and alert you using email if the dates are incorrect.




Regards,
Yelena Varshal

Post #124311
Posted Thursday, July 1, 2004 11:40 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, September 29, 2014 2:44 PM
Points: 3,475, Visits: 583
I have another comment on this article. It is very important where you put your backups to. You may backup transaction log every 15 min but your server is backed up to tape once a day. Here you go. The standard advice is to put a backup on the separate physical drive (not a different partition, but different physical drive or array). Good advice. Exceptions: I personally had a case when both (2 ) RAID 5 arrays failed at the same time. Another scenario when you really have 1 physical array. My strategy in this case is to create a second (or next) step to the job to copy backups to a network location rigth after they are completed. I use just regular Copy command OR you can use you server scheduler to do that.


Regards,
Yelena Varshal

Post #124315
Posted Tuesday, April 6, 2010 12:38 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, February 11, 2011 8:31 PM
Points: 297, Visits: 277
Not much great artical as far as experience is con....
Post #897340
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse