Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Data Preservation Expand / Collapse
Author
Message
Posted Tuesday, December 3, 2013 7:39 PM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Today @ 11:05 AM
Points: 625, Visits: 2,152
Then there is a question of what really needs to be retained.

In the past I was the responsible archivist for financial data, including mortgage payments. So the way the law is currently crafted is that you need to maintain the last seven years of data for IRS purposes, but technically had to delete the data older than seven years (plus 30) from mortgages that had paid off. I came up with a CD/DVD system that had the zip software of the backup and a copy of the SQL Server installs in use at the time. The application wasn't there, but the data was.

That was after I had to do a tape search of loans we had done in Georgia, over five years earlier, that was an abysmal failure.

I swore that I would never leave myself or my successors over such a large abyss ever again.

But sometimes I think of Jeff Atwood's comment of using paper. And if you think of how much history was preserved on papyrus (Dead Sea Scrolls) or stone (the Pyramids) it might not be a horrible idea.




----------------
Jim P.

A little bit of this and a little byte of that can cause bloatware.
Post #1519459
Posted Wednesday, December 4, 2013 1:59 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 6:59 AM
Points: 2,899, Visits: 1,798
This topics emphasizes that if long term retrieval is a required then this has to be designed in from day one.

I have worked on a project to retrieve data from 7 years worth of backup tapes and it was painful. The backups were designed to protect day-to-day OLTP and not a data warehouse type operation.

Music lost from the 80's and 90's? Playing devil's advocate is that necessarily a bad thing?!?!? If it was any good then it is probably still being played on independent (UK) radio and definitely is by my noisy neighbours!

As to the long term worth.....if you've ever cleaned out your house and brutally got rid of all the things that "might have been useful one day" but somehow never were its amazing how much you don't miss it, or in many cases even remember you had it.


LinkedIn Profile
Newbie on www.simple-talk.com
Post #1519522
Posted Wednesday, December 4, 2013 3:21 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:29 AM
Points: 5,318, Visits: 3,007
Steve Jones - SSC Editor (12/3/2013)
Gary Varga (12/3/2013)

I have total faith that the digital photos will be convertible because the formats are widely known so, even if it will cost, there will be conversion services or readers available. I think the bigger problem is the vast amount of photos the current generations are producing as I can imagine that more photos are taken on an average night out than my Mum took on our annual holiday (vacation to you overponders ) which accounted for over half the yearly photos taken. Also loss due to services disappearing. How many people back up their Facebook photos?



I actually grab my Facebook stuff every quarter. They make it easy to export, though it's not quick.

Volume is a huge issue. Right now YouTube gets over 24 hours of video every second uploaded. It's not all from me, but I have some up there. I worry about those older videos, those photos, etc. being converted. I suspect there will be services software to do it, but it's not necessarily an easy process. Already I know I have digital and analog video tapes that may be lost since I'm not sure the devices work. I should convert our VHS stuff over now while we can.


There was a large bustle of activity here in the UK when photos went digital with loads of digitising services (if you could afford it).

...Steve you have got to know that it was not people here that I was questioning were backing up their Facebook photos (I am sure you will eventually find that you have some fan who maintains a record of your famous Hawaiian shirts thereby providing a free backup of some of your photos!!!).


Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
Post #1519543
Posted Wednesday, December 4, 2013 3:25 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:29 AM
Points: 5,318, Visits: 3,007
David.Poole (12/4/2013)
...Music lost from the 80's and 90's? Playing devil's advocate is that necessarily a bad thing?!?!? If it was any good then it is probably still being played on independent (UK) radio and definitely is by my noisy neighbours!...


I disagree so this may make me a valuable source of late 80s/early 90s UK indie music...along with my Adolescent Radioactive Black-Belt Hamsters comics


Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
Post #1519544
Posted Wednesday, December 4, 2013 9:07 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 3:06 PM
Points: 33,169, Visits: 15,304
Saw this today as well: http://www.theverge.com/2013/12/4/5173960/70-percent-of-american-silent-films-have-been-lost-study-shows






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1519684
Posted Wednesday, December 4, 2013 2:43 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 6:59 AM
Points: 2,899, Visits: 1,798
Gary Varga (12/4/2013)


I disagree so this may make me a valuable source of late 80s/early 90s UK indie music...


Indie yes. Stock, Aitkin and Waterman not so much.


LinkedIn Profile
Newbie on www.simple-talk.com
Post #1519800
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse