Here’s a quick and easy link to review all blog posts written by Steve Stedman in February 2021. Enjoy! SQL Server – Backing up a database Sat, 27 Feb 2021 If you are a pro at SQL server I am sure you already know how to backup a database, but for someone who is new to it, things can be …
Microsoft has just release an cumulative update for SQL Server 2017 CU 23. I am always interested in fixes to DBCC CHECKDB and DBCC CHECKTABLE. There was one fix related to CHECKTABLE that fixes an issue where the session gets killed when you run DBCC CHECKTABLE with PHYSICAL_ONLY due to disk full. The session remains in KILLED\ROLLBACK state and threads …
Since installing SQL Server 2019 CU9, I have been getting lots of errors about NO DEK Update for almost every file. Here is an excerpt from the SQL Server log file. 182 2/20/2021 2:07:46 PM spid25s Refresh DEK for DBID: [5] File Id: [1] – Copying encryption state183 2/20/2021 2:07:46 PM spid25s DBID: [5] File Header for File Id: [1] …
Now is your chance to ask a question about corruption in SQL Server databases. We will do our best job of answering those questions on our February webcast on database corruption. Do you have a question about the output from DBCC CheckDB? Seeing a strange error in your SQL Server logs? Is your SQL Server sending alerts related to corruption? …
Babelfish for Aurora PostgreSQLDecember 1, 2020Amazon goes after Microsoft’s SQL Server with Babelfish for Aurora PostgreSQL. What is interesting is that a direct port of SQL Server to PostgreSQL or Aurora PostgreSQL can be challenging due to incompatibilities …Babelfish for Aurora PostgreSQLRead More » Sales To Aggressive?November 19, 2020When does a salesperson become too aggressive? In my business I try …
At the beginning of June I realized that I was slightly behind on my blogging, so today, June 30th marks 30 days of 30 blog posts in the month of June. Some other big blogging months were March 2015 and April 2015, around the Database Corruption Challenge, and June 2013 with 27 posts, and May 2013 with 27 posts. I …
It was a busy week this week, but I was able to create several blog posts relating to corruption. Does a corrupt database really need to be repaired?June 11, 2020 At Stedman Solutions, LLC the team and I do many database repairs from simple things that take just a few minutes to larger repairs that take many days to repair. Since …
At Stedman Solutions, LLC the team and I do many database repairs from simple things that take just a few minutes to larger repairs that take many days to repair. Since 2015 we have been doing database corruption repair and have seen many different decisions made by the business owners with the corrupt database. Often times when investigating a corrupt …
Does a corrupt database really need to be repaired? Read more »
First rules about a database being in suspect mode: A SQL database that is SUSPECT implies that it was unable to completely start up after a shutdown. For instance, if the power was unplugged from the SQL Server while shutting down with open transactions that are currently being written to disk. Causes: The most important thing to do is to …
What does it mean when a SQL Database is SUSPECT? Read more »
Yesterday I posted about how repair_allow_data_loss should never be used with CHECKDB or CHECKTABLE. Today I want to share the difference between repair_rebuild vs repair_allow_data_loss. First off, after reading the post about never using repair_allow_data_loss, and you will understand that repair_allow_data_loss simply throws away pages. Next what repair_rebuild attempts to do is to rebuild pages in non-clustered indexes that are …