Projects / Data & Databases
Data & Databases
SQL Server administration, backup and restore strategy, and database troubleshooting and recovery.
When it helps.
- A backup or restore process has failed, or has never been verified end to end.
- A database is performing poorly and the cause is unclear.
- Availability and recovery expectations have never been formally reviewed.
- Data needs to move between systems reliably and without loss.
What's involved
- SQL Server administration
- Backup and restore strategy design and verification
- Database troubleshooting and recovery
- Availability and recovery-objective reviews
- Performance review and diagnosis
- Data integration between systems
- Reporting-system and recovery planning
What you get
- A verified backup and restore strategy with tested procedures
- A diagnosis of performance or availability issues with recommended actions
- A documented recovery plan mapped to realistic objectives
- Integration or reporting improvements where in scope
Typical work.
Examples of the kind of engagement this covers.
Diagnosing complex SQL Server backup and restoration issues and establishing a verified recovery procedure.
Reviewing database availability and recovery objectives against what the current configuration can actually deliver.
Investigating and resolving a persistent database performance problem.
Questions.
Related: Cloud & Infrastructure, Risk, Compliance & Resilience, Technology Advisory.
Which database platforms do you focus on?
The primary focus is Microsoft SQL Server. Related data-integration and reporting work is handled case by case depending on the environment.
Can you recover a database that is already lost?
Sometimes, depending on what backups and transaction records exist. You will get an honest assessment of what recovery is realistically possible before any approach is committed to.
Talk through what you're planning.
You will get a considered view of the approach before any work is scoped.