![]() ![]() Note that, there are some corruption problems not detected by the DBCC CHECKDB named silent corruption. Running the DBCC CHECKDB can help you to detect errors. If you want to prevent database corruption then, a good firewall, using non-default ports, a great antivirus can help you to minimize attacks. Also, the CHKDSK command can help to check your disks. Monitoring your disk counters using the system monitor can help to monitor how it works using a baseline. ![]() One of the most common causes of a database corruption is a hardware failure. In this article, we will give an introduction about this tool with a step by step about how to use it. If the DBCC also fails, it is possible to use the Stellar Repair for MS SQL. If your backup is corrupt or infected by a virus, it is possible to run the DBCC command to repair the database. When the database fails, and it is corrupted, you can use a backup to restore the database. If your database is corrupted and the corruption is severe, no user will be able to access to the database and you may need to find a solution. That is why a good DBA should monitor not only the database and the operative system, but also the hardware using monitoring tools. The hard disk failure is a very common problem to corrupt a database. Also, a malicious employee or a hacker can attack your database. It can be a virus, a malware, a sudden shutdown an upgrade interrupted or a hardware problem. However, during the day, your database can suddenly be corrupted. There are millions of users using this popular DB worldwide. SQL Server is a popular and one of the most used databases around the world. ![]()
0 Comments
Leave a Reply. |