Information Technology Policy Manual 2022

BACK-UP AND RETENTION POLICY

PURPOSE The purpose of this policy is to define the minimum standards for performing and retaining periodic backups of City of Greensboro computer system data. SCOPE These standards apply in their entirety only to the City of Greensboro file servers, SAN/NAS data Storage that are maintained by the IT Network Services Department of the City of Greensboro. Parties responsible for backup management on other City of Greensboro servers, however, are strongly encouraged to adopt these practices.

POLICY/ROLES AND RESPONSIBILITIES

Data Backup and Retention

1. It is the responsibility of the City of Greensboro IT Network Service Department staff and manager to determine which folders will be backed up on any given City of Greensboro file server. 2. An approved backup job will be scheduled to run on each file server once or more every day. a. Using Veeam Incremental back-up, a scheduled backup will be run every day of the week on every standalone server and kept for 30 days. Full backups performed each week to confirm consistency. b. Using Netapp snapshot technology a scheduled snapshot/backup of all file data residing on SAN/NAS systems will be scheduled to run every 4 hours and will be retained for 30 days. c. Using Netapp data mirror technology all data residing on the Netapp Storage Systems will be scheduled to replicate all LUNs data to a remote SAN/NAS system located at an off-site building and will be retained until the data is no longer needed. 3. An approved backup job will be scheduled to run on each SQL Database server once or more every day. a. Full SQL database backup jobs will be scheduled to run on each sql server every day of the week and kept for 30 days. Full backups performed each week to confirm consistency. b. All critical SQL databases will be located on SAN/NAS systems and the data will be replicated to a remote SAN/NAS system using NetApp snap-mirror technology. c. Verifying Backups/Integrity check: a sampling of SQL databases restore are performed to validate the integrity of backup jobs d. Infor Lawson is backed up by the AWS Cloud operations team where it is hosted. Refer to the SOC report from AWS for backup policies.

4. An approved backup job will be scheduled to run on each email Exchange Database server once or more every day.

15 | P a g e