SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Backup Scenarios for successful SQL Server Restores and Recovery


Backup Scenarios for successful SQL Server Restores and Recovery

Author
Message
vsrinivasan
vsrinivasan
SSC-Enthusiastic
SSC-Enthusiastic (133 reputation)SSC-Enthusiastic (133 reputation)SSC-Enthusiastic (133 reputation)SSC-Enthusiastic (133 reputation)SSC-Enthusiastic (133 reputation)SSC-Enthusiastic (133 reputation)SSC-Enthusiastic (133 reputation)SSC-Enthusiastic (133 reputation)

Group: General Forum Members
Points: 133 Visits: 1
Comments posted to this topic are about the content posted at http://www.sqlserver



Dinesh Asanka
Dinesh Asanka
SSCrazy
SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)

Group: General Forum Members
Points: 2594 Visits: 223

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/
Dinesh Asanka
Dinesh Asanka
SSCrazy
SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)

Group: General Forum Members
Points: 2594 Visits: 223

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/
Yelena Varshal
Yelena Varshal
SSCrazy Eights
SSCrazy Eights (8.7K reputation)SSCrazy Eights (8.7K reputation)SSCrazy Eights (8.7K reputation)SSCrazy Eights (8.7K reputation)SSCrazy Eights (8.7K reputation)SSCrazy Eights (8.7K reputation)SSCrazy Eights (8.7K reputation)SSCrazy Eights (8.7K reputation)

Group: General Forum Members
Points: 8686 Visits: 600

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

Yelena Varshal
Yelena Varshal
SSCrazy Eights
SSCrazy Eights (8.7K reputation)SSCrazy Eights (8.7K reputation)SSCrazy Eights (8.7K reputation)SSCrazy Eights (8.7K reputation)SSCrazy Eights (8.7K reputation)SSCrazy Eights (8.7K reputation)SSCrazy Eights (8.7K reputation)SSCrazy Eights (8.7K reputation)

Group: General Forum Members
Points: 8686 Visits: 600
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

saby
saby
SSC-Addicted
SSC-Addicted (487 reputation)SSC-Addicted (487 reputation)SSC-Addicted (487 reputation)SSC-Addicted (487 reputation)SSC-Addicted (487 reputation)SSC-Addicted (487 reputation)SSC-Addicted (487 reputation)SSC-Addicted (487 reputation)

Group: General Forum Members
Points: 487 Visits: 277
Not much great artical as far as experience is con....
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search