SQL Database Troubleshooting

01/06/2026

Your CHECKDB timestamp is lying to you
And you don’t even know it

Most DBAs trust one field:
dbi_dbccLastKnownGood

Problem?

It often lags behind reality.

Especially when you manage:

Read-only databases

Availability Group secondaries

Filegroup level checks

Takeaway

Don’t rely on an inconsistent indicator to prove database health.

Better Framework

If you’re on 2016 SP2+:

Use: DATABASEPROPERTYEX('dbname','LastGoodCheckDbTime')

Query from any replica

Build alerts around this SUPPORTED property

Log results in a custom table

Supported beats undocumented. Always. https://www.stellarinfo.com/blog/how-to-repair-sql-database-using-dbcc-checkdb-command/

01/12/2024

Discover the step-by-step guide on rescuing your MS SQL Database from Suspect Mode in our latest blog post!
Read now: https://www.stellarinfo.com/.../recover-sql-database.../
Dive into practical insights and expert tips for a smooth recovery journey.

11/27/2022

Watch the customer testimonial after our software Stellar Repair for MS SQL helped to repair the corrupt SQL Database.
Repaired 94GB database efficiently.


https://www.stellarinfo.com/sql-recovery.php
https://youtu.be/SBUoGeHDsoo

Mr. Joseph Gichuki, a consultant at ‘National Water and Seaways Corporation’ based in Uganda, shared his...

06/28/2022

I am looking for content writer experience in writing content on software- products/Services/technology, experience in writing content
Min Experience 5+ Years
Qualification - Computer science Graduate only
Location- India

Please share your resume on my email [email protected]

My Recruitment team will reach out to you.

06/28/2022

I am looking for Digital Marketing Professional for the Team Leader position. Experience in establishing a Brand in the Market via various activities with Good English Language communication, Being visible organically and Paid, and Generating Traffic for product pages.
Analytical approach and can implement various SEO and Paid strategies. Experience in Handling the team.

Position - Team Lead-B2B
Min Experience 5+ Years
Qualification - Computer science Graduate and Post Graduate only.
Most preferable from Products/Services/technology-B2B
Website: https://www.stellarinfo.com/
Location- India/ Gurgaon

Please share your resume on my email [email protected]

My Recruitment team will reach out to you.
#

Data Recovery Software & services to recover lost, deleted, formatted data from desktop, laptop, mobile, tablet or from any storage media.

05/08/2022

Microsoft MVP- Daniel Calbimonte, Shared his Experience with Stellar Repair for MS SQL
https://youtu.be/Aie0OxxeQrg

Daniel Calbimonte is Microsoft Most Valuable Professional in SQL Server and Data Platform. He had shared his experience about Stellar Repair for MS SQL.He s...

09/16/2021

Recover SQL Databases Affected from STOP/DJVU Ransomware

Summary: STOP/DJVU is an ongoing threat for DBAs that encrypt databases, preventing the victims from accessing the . Read on to learn about the STOP/DJVU ransomware in detail and what DBAs can do to recover DJVU infected files.
https://lnkd.in/eXei_64U
#

08/26/2021

Quick Read for all Admins "Deconstructing the Availability Modes in SQL Server Always On Groups"

this article focuses on the “availability modes” you can use to seek business continuity. We read earlier that a SQL Server availability group comprises databases, replicas, and data synchronization mechanisms.
https://www.linkedin.com/pulse/deconstructing-availability-modes-sql-server-always-/?trackingId=ctSVLbkswEfyaMMcfp7xOw%3D%3D

Continuing from our previous article on using SQL Server always on groups, this article focuses on the “availability modes” you can use to seek business continuity. We read earlier that a SQL Server availability group comprises databases, replicas, and data synchronization mechanisms.

08/11/2021

How to Fix DBCC CHECKDB Consistency Errors?
This blog will help you understand ‘how to fix DBCC CHECKDB consistency errors' in the SQL Server database using manual methods or a professional SQL repair tool. It will also discuss the possible causes of database consistency errors and help you determine the cause behind the errors.
https://www.stellarinfo.com/blog/fix-sql-server-database-dbcc-checkdb-consistency-errors/

07/15/2021

SQL Server High Availability and Disaster Recovery Plan
My First article is live on Red-Gate, Simple talk.
Thanks to Kathi Kellenberger and Grant Fritchey for the support.

Microsoft provides quite a few features for high availability and disaster recovery. In this article, Priya describes the HA/DR options.