[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

DBCC CHECKDB Integrity Checks on SQL Azure Databases



Analysis Services
CLR Integration
High Availability
Open Source
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016

DBCC CHECKDB Integrity Checks on SQL Azure Databases

Date created: May 10, 2017.

By now, we all know we should maintain indexes and statistics on SQL Azure databases although it was considered by many Azure customers one of the benefits of migrating to SQL Azure databases. There are other tasks that Azure customers are responsible for running them on their own and database integrity checks are one of them, because Azure does not run integrity checks automatically.

DBCC CHECKDB should be executed during non-peak hours, on daily or weekly basics, or at least once a month.

To run DBCC CHECKDB using SQL Server Management Studio, open a query window on the database you want to run the integrity check, then proceed to execute the DBCC CHECKDB command as shown below:




.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.