Script to Run DBCC CheckDB on Alternate SQL Server to Reduce Load
In this tip we look at some scripts you can use to automate running your DBCC CheckDBs on an alternate SQL Server instance.
Eric has been a SQL Server DBA and Architect in the legal, software, transportation, and insurance industries for over 10 years. Currently he is the Sr Data Architect for Squire Patton Boggs, a leading provider of legal services with 47 offices in 20 countries.
Eric is a 2018-2019 Idera Ace and has co-authored 2 Idera Whitepapers.
He has been a presenter at PASS Summit, IT/DevConnections, SQLSaturdays, the in.sight transportation conference, and the Ohio North SQL Server User's Group.
- MSSQLTips Awards: Author of the Year Contender - 2021, 2022 | Trendsetter (25+ tips) - 2021