DBCC CHECKDB
Sammi
Posts: 2 New member
in SQL Backup
I am not a DBA, so need help with a simple explanation of how I can run DBCC CHECKDB using Redgate SQL Backup Pro. Everything I have read online is too over my head to really understand what needs to happen and how it needs to happen. From what I've gathered, I need to restore the database before I can run DBCC CHECKDB? The product details state that it is included with the software so I am not sure if I am missing something.
Please help, thanks so much!!
Please help, thanks so much!!
Tagged:
Best Answers
-
Eddie D
Posts: 1,803 Rose Gold 5
Hi Sammi
Thank you for your support request.
Not sure what documentation you have read, in regards to your question, but there is no feature within SQL Backup Pro to run DBCC CHECKDB.
You will need to run DBCC CHECKDB as a new query in SSMS or a task outside of SQL Backup.
The link below is to Microsoft help article on running DBCC CHECKDB.
https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-checkdb-transact-sql
Many Thanks
Eddie -
PlantBasedSQL
Posts: 187 Gold 4
Hey Sammi, the documentation to support the SQL Backup Restore and to include DBCC CHECKDB can be found here: https://documentation.red-gate.com/sbu7/worked-examples/backup-verification
You can include the verification checks as part of an ad-hoc / scheduled restore - let me know how you get on!
Answers
Should I just run DBCC CHECKDB as a separate job prior to the backup job?
If I follow the steps listed in the instructions above, will I need a separate licensed SQL server?