old backup files

  • Is there any industry standard term/phrase in the DBA community for old backups of SQL databases that have seemingly been left and forgotten about, that could pose a compliance risk around GDPR, or any other data retention element of the data regulations you are subjected to you in your roles.  I was thinking it could be something like orphaned backup files, but there may be a better phrase to help research this further.

  • No official term that I'm aware of. Old, outdated, orphaned, junk, garbage, <insert inappropriate words here>. You can call 'em just about anything I guess. I'd probably just refer to them as outdated backups. I'm unaware of any term of art on something like this.

    ----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

  • I use the term "Legacy Backups" when I need to politically correct terms so as not to be taken to task for what some people would call a "Visit by HR event 😀  although Grant's descriptions are much more accurate.  I also call them "Security Risks".   Another name for them might be "Resume Generating Files" because if they get out on your watch, you'll need to sharpen up your resume for your job search.

    My favorite description for such files is "Stupid and totally unnecessary security risk generated by moroffs that don't get it".  😀 😀 😀

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    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.
    "Change is inevitable... change for the better is not".

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • Thank you for the responses and input. The permissions on the files seem appropriate, it is just their age based on the file system info, suggests they have been forgotten about!

  • Agreed with @jeff.

    SQL Database Recovery Expert 🙂

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply