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 »
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 »
New SQL Server Course Release Track Blocking Queries Course Release! Using our instruction and scripts included in this course you will successfully configure email notifications when blocking occurs. Address blocking BEFORE it takes down your system. Enroll in this course for $24.99 >>> With Coupon Code >>> FEB-RELEASE50 … Read more… Day 1 – Database by Size 10 Days of …
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, …
Today I am pleased to announce the latest release of Database Health Monitor. Version 991, the January 2022 release of the product. You can download the latest version here: We are approaching 11 years of development time that I have put into this project with over 22,000 downloads of Database Health Monitor just in the last 3 years. We hope …
Database Health Monitor – January 2022 Version 991 Released Read more »
I am working on a big update to Database Health Monitor that I expect to release near the end of the year. So far I am sharing the beta with a few people to try it out before it is ready to release. Here is a list of some of the changes. Licensing Changes There are some licensing changes in …
At Stedman Solutions, we do a lot of work with SQL Server replication, mostly transactional and merge replication. The other day I needed a query to show all the merge replication publication on a SQL Server, not just a single database, but to see it for all databases on the SQL Server. Here is the query that I came up …
Announcing our Newest SQL Server Course We are so excited to release our newest SQL Server Course ”Getting Started with Microsoft SQL Server” We are launching this course with a 50% OFF discount code! Coupon Code: 50OFF-INTRO DBCC ShrinkDatabase – I want to shrink my database. TL;DR summary: Don’t do it. Stop reading here if you want, but just …
TL;DR summary: Don’t do it. Stop reading here if you want, but just don’t do it. This post refers to shrinking your database files (mdf, or ndf files), not shrinking the log file. The log file is a completely different conversation, however, shrink database does shrink the log file. Not shrinking your database is one of the more counter intuitive …
DBCC ShrinkDatabase – I want to shrink my database. Read more »
Steve Stedman So years ago, when my kids were growing up, and they were watching the Discovery Channel, or Animal Planet, or whatever it was where the Crocodile Hunter was there. And I remember Steve Irwin, the Crocodile Hunter used to say Danger, Danger, Danger, and he’d go in and like deal with some crocodile or something like that. And …