Offload DBCC CHECKDB on Developer Edition

Question

Hi

is it allowed to restore a database and run DBCC CHECKDB on a Developer Edition?

Answer 1

Hi，Håkan Ekman

DBCC means Database Console Commands for SQL Server.DBCC command relies on the SQL Server database engine.

Most basic DBCC commands are available across all versions, but commands related to specific advanced features may only be available in certain editions. For example, DBCC TRACEON for Trace Flags.

Certainly, the DBCC CHECKDB command is available in all mainstream versions of SQL Server.

However, you need to be mindful of whether you have sysadmin and db_owner permissions, the impact of DBCC CHECKDB on overall database performance, and the methods for handling corresponding errors.

Best regards,

Mikey Qiao

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Answer 2

Hi @Håkan Ekman

As per the Microsoft document, SQL Server Developer edition lets developers build any kind of application on top of SQL Server. It includes all the functionality of Enterprise edition, but is licensed for use as a development and test system, not as a production server.

Hence it should allow restore a database and run DBCC CHECKDB.

Thank You!