So now that you have a documented, tested and implemented backup plan in place what is next?
Checking the health and integrity of your databases, much like your own there are ways sometimes to detect problems before they become big problems, not every problem, not every time but sometimes.
The most direct way of doing this is by running DBCC CHECKDB. It’s is the easiest, most direct way of looking for integrity issues but there are some things you need to keep in mind while running and when running DBCC.
In general DBCC CHECKDB will not find any issues because odds are you don’t have any issues but if you do see an issue reported by DBCC CHECKDB.
First, do not, I repeat, do not run DBCC Checkdb with any repair option unless instructed to do so by Microsoft or someone you trust implicitly. Do not take the advice given on some web page, blog or forum post that tells you to run any sort of repair stuff. Period, full stop. If you walk away with nothing else from this entire post, that is your take away…
Secondly, if anyone tells you to run DBCC CHECKDBwith a repair option take a backup first. Do not overwrite any existing backup, put the backup it it’s file and clearly name it so you know you took a backup of a potentially corrupt database. Yes, you are backing up a potentially corrupt database, but running any sort of fix may make things worse and you may want/need to have what you had before running any sort of fix.
Third, if DBCC CHECKDB does find an issue, run DBCC CHECKDB again while you Google the issue you found the first time. There is a chance the issue may not appear a second time, this is not generally true with DBCC CHECKDB, but it is worth trying. If it comes up clean a second time, then run it a third.
If you are still seeing errors then depending on the issue you may have to restore from backup, so get your backups ready and accessible if they are not already ready.
Finally, if recovering from a backup is not an option (too much data lost, etc) contact Microsoft Support for suggestions and next steps. Yeah it is going to cost you money, but it is money you are going to have to spend.