[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 DBCC CHECKDB Integrity Checks on SQL Azure Databases
 

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
Tips
Troubleshooting
Tuning

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.