SQL Server Health Check
Meridian Freight Lines — Production (MFL-SQL01)
- Prepared for: Meridian Freight Lines
- Prepared by: Harborline Data Services
- Instance: Meridian Freight Lines — Production (MFL-SQL01)
- Report date: 6 November 2026
- Diagnostic run: 6 November 2026, 12:50 (server time)
- Basis: sp_Blitz output submitted by the DBA — one run, one instance
Diagnostic data produced with the SQL Server First Responder Kit (sp_Blitz), © Brent Ozar Unlimited, MIT License.
Prepared with WellInstance by Goodfolk.
Executive summary
What this server does. MFL-SQL01 is the database server behind Meridian Freight Lines' dispatch, load-planning, and billing application — the system roughly 120 staff use to book loads, plan routes, and invoice customers. It is a small server (4 processors, 3 GB of memory) holding three working databases totalling about a quarter of a gigabyte.
The overall picture, in one paragraph. The server is running a current, fully patched version of SQL Server and is doing its day-to-day work. The concern is not how it runs today — it is what happens on the day something goes wrong. As of this check, no database on the server has ever been backed up, the built-in corruption check has never completed on the server's own system databases, and no one is set up to be alerted if the server hits trouble. Those are fixable, inexpensive problems — but until they are fixed, a single hardware or storage failure could mean losing the dispatch and billing data outright rather than restoring it.
The three things to do first
- 1 · Back everything up — Take the first full backup of every database, and start regular transaction-log backups for DispatchOps. Today there is nothing to restore from.
- 2 · Run the corruption check — Run DBCC CHECKDB across the databases and schedule it. It has never run on the system databases, so silent storage corruption would currently go unnoticed.
- 3 · Set up alerts — The SQL Server Agent service is stopped and no alert operators exist. Configure both, so a severe error emails a human instead of waiting to be discovered.
What this report is — and is not. It is a point-in-time health check: the findings of one diagnostic run on 6 November 2026, organised and explained. It is not monitoring, not a security audit, and not a certification that the server is healthy — the absence of a finding is not a guarantee.
- Engine: SQL Server 2025 (RTM, Cumulative Update 10), version 17.0.5035.5 — Enterprise Developer Edition (64-bit), on Ubuntu 24.04
- Hardware: 4 logical processors · 3 GB physical memory · virtualised (hypervisor)
- Data: 3 user databases, 0.23 GB total file size
- Findings: 41 findings in the diagnostic output: 10 at priority 1 (the diagnostic's most urgent), 4 more at priority 10, 27 at lower bands, plus 18 server-information rows — all reproduced in full in the report's appendix.