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


Be Prepared


Be Prepared

Author
Message
JeremyE
JeremyE
SSCertifiable
SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)

Group: General Forum Members
Points: 5701 Visits: 4088
Grant Fritchey (1/4/2010)
umailedit (1/4/2010)
Why should something as routine as backup not be done automatically by computers? Why depend on people to do the backup?


Speak of Murphy and he will appear. Right here is a good example. No backups. Corrupt file. Just the same as flat tire, no spare.



Backups don't save jobs but restores do. Having a corrupt backup is just like having a flat spare tire.
SQLRNNR
SQLRNNR
SSC Guru
SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)

Group: General Forum Members
Points: 63719 Visits: 18570
GilaMonster (1/4/2010)
But why would you need a backup? I mean, it's not as if a disk will fail, or someone drops a table (or the entire database) or the data file gets corrupted or an adimn deletes the mdf accidentally or data modifed yesterday needs to be undone or ... </sarcasm>

I'm almost tired of asking people if they have backups in the 'my database is corrupt'/'I need to recover deleted <something>' forum posts. The answer 99% of the time is no. The best I ever got from someone was "I didn't know I had to take backups"

And don't get me started on the 'took a backup but never tested it and now it won't restore' situation

<sigh>


Should we be testing our backups? Should we ever really need to make sure the spare tire has air in it?


I just had to help somebody change a flat tire the other day - pulled the spare out and it was flat too.Smooooth

I think, on a personal note, I would rather have my spare tire be flat than my backups be corrupt.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw

Ronald Cartmale
Ronald Cartmale
Old Hand
Old Hand (302 reputation)Old Hand (302 reputation)Old Hand (302 reputation)Old Hand (302 reputation)Old Hand (302 reputation)Old Hand (302 reputation)Old Hand (302 reputation)Old Hand (302 reputation)

Group: General Forum Members
Points: 302 Visits: 204
I could not agree more with the editorial and have always sort to ensure that my company’s data is protected by the best possible practice but when you work for a company whose only interest in backups is when the worst happens, then like in the film Heart Break Ridge you have to adapt and improvise.

I am constantly struggling to achieve even simple model backups because of the lack of disk storage space let alone move over to more secure complex models, and due to performance issues I am limited to doing one backup per day.

It is frightening to think that there are companies like this, but I am sure we are not alone as with everything it boils down to cost and like many many people they know they should have life, even property insurance (see some of the cases of UK flood victims) but just can’t justify the cost at the time.

Sadly, Penny wise, pound foolish. ;-)
Grant Fritchey
Grant Fritchey
SSC Guru
SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)

Group: General Forum Members
Points: 93857 Visits: 33010
ken.trock (1/4/2010)

Speak of Murphy and he will appear. Right here is a good example. No backups. Corrupt file. Just the same as flat tire, no spare.


This is something of a sad story. Hope it works out.

I've read a lot where the final step in a backup process is to ensure you can actually restore the backup :-D. We update our hardware frequently enough such that we do side by side updates (sometimes upgrading the SQL version too) where we restore last night's backups onto our new servers. Proof positiveExclamation

Ken


Exactly. And you have a reasonable assurance that you'll be able to do a restore and that it will work in a real emergency. That's the way it should be.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Grant Fritchey
Grant Fritchey
SSC Guru
SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)

Group: General Forum Members
Points: 93857 Visits: 33010
Edogg (1/4/2010)
Grant Fritchey (1/4/2010)
umailedit (1/4/2010)
Why should something as routine as backup not be done automatically by computers? Why depend on people to do the backup?


Speak of Murphy and he will appear. Right here is a good example. No backups. Corrupt file. Just the same as flat tire, no spare.



Backups don't save jobs but restores do. Having a corrupt backup is just like having a flat spare tire.


100% True. But step one is still to take the backup.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Grant Fritchey
Grant Fritchey
SSC Guru
SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)

Group: General Forum Members
Points: 93857 Visits: 33010
Ronald Cartmale (1/5/2010)
I could not agree more with the editorial and have always sort to ensure that my company’s data is protected by the best possible practice but when you work for a company whose only interest in backups is when the worst happens, then like in the film Heart Break Ridge you have to adapt and improvise.

I am constantly struggling to achieve even simple model backups because of the lack of disk storage space let alone move over to more secure complex models, and due to performance issues I am limited to doing one backup per day.

It is frightening to think that there are companies like this, but I am sure we are not alone as with everything it boils down to cost and like many many people they know they should have life, even property insurance (see some of the cases of UK flood victims) but just can’t justify the cost at the time.

Sadly, Penny wise, pound foolish. ;-)


My wife and I used to pay renters insurance when we lived in the city. People scoffed at us until the day we were broken into. They cleaned us out, but we were able to replace most of it because of the insurance.

I also remember having a database go corrupt, fluke thing, but we had good backups and log backups and did a point in time recovery to about a minute before the corruption occurred. We were heroes that day and just because of something incredibly fundamental and stupid easy, good, tested, backups.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
GilaMonster
GilaMonster
SSC Guru
SSC Guru (211K reputation)SSC Guru (211K reputation)SSC Guru (211K reputation)SSC Guru (211K reputation)SSC Guru (211K reputation)SSC Guru (211K reputation)SSC Guru (211K reputation)SSC Guru (211K reputation)

Group: General Forum Members
Points: 211969 Visits: 46259
Grant Fritchey (1/5/2010)
My wife and I used to pay renters insurance when we lived in the city. People scoffed at us until the day we were broken into. They cleaned us out, but we were able to replace most of it because of the insurance.


Lucky you.

When I was broken into my insurance tried every trick in the book to avoid having to pay out (including claiming that the break in was my fault). After copious 'discussions' they eventually paid out less than half the insured value of the items, claiming 'depreciation of value'

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


Kim Rossey
Kim Rossey
SSC Rookie
SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)

Group: General Forum Members
Points: 27 Visits: 39
Another thought is not backing up to the same box your db server is on Smile

Email I got yesterday from a frazzled IT lead ...

We recently had a sbs2003 server running sbs2000 sql crash
It was very bad 2 of 4 Hds failed in a raid 5
I was able to run data recovery and get some sql backups which show correct file size
however when I go to restore the data to our windows 2003 std/sql2005 std server I get
backup is incorrectly formed type errors


Regards,
Kim(Kman)

www.toocoolwebs.com
Steve Jones
Steve Jones
SSC Guru
SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)

Group: Administrators
Points: 139708 Visits: 19413
good editorial, and nice reminder, Grant.

When I'm with Scouts, if we're out in the woods and something breaks, you need to have things to respond to that emergency. same thing with backups and your systems. You can't count on being able to run to the store to make things all better. You had better been prepared early for what might happen.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Grant Fritchey
Grant Fritchey
SSC Guru
SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)

Group: General Forum Members
Points: 93857 Visits: 33010
Steve Jones - Editor (1/6/2010)
good editorial, and nice reminder, Grant.

When I'm with Scouts, if we're out in the woods and something breaks, you need to have things to respond to that emergency. same thing with backups and your systems. You can't count on being able to run to the store to make things all better. You had better been prepared early for what might happen.


Thanks Steve.

We're getting ready for the winter survival campout next month. Should be fun.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
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