How to fix Error 3710 on Windows Server 2025 / Windows 11

by

Troubleshooting Guide: Error 3710 – Cannot Detach Database in Minimally Configured Mode

Why This Error Happens

Error 3710 occurs because SQL Server 2025, when started in minimally configured mode (via the -f startup parameter), restricts certain operations to maintain a stable recovery environment, and detaching a database is explicitly blocked in this state. This mode is designed for emergency administration (such as resetting configuration options or recovering from startup failures), so the Database Engine intentionally limits actions that alter the physical state of the server, including detach, drop, or restore operations. Attempting to detach a database while the server is running this way triggers Error 3710 because the engine cannot guarantee a safe detach outside of normal operating mode.

Step-by-Step Resolution Guide

Step 1: Confirm the Server Is Running in Minimal Configuration Mode

  • Open SQL Server Configuration Manager on Windows Server 2025 / Windows 11.
  • Navigate to SQL Server Services, right-click your instance, and select Properties.
  • Check the Startup Parameters tab for the presence of -f.
  • Alternatively, run the following query in SQLCMD or Azure Data Studio to confirm minimal mode:
  SELECT SERVERPROPERTY('IsSingleUser') AS IsMinimalConfig;

Step 2: Remove the Minimal Configuration Startup Flag

  • Open SQL Server Configuration Manager.
  • Go to SQL Server Services > [Your Instance] > Properties > Startup Parameters.
  • Select the -f parameter and click Remove.
  • Click Apply, then restart the SQL Server service for changes to take effect:
  Restart-Service -Name 'MSSQLSERVER'

Step 3: Restart SQL Server in Normal Mode

  • Verify the service has restarted successfully using:
  Get-Service -Name 'MSSQLSERVER'
  • Confirm the instance is no longer in minimal configuration mode by re-running:
  SELECT SERVERPROPERTY('IsSingleUser') AS IsMinimalConfig;
  • Ensure the result returns 0, indicating normal operating mode.

Step 4: Detach the Database Using Standard Procedure

  • In SQL Server Management Studio (SSMS), right-click the target database.
  • Select Tasks > Detach.
  • Alternatively, run the detach command via T-SQL:
  EXEC sp_detach_db 'YourDatabaseName';
  • Confirm there are no active connections before detaching by checking:
  SELECT * FROM sys.dm_exec_sessions WHERE database_id = DB_ID('YourDatabaseName');

Alternative or Verification Steps

  • Verification: After detaching, confirm the database no longer appears in sys.databases by running SELECT name FROM sys.databases;.
  • Alternative: If the database still won’t detach due to active sessions, set it to single-user mode first using ALTER DATABASE YourDatabaseName SET SINGLE_USER WITH ROLLBACK IMMEDIATE; before attempting the detach again.