Backups that restore
A real restore to a target you choose, timed, with the recovery point you actually have.
Front door · 1 week
SQL Server Health Check
For the database behind your ERP or line-of-business app. We restore a backup to prove it works, read the slow query plans, check security and version support, and write down what to fix first and what each fix costs.
Most SQL Servers in small and mid-sized businesses were set up once and never looked at again. They run, so nobody asks whether the backups restore, whether the version is still patched, or why the month-end report takes forty minutes.
SQL Server 2016 left extended support on July 14, 2026 and 2017 follows on October 12, 2027. If your ERP sits on either, this is the week to find out what that means for you.
What we check
The nine things that go wrong quietly.
Slow queries and plans
The top waits and the plans behind them, with the indexes that would fix them.
Security
Logins, sysadmin membership, orphaned users, surface area, and what the application really needs.
Version and support
Build, patch level and Microsoft support dates, with the upgrade path if you need one.
Storage and growth
File growth settings, free space, tempdb layout and what runs out first.
Maintenance
Integrity checks, index and statistics maintenance, and whether any of it runs.
How it runs
One week, four steps.
Access
A read-only login and a restore target. Nothing on the instance is changed.
Collect
Configuration, waits, plans, jobs, backups and security read and recorded.
Restore
The latest backup restored for real and timed.
Report
Findings ranked by risk, each with the fix and the hours it takes.
Common questions
Before you book.
Will the check slow down our server?
No. Everything is read from system views and existing backups, and the restore runs on the target you choose, not on production.
We are on SQL Server 2016. What happens now?
It stopped receiving security patches on July 14, 2026. The report gives you the upgrade path, whether Windows Server 2016 under it needs to move as well, and what the vendor of your application supports.
Can you do the fixes?
Yes, and the fee is credited toward them. Most are a few hours each; an upgrade or migration is quoted separately from the report.
Find out whether your backups restore before you need them to.
Book a 30-minute call and we will schedule the week.