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


Safety in Numbers


Safety in Numbers

Author
Message
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: 139688 Visits: 19413
Comments posted to this topic are about the item Safety in Numbers

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
lkammer
lkammer
SSC-Enthusiastic
SSC-Enthusiastic (100 reputation)SSC-Enthusiastic (100 reputation)SSC-Enthusiastic (100 reputation)SSC-Enthusiastic (100 reputation)SSC-Enthusiastic (100 reputation)SSC-Enthusiastic (100 reputation)SSC-Enthusiastic (100 reputation)SSC-Enthusiastic (100 reputation)

Group: General Forum Members
Points: 100 Visits: 164
It is quite difficult to get your head around this one, Deciding what to keep and what not to.

I always keep the last Three Full Backups, the Transaction Log backups and Differential Backups between them.
Once the Full Backup is performed on Sunday night, these are restored on a Test DB on monday morning, if they fail, Back it up again.

I became complaisant with the backup routine and decided that One Full was enough after IT complained i was using too much disk space on the SAN for storing the DB backups and suggested I alter my backup routines... so I began to keep only the last full and the transaction logs after, but got seriously burned one day a few months ago when the backup on the disk were corrupted and the DB server went down on monday morning before i came in due to a hardware failure.

We live and learn, but that day in August will probably remain with me forever more...

Leon
IceDread
IceDread
SSC Eights!
SSC Eights! (921 reputation)SSC Eights! (921 reputation)SSC Eights! (921 reputation)SSC Eights! (921 reputation)SSC Eights! (921 reputation)SSC Eights! (921 reputation)SSC Eights! (921 reputation)SSC Eights! (921 reputation)

Group: General Forum Members
Points: 921 Visits: 1145
About full backups, we take one each night for each database. We store them at a different safety location. I believe requirements might vary a lot depending on the company. I'm btw a Consultant at a Company where you can purchase a pension insurance and you have funds to chose between and thus you get a yield on the pension.
GlenParker
GlenParker
SSC Eights!
SSC Eights! (805 reputation)SSC Eights! (805 reputation)SSC Eights! (805 reputation)SSC Eights! (805 reputation)SSC Eights! (805 reputation)SSC Eights! (805 reputation)SSC Eights! (805 reputation)SSC Eights! (805 reputation)

Group: General Forum Members
Points: 805 Visits: 133
I used to retain the last 2 Full AND Transaction Log backups pending verification of a RESTORE into a shadow DB however, after listening to sob stories from the IT geeks that my disk usage had risen from 4 GB to >16 GB, I dropped down to retaining the last Full Backup only.

I had an erraneous backup on my main DB recently which only came to light when I attempted a RESTORE into my shadow DB. It was a nervous couple of hours before I could RESTORE another hastily triggered Full backup, an event that highlighted how precarious and inadequate my maintenance plan was.

I've since returned to retaining my last 2 Full AND Transaction Log backups.

Glen Parker :-)
Manie Verster
Manie Verster
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2249 Visits: 1030
I've typically kept two full backups (the most recent and the one before that) along with the log backups between them, just in case.

Hi Steve, nice article. It is always necessary to get other people's take on backups. I also keep two full backups but only logs up to the last full backup. Why would you want to keep log backups between? Like to hear your ideas.

:-PManie Verster
Developer
Johannesburg
South Africa

I can do all things through Christ who strengthens me. - Holy Bible
I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)
Knut Boehnert
Knut Boehnert
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1331 Visits: 382
2 backups on disk (3 for system tables), 7 days on on site disk/tape, copies offsite.
Restore of main database every month from Live to Dev environment to
a) eliminate any baseline differences in code (bad change control mentality by developers to blame aka "It works so what?")
b) test backup
Richard Gardner-291039
Richard Gardner-291039
SSC Eights!
SSC Eights! (849 reputation)SSC Eights! (849 reputation)SSC Eights! (849 reputation)SSC Eights! (849 reputation)SSC Eights! (849 reputation)SSC Eights! (849 reputation)SSC Eights! (849 reputation)SSC Eights! (849 reputation)

Group: General Forum Members
Points: 849 Visits: 421
Right, just re-read your post, you're not interested in tapes.

Personally I don't see the difference, the only difference between keeping a backup on tape or on disk is that disk is quicker to restore.

Maybe I'm being thick here but a file is a file is a file.

Isn't it?

Anyway, a week, from disk.
dcooper 32364
dcooper 32364
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 4
Where I work we keep every single backup, we keep an immediate copy here in the building of the previous day's data, then backup the previous backup to another server somewhere else in the country. There at the other location I think we operate the father father son theory in which you hold 3 copies of that data. Depending on which DB and how important the data is on that DB, we have more/less backups than what i've just said, but thats the typical setup we have here for standard importance DBs
dcooper 32364
dcooper 32364
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 4
dcooper 32364 (2/12/2010)
Where I work we keep every single backup, we keep an immediate copy here in the building of the previous day's data, then backup the previous backup to another server somewhere else in the country. There at the other location I think we operate the father father son theory in which you hold 3 copies of that data. Depending on which DB and how important the data is on that DB, we have more/less backups than what i've just said, but thats the typical setup we have here for standard importance DBs

In addition to this, we have some data that is so Old that it's stored on tapes and restoring it is a 2 man job, one person has to scan the data while someone else is manually inserting and removing the next tape,
Bob Robinson
Bob Robinson
SSC Veteran
SSC Veteran (258 reputation)SSC Veteran (258 reputation)SSC Veteran (258 reputation)SSC Veteran (258 reputation)SSC Veteran (258 reputation)SSC Veteran (258 reputation)SSC Veteran (258 reputation)SSC Veteran (258 reputation)

Group: General Forum Members
Points: 258 Visits: 66
I work in the Insurance industry. We do full backups every weekday to disk and then to tape. The tapes are then sent offsite. The tape rotation we use allows us to restore to any position within the last month and any month end position that we have a tape for. We keep all monthly tapes forever - but expect that the tapes will become unreadable way before then. Is anyone else subject to eDiscovery procedures?



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