Hosting Service Manual
Data Reporting Service
The Data Reporting Service (DRS) database is a read-only replica of your production database available specifically for reporting purposes. It exists to remove any possible impact on your production database that could arise from the queries run by third party services. It also allows you to have direct database access, which is not possible in your production environment.
Setup and Access
The DRS database is not part of our standard hosting provision. If you'd like to use the service, speak to your account manager.
Once set up your project manager will provide you with connection details and credentials of the SQL user. The database can be accessed over your usual production VPN connection - there is no access outside of the VPN.
The service provides read-only access to a complete copy of your production database.
Data Restoration Interval
By default your production database is replicated to your DRS database every 24 hours, soon after midnight. If you'd like to change the frequency, let us know.
Limitations and Support
This provision should not be deemed a business critical service. We will use best endeavours to ensure that data is no more than 24 hours old.
Support will be provided between the hours of 8:00 and 18:00 Monday to Friday excluding UK Bank Holidays and all tickets will be prioritised as "P3". There will be no availability SLA or service credit provision for this service.
As with all services potentially involving Personally Identifiable Information, you should take guidance from your Data Protection Officer in respect to undertaking a Data Privacy Impact Assessment (DPIA) as part of the procurement of this service.
Other than providing a copy of the database and access to it, we cannot provide support for the types of query you may want to run against it.