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.