Offload DBCC CHECKDB on Developer Edition

Håkan Ekman 0 Reputation points
2024-04-08T12:41:27.4866667+00:00

Hi

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,742 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Rahul Randive 8,521 Reputation points Microsoft Employee
    2024-04-08T13:01:11.8433333+00:00

    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!

    0 comments
  2. MikeyQiao-MSFT 560 Reputation points Microsoft Vendor
    2024-04-09T06:13:05.9333333+00:00

    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".

    0 comments