Category: Corruption

By Posted on Posted in Corruption, Ransomware No Comments Tagged with , , ,

Having a SQL assessment is important in terms of security for several reasons: Identifying vulnerabilities: A SQL assessment can help identify security vulnerabilities in the database. This includes identifying weak passwords, inadequate user access controls, and other security weaknesses unknown to the organization that can leave the database vulnerable to attacks. Preventing attacks: Addressing security vulnerabilities proactively can help prevent …

Why Having a SQL Assessment is Crucial for Ensuring Database Security Read more »

By Posted on Posted in Corruption No Comments Tagged with ,

As a database administrator, ensuring the integrity of your SQL database is of utmost importance. Any corruption or damage to the database can result in data loss or application downtime, which can have severe consequences for your business. One of the tools you can use to maintain database integrity is the DBCC Checkdb command. In this article, we will discuss …

Maintaining Database Integrity with DBCC Checkdb Command Read more »

By Posted on Posted in Classes, Corruption No Comments Tagged with , , , ,

Corruption in a SQL database is when the database becomes damaged or corrupted, making it unable to be used or accessed. This can happen for a number of reasons, such as hardware failure, software bugs, or even human error. When a database is corrupted, the data it contains may be lost or inaccessible, which can be a major problem for …

New Course – Preparing for Corruption in SQL Server Read more »

By Posted on Posted in Backup, Corruption, Recovery No Comments Tagged with , , , ,

At Stedman Solutions, LLC when we do corruption repair it usually means someone has discovered they have corruption, and they call us. If they had good backups and good CheckDB scripts, they wouldn’t have to call us because they would have known when the corruption happened and likely been able to restore from backup or restore and replay transaction logs …

Importance of Backups Relating to a Corrupt Database Read more »

By Posted on Posted in Backup, Classes, Corruption, Database Health, Performance, Ransomware, Recovery No Comments Tagged with , , , , ,

Whenever you hear a company with over 30 years of experience tell you facts from real life scenarios, you should hear what they have to say. Learn from others’ mistakes some say. Our team has come up with 3 quick common database mistakes from working in world of the SQL Server database repair, performance and analysis. 40% of our assessment …

3 Common Database Mistakes Business Owners Make Read more »

By Posted on Posted in Corruption No Comments Tagged with , , , ,

So, you have discovered CheckDB is reporting errors on your SQL Server database or on a table in your database. What do you do? REPAIR_ALLOW_DATA_LOSS seems like and quick and easy fix right? But do you actually know what you’re doing? Well, if you read the error messages you might see that repair_allow_data_loss is the minimum repair level for the …

Beware – REPAIR_ALLOW_DATA_LOSS Vs REPAIR_REBUILD Read more »

By Posted on Posted in Corruption No Comments Tagged with , ,

Some typical corruption scenarios we see: SQL Server Won’t Start If you are in the situation where your SQL Server Won’t Start up, this can be a side effect of the database corruption, and we can help. DBCC CheckDB Errors Running CheckDB throws lots of errors in red text. This also applies to any of the DBCC checks like CHECKCATALOG, …

Common Corruption Read more »

By Posted on Posted in Corruption, SQL Server No Comments Tagged with , , ,

There are a few versions of SQL Server 2012 and SQL Server 2014 that are known to cause corruption in certain situations. These versions are: 2012 versions between 11.0.2100 and 11.0.3436 2012 versions between 11.0.5058 and 11.0.5521 2014 versions between 12.0.2000 and 12.0.2369 The recommendation if you are running one of these versions that you check the release notes and …

Dangerous Versions of SQL Server Read more »

By Posted on Posted in Corruption, Recovery No Comments Tagged with , , ,

Will your backup and recovery strategy cover you? So what about ransomware?  A lot of people are getting hit with ransomware lately. I’ve seen more people lose their systems with ransomware than I have with almost any other type of failure! Generally, with system failures, when you need to restore from backup, even if you have a lame backup plan, …

Ransomware Recovery For Your SQL Server Read more »