<a href="//g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="//g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
Daily SQL Articles by email:
Sign up
<a href="//g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="//g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQLServerCentral.com
»
Editorials
»
The Backup Process
The Backup Process
Rate Topic
Display Mode
Topic Options
Author
Message
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Sunday, March 17, 2013 4:25 AM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 3:31 PM
Points: 34,183,
Visits: 18,334
Comments posted to this topic are about the item
The Backup Process
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #1431970
Jeff Moden
Jeff Moden
Posted Sunday, March 17, 2013 3:32 PM
SSC-Forever
Group: General Forum Members
Last Login: Monday, September 26, 2016 3:35 PM
Points: 41,436,
Visits: 38,770
I actually do a restore from prod to UAT every night for two purposes. 1) Test the backup and 2) Keep the UAT database up to snuff. Yes... if they have any new objects that aren't in prod, they'll be blown away so there's actually a 3rd reason... test and retest the code/object promotio scripts.
--Jeff Moden
"
RBAR
is pronounced "ree-bar" and is a "Modenism" for "
R
ow-
B
y-
A
gonizing-
R
ow".
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."
Helpful Links:
How to post code problems
How to post performance problems
Post #1432032
Miles Neale
Miles Neale
Posted Monday, March 18, 2013 12:27 PM
SSCrazy
Group: General Forum Members
Last Login: Tuesday, January 26, 2016 9:10 AM
Points: 2,602,
Visits: 1,694
"However even if you automate restores of all your databases, make sure you still practice your manual skills regularly. Automation might not work in a disaster situation.. "
Excellent advice, we have had to restore under fire and having the knowledge ready and not having to do a complete refresh of the process or have someone relearn it due to unfamiliarity saves a lot of time.
Not all gray hairs are Dinosaurs!
Post #1432305
John Hanrahan
John Hanrahan
Posted Monday, March 18, 2013 3:00 PM
SSChasing Mays
Group: General Forum Members
Last Login: Today @ 4:33 PM
Points: 655,
Visits: 1,429
I restore and test at least monthly. I just can't imagine how ugly it would be if something happened and I was unprepared.
Post #1432354
TravisDBA
TravisDBA
Posted Tuesday, March 19, 2013 7:20 AM
Ten Centuries
Group: General Forum Members
Last Login: Tuesday, September 16, 2014 2:03 PM
Points: 1,334,
Visits: 3,069
Restores are pointless if you are not even doing your backups properly. I have gone into many shops in the past where they weren't even backing up their databases properly. If you saw the shape some IT shops out there are in nowadays it would amaze you how they are still in business.
"Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ...
"
Post #1432634
Miles Neale
Miles Neale
Posted Tuesday, March 19, 2013 9:45 AM
SSCrazy
Group: General Forum Members
Last Login: Tuesday, January 26, 2016 9:10 AM
Points: 2,602,
Visits: 1,694
TravisDBA (3/19/2013)
Restores are pointless if you are not even doing your backups properly. I have gone into many shops in the past where they weren't even backing up their databases properly. If you saw the shape some IT shops out there are in nowadays it would amaze you how they are still in business.
Point well taken. Who wants to move from a failed system or a corrupted database to a corrupt backup or to have to start over? You cannot really do either. So without a viable backup the successful options look like the case of "slim or none".
Not all gray hairs are Dinosaurs!
Post #1432747
TravisDBA
TravisDBA
Posted Tuesday, March 19, 2013 11:10 AM
Ten Centuries
Group: General Forum Members
Last Login: Tuesday, September 16, 2014 2:03 PM
Points: 1,334,
Visits: 3,069
Once awhile back working at an advertising company when I noticed that a crucial production advertising database had not been backed up since it was created for almost a year!!! When I asked the IT manager and acting DBA why this was, his response was "Well...we never got around to it, we meant to though.." I just shook my head in incredulous disbelief, but the fact of matter is this kind of buffoonery is much more common than you might think out there in this industry today. There are far to many people in this business that have absolutely no business being in this business in the first place. They should be working in a flower shop IMHO.
"Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ...
"
Post #1432791
Steve JP
Steve JP
Posted Thursday, March 21, 2013 6:46 AM
Valued Member
Group: General Forum Members
Last Login: Saturday, November 28, 2015 7:06 AM
Points: 55,
Visits: 328
I know of one place that does backup to the USB drive, yet they have 2 SANs?!
During a DR test the admin guys were too rushed to do a full restore and the BOLs were forgotton and there was no internet access. I was lucky as I could still sort out the issues but it did make me more cautious about having a crib sheet.
Post #1433756
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2016 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
