Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Advice in restore and backup check schedule


Advice in restore and backup check schedule

Author
Message
sql-lover
sql-lover
SSChasing Mays
SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)

Group: General Forum Members
Points: 651 Visits: 1930
Ok,

We all know how important to check (and restore) your backup file is, right? ;-) ... so I am trying to follow that good practice without making it an impossible task. (I have hundreds of databases assigned to me, space and time is limited)

So my question would be, or more kind of a poll question, what schedule do you use? Here's what I am trying to implement.

-Weekly check (Sundays): critical clients or anything above 100GB
-Monthly check(Sundays): anything lower than 100GB or any other client.

I am using RedGate 7.0 which allows me, as part as the regular check, do the following:

-Grab backup file from backup repository using Scheduled Restore feature
-Restore database
-Run DBCC
-Delete if everything went fine
-Send email informing

For the Weekly checks, I was planning to start those at 2am, 4am, 6am, and so on. Now, the Monthly checks is what confuses me. I was planning to do that randomly, but how should I schedule those?

Any hints? Rolleyes

By the way, the SQL instance I am using is not a production box. So does not running anything critical. However, I prefer to restore and check weekends, so it will not make it too slow (it's a VMware machine)

Any suggestion is highly appreciated
sql-lover
sql-lover
SSChasing Mays
SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)

Group: General Forum Members
Points: 651 Visits: 1930
BUMP!

wow, no one ? :-( ... I just want to "hear" from other and their current restore / dbcc check strategy,
Neeraj Dwivedi
Neeraj Dwivedi
SSC Eights!
SSC Eights! (887 reputation)SSC Eights! (887 reputation)SSC Eights! (887 reputation)SSC Eights! (887 reputation)SSC Eights! (887 reputation)SSC Eights! (887 reputation)SSC Eights! (887 reputation)SSC Eights! (887 reputation)

Group: General Forum Members
Points: 887 Visits: 1319
I do not have any tools, I use batch scripts and SQL jobs to accomplish this. For our most critical applications, I do restore the backups in the Testing environments every week, to check if backups are fine.

For every others, I do that automatically to but using windows and SQL job scheduling mechanism, so that I must check every DB in six months.

We send email in case of success & alert in case of failure.
sql-lover
sql-lover
SSChasing Mays
SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)

Group: General Forum Members
Points: 651 Visits: 1930
Neeraj Dwivedi (5/6/2013)
I do not have any tools, I use batch scripts and SQL jobs to accomplish this. For our most critical applications, I do restore the backups in the Testing environments every week, to check if backups are fine.

For every others, I do that automatically to but using windows and SQL job scheduling mechanism, so that I must check every DB in six months.

We send email in case of success & alert in case of failure.


Thanks for reply.

I pretty much know what to do with critical ones, and the schedule I need. But not so sure about frequency for non critical ones.

So, just curious ... based on your schedule and amount of non critical databases, how many non critical ones you need to restore weekly (or daily) so you can cover all of them in a six month period?
Neeraj Dwivedi
Neeraj Dwivedi
SSC Eights!
SSC Eights! (887 reputation)SSC Eights! (887 reputation)SSC Eights! (887 reputation)SSC Eights! (887 reputation)SSC Eights! (887 reputation)SSC Eights! (887 reputation)SSC Eights! (887 reputation)SSC Eights! (887 reputation)

Group: General Forum Members
Points: 887 Visits: 1319
Compared to your environment, mine is really small. I have to support close to 50 prod Dbs.
sqlsurfing
sqlsurfing
SSC-Enthusiastic
SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)

Group: General Forum Members
Points: 167 Visits: 1130
I would imagine backup process "really" depends on your organization's requirements.

Backup the database with "Checksum" (Just to be safe using checksum)
Then using a Restore Verify Only
and using DBCC CheckDb are good.

Although those above depends on available maint window, it sounds there is tight time constraint if verification happens elsewhere later?

--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully :-D
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