Geek Answers Handbook

DBCC CHECKDB for Stretch-enabled Databases

I am exploring the capabilities of the SQL 2016 Stretch database. Just wondering when we execute the DBCC CHECKDB command for a database that supports stretching, then does it also check the remote copy of the database?

I tried to execute this command in a streaming enabled database in the two scripts below

  1. where is the Azure connection

  2. I restored the database so the connection to Azure was disconnected.

I was curious that in both of the above scenarios there are no errors in the DBCC command.

I did not find any MSDN articles on DBCC for the Stretch database. Please provide information on using DBCC on a Stretch DB.

+4
source share
1

DBCC CHECKDB Stretch. , physical_only Azure, . , , , . , , .

https://connect.microsoft.com/SQLServer/feedback/, , SQL- Azure (Stretch, DB DW).

+3

More articles:


All Articles