City of Richmond

1
City of Richmond

• Backup
• Service Level Review

Information Technology Alan Cameron Maarten
Veerman Ron Facey
2
Why Back Up Data?

• Generally, to recover data in case of a
• Site disaster the entire data centre destroyed
• Server disaster primary data storage damaged
• Data disaster file corrupted or lost
• Regulatory compliance
• Backup is not an Archive of data

3
What Are The Decision Points?

• How often to back up the data
• Hourly, daily, weekly, monthly, etc.
• How long to keep the data
• Days, weeks, months, forever
• How quickly it must be restored
• This hour, today, this week
• Corollary
• How much do you want to pay?

4
A Clerks View of Data Types

• 01 - ADMINISTRATION
• 0005 Administration General
• 0010 Administration Organization
• 0015 Accidents
• 0020 Acts and Legislation General
• 0025 Acts and Legislation Federal
• 0030 Acts and Legislation Provincial General
• 0035 Acts and Legislation Provincial British
  Columbia
• 0036 Acts Legislation - Provincial - Local
  Government Act (aka Municipal Act)
• 0040 Acts and Legislation Local Government
• 0045 Acts and Legislation Foreign
• 0093 etc.
• 02 - EQUIPMENT SUPPLIES
• 0600 Equipment and Supplies General
• 0605 Equipment and Supplies Inventories
• 0610 Audiovisual and Photographic Equipment
• 0615 Clothing
• 0620 Computers General
• 0625 Computers Hardware

5
An IT View of Data Types

• Unstructured Files, Documents, Media
• Data is disorganised
• Files can be deleted or moved
• Structured Databases
• Data is (often) cumulative
• Entire database can be a single unit
• Email Database
• Only what exists at midnight
• Forensic
• System logs used in case of an incident

6
Some Sample Categories

• HIGH - Unstructured Data (Critical DM System,
  Network Drives)
• MEDIUM - Unstructured Data (Low Volatility Media
  files)
• EXCH - Exchange Servers
• SYS - System Data (O/S Application files C\
  drives)
• STA - Static (Orthographic Photos)
• ORA - ORACLE (Production)
• ORATST - ORACLE (Test/Train/Extract )
• SQL - SQL Server (Production)
• SQLTST - SQL Server (Test/Train/Extract)
• LOG - Forensic (System Logs)
• DC - Domain Controllers

7
City of Richmond Backup Architecture
(Traditional)
City Hall Datacenter
Backup Datacenter
TCP/IP Network
Fibre Channel Network
8
City of Richmond Backup Architecture
(Serverless)
City Hall Datacenter
Backup Datacenter
TCP/IP Network
Fibre Channel Network