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

Zombie Data Expand / Collapse
Author
Message
Posted Monday, February 03, 2014 8:31 PM


SSC-Dedicated

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

Group: Administrators
Last Login: Yesterday @ 11:24 AM
Points: 32,781, Visits: 14,942
Comments posted to this topic are about the item Zombie Data






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1537597
Posted Tuesday, February 04, 2014 1:27 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 8:20 AM
Points: 4,862, Visits: 2,243
This overlaps with my belief that all software systems should be delivered with a comprehensive decommissioning plan. By comprehensive I mean that it should cover all forms of data (including configuration, backups, etc.), hardware, software, manual processes and possibly much more besides.

Of course, a single application without data might be as comprehensive as running the uninstaller


Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
Post #1537636
Posted Tuesday, February 04, 2014 6:40 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 4:30 PM
Points: 601, Visits: 1,741
I worked for a bank for many years. The actual day-to-day servicing company would give us a monthly dump of all transactions by the customers for their checking, savings, mortgage and other accounts. We would keep a years worth online in a SQL DB and then every March I would copy the prior year's tables into a blank DB, delete it from the production and burn the backup to CD/DVD that went into two different vaults.

I had the whole procedure written out. The cover on the CD/DVD had a destroy date on them. I wonder if anyone has done it since I've been gone?

Because the data was subject to the IRS rules -- I hope they have and haven't been caught for not doing it.




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

A little bit of this and a little byte of that can cause bloatware.
Post #1537738
Posted Tuesday, February 04, 2014 10:50 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 3:49 PM
Points: 2,866, Visits: 1,708
My first task in my first IT job was to take a lump hammer to a set of Wang minicomputer hard disks!

Probably my first experience of job satisfaction.


LinkedIn Profile
Newbie on www.simple-talk.com
Post #1537871
Posted Tuesday, February 04, 2014 11:39 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 3:56 PM
Points: 20,466, Visits: 14,099
I am curious how many people destroy the old backups that belong to no longer existent databases or that are well past the retention policy.

From looking at a few hundred client servers, I dare say very few people think to decommission those old backups once the database has been decommissioned.




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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1537894
Posted Tuesday, February 04, 2014 3:45 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 3:49 PM
Points: 2,866, Visits: 1,708
@Jason, that is a very good point. Under the UK data protection act an individual can ask that their records be removed in certain conditions. Imagine having to remove individual records from backup tapes you may still need!

LinkedIn Profile
Newbie on www.simple-talk.com
Post #1537970
Posted Tuesday, February 04, 2014 4:18 PM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 4:30 PM
Points: 601, Visits: 1,741
David.Poole (2/4/2014)
@Jason, that is a very good point. Under the UK data protection act an individual can ask that their records be removed in certain conditions. Imagine having to remove individual records from backup tapes you may still need!

I asked our legal counsel about that issue. Such as the person that opened and closed the account within a year and should have "technically" been purged in 2009 but was still in the mass of data from 2010.

The legal view, written down to cover my butt, was that in the mass of data it was not an issue. But if that data were to be subpoenaed it technically did not exist beyond a certain date in the sense it could not be revealed or provided to the courts or any of the litigants.

Most courts understand that this is how it works. Now if the data was to be subpoenaed by the courts before the purge period, you have a responsibility to retain it until the courts no longer need it regardless of the purge dates.




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

A little bit of this and a little byte of that can cause bloatware.
Post #1537978
Posted Tuesday, February 04, 2014 4:37 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 3:56 PM
Points: 20,466, Visits: 14,099
David.Poole (2/4/2014)
@Jason, that is a very good point. Under the UK data protection act an individual can ask that their records be removed in certain conditions. Imagine having to remove individual records from backup tapes you may still need!


Ouch!




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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1537985
Posted Wednesday, February 05, 2014 7:56 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: 2 days ago @ 12:40 PM
Points: 1,477, Visits: 4,281
It's too easy for human error and bias to filter and transform terrabytes and petabytes of data. Unless we also apply common sense, big data analytics will prove no more reliable than consulting spirit advisors or tea leaves.


"Winter Is Coming" - April 6, 2014
Post #1538192
Posted Wednesday, February 05, 2014 9:44 AM


SSC-Dedicated

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

Group: Administrators
Last Login: Yesterday @ 11:24 AM
Points: 32,781, Visits: 14,942
SQLRNNR (2/4/2014)
I am curious how many people destroy the old backups that belong to no longer existent databases or that are well past the retention policy.

From looking at a few hundred client servers, I dare say very few people think to decommission those old backups once the database has been decommissioned.


I agree. I've found lots of old backups laying around, especially on dev/test machines.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1538255
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse