Search sqlserver-dba.com
Follow sqlserver-dba.com
For any SQL Server issue send email to: jack@sqlserver-dba.com
SQLServer-DBA.com Links
Recent Posts
- How to fix Invalid comparison due to NO COLLATION
- How to fix BACKUP LOG cannot be performed because there is no current database backup
- How to recover SSMS auto recover scripts after crash
- How to capture SQL Server database RESTORE details with Extended Events
- Installing Ola Hallengren SQL Server Maintenance Solution on AWS RDS
- Get free disk space for mount points using Powershell
- How to check SSAS service status with Powershell
- How to check SSRS service status with Powershell
- How to get count of GROUP BY columns
- How to fix operating system error code 80(The file exists.) in SQL Agent Job during BULK LOAD
SQL Database Corruption
30 May,2013 by Tom Collins
SQL Database Corruption - What steps should I follow to prepare for database corruption?
SQL Database corruption errors can occur during the read – write process, transaction processing , storing data leading to data integrity issues. A SQL suspect database can strike fear into any DBA, but there are steps to which can lead to decreased stress levels.
It is a major part of the DBA job to protect the data and establish countermeasures to the threat of database corruption.
What steps are you taking to protect SQL Server data?
1) What maintenance operations are you running to identify and resolve database corruption?
2) Do you have a list of best practises or a policy document detailing steps to take if corruption is suspected?
3) Are you and your team aware of common practises that make the problem worse, once corruption is identified?
4) Do you documented steps , recovery methods and necessary emergency contacts ?
5) Do you have a rock-solid backup strategy reflecting the critical recovery points of the organization? This is common DBA mistake - read more Top 10 DBA mistakes
Read More
SQL Server Database SUSPECT state - SQL Server DBA
7 Essential Steps to Recover a Corrupt SQL Server Database
Author: Tom Collins (http://www.sqlserver-dba.com)
Share:
Verify your Comment
Previewing your Comment
This is only a preview. Your comment has not yet been posted.
As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.
Having trouble reading this image? View an alternate.
Posted by: |