This chapter 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 things out there. You might think that a smaller database is a good thing, however there …
DBCC HELP is the first DBCC command we will cover because it can be used to get details on other DBCC commands. DBCC HELP is a database console command (DBCC) in Microsoft SQL Server that can be used to display a list of all available DBCC commands, or to display detailed information about a specific DBCC command. Displaying a list …
Navigating the landscape of Microsoft SQL Server, one may occasionally encounter the formidable issue of database corruption, which can jeopardize vital data and disrupt business processes. Drawing upon one’s experience in diagnosing and repairing such instances of corruption is essential to restore the system’s functionality and protect data integrity. Determining when corruption was introduced into a SQL Server database can …
DBCC CHECKTABLE is a database console command (DBCC) in Microsoft SQL Server that can be used to check the physical and logical integrity of a table in a database. Checking the integrity of a table can be useful for detecting corruption in the table or for troubleshooting issues with the table. To use DBCC CHECKTABLE, you must specify the name …
Transcribed from a presentation on Database Corruption by Steve Stedman and Derrick Bovenkamp. Derrick : How do we find corruption? Oh, man, I wish it was as easy as taking out the magnifying glass there. Steve : Yeah, if we had this magic magnifying glass that would let us look at the data bytes like that, that’d be cool. But …
SQL Server Corruption: More about Detecting Corruption Read more »
DBCC DLLNAME is a database console command (DBCC) in Microsoft SQL Server that can be used to display the name of the dynamic-link library (DLL) file associated with a specific database console command (DBCC). Displaying the DLL file name can be useful for troubleshooting issues or for verifying the version of a specific DBCC command. To use DBCC DLLNAME, you …
Determining when corruption was introduced into a SQL Server database can be challenging, as corruption can occur without generating any obvious symptoms. However, there are some steps you can take to help determine when corruption was introduced: * Check when the last good CheckDB was run. This won’t tell you when the corruption started, but it will tell you the …
Running backups on a SQL Server Fri, 31 Mar 2023 Running backups on a SQL Server is crucial for several reasons: Disaster Recovery: SQL backups are essential for disaster recovery. If your SQL Server fails, becomes corrupted, or suffers from a data loss incident, having a backup allows you t Read more… SQL Server Corruption: Corruption vs Drive Failure Thu, …
There are several methods you can use to detect corruption in your Microsoft SQL Server database: * Use the DBCC CHECKDB command: The DBCC CHECKDB command is a database consistency checker that scans the entire database and its associated objects to identify and report any corruption. Running DBCC CHECKDB is the most comprehensive way to detect corruption in your SQL …
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 »