Blog Post

Running SAP Applications on the Microsoft Platform
10 MIN READ

Corruption Handling in SAP Databases

MarkSQLSAP's avatar
MarkSQLSAP
Icon for Microsoft rankMicrosoft
Mar 13, 2019
First published on MSDN on Oct 30, 2013 What is database corruption?  Why should you be concerned about corruption in a database?  What should you do when you encounter cor...
Updated Mar 13, 2019
Version 2.0
checkdb
corruption
dbcc
Robin Shanab's avatar
Robin Shanab
Iron Contributor
Aug 23, 2021

We can handle any type of corruption by a proper backup and recovery plan. In case of corruption, the best approach is to restoring the db from updated backup copy. 

 

If backup is not updated then, you should read the error log properly and take the decision according to the error mentioned in the log. 

Recently, I have read this blog: https://www.red-gate.com/simple-talk/databases/sql-server/learn/sql-server-high-availability-and-disaster-recovery-plan/