How can we help you today? How can we help you today?

DBCC CHECKDB

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!!
Sam
0

Comments

3 comments

Sort by
  • Eddie D
    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
    Eddie D
    0
  • PlantBasedSQL
    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!
    PlantBasedSQL
    0
  • Sammi
    Thank you both for your answers. If I understand correctly, there is no method of having the program run DBCC CHECKDB prior to the backup is run. We were using Backup Exec before and there was an option to run this prior to running backups. Our DBA told me to ensure I am running this before the backup. What are my options?

    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?
    Sammi
    0

Add comment

Please sign in to leave a comment.