Record Series Abstract
Cases referred to enforcement staff from all Water Resources program offices for civil legal action against a respondent who has violated any of the state or federal regulations for which the Division of Water Resources (DWR) has regulatory responsibility, and the case has historical significance based on legal precedent, or other landmark legal value. Records vary but may include documents to determine compliance such as transcripts or summaries of informal meetings, site photographs, briefing memos, compliance data reports, final orders, court documents, pleadings, briefs, judgements, liens, and appellate documents. Does not include penalties, as these are paid to Consolidated Fees Unit.
Record Series Active
Cut Off at End of
If Other, Explain
Upon closure of case.
Total Retention Years
Total Retention Months
Retention End Action
Files are to be archived on a monthly basis following the 5 years after closure of cases. The paper is transferred to State Library and Archives and the electronic files are permanently stored in an electronic format in Waterlog database.
11th Floor, Wm. R. Snodgrass TN Tower 312 Rosa L. Parks Avenue
Numeric, by case number
1977 to current
5 cubic feet; 1 gigabyte
56 cubic feet; 40 gigabytes
Information Shared Outside the State
Environmental Protection Agency
Does this Record Series Contain Sensitive Information?
Retention Legal Citation
Legal Citation PDF
Oracle Database - Waterlog
Oracle NAS (Networked Attached Storage) managed by STS. Raid 6 system with 40 terrabytes of space. STS Fiber SAN managed by STS. This is the STS mandated storage medium and backed up through Enterprise Backups.
Oracle Database Enterprise 11.2.3 NAS mounted and managed through Windows CIFS (Common Internet File System). Oracle Exports and Hot online backups are used to backup the data SAN storage from where it is backed up to the Enterprise backups. Expected to use .doc, .docs, .xls, .xlx, .pdf, and .tif file formats.
STS Data Center South
NAS stores 31 daily snapshots. In addition, full backups are taken monthly with incremental backups taken daily. The monthly backups are stored offsite for 7 years. With both methods considered, we can restore to any of the past 31 days if the file(s) existed during the time of either the snapshot or the backup, to one of the full monthly backups from up to 7 years prior. Oracle Database is run in archive log mode and all redo logs are backed up daily. Hot backup of all data files is done on weekends.
Recovery Procedure: Helpdesk tickets to STS as Priority 1 can restore file(s) in 2 hours' time if restoring to a point within the past 31 days. If later (as tapes must come from offsite), expected Priority 1 recovery time is 5 hours. Major Disaster Recovery: STS has a written policy on how to handle major disaster recovery. In summary: order new hardware if required. Receive, configure and verify setup and connectability. Install required software to restore from image files and/or tapes. Inventory media and image files, restore.
Data Migration Description
STS maintains and migrates data according to system updates, upgrades and replacement standards per industry standards. Full procedures are available with the Office of Information Resources.
Legacy Revision UUID