Troubleshooting Concepts (Database Engine)

In This Section

• Troubleshooting the Data Collector
  Provides information for troubleshooting common problems with the data collector.

• Troubleshooting Database Engine Connectivity
  Contains information about troubleshooting connections to the Database Engine.

• Troubleshooting Database Mail
  Provides information for troubleshooting common problems with Database Mail.

• Troubleshooting Database Mirroring Deployment
  Contains information to help you troubleshoot problems in setting up a database mirroring session.

• Troubleshooting Error 3313, 3314, 3414, or 3456 (SQL Server)
  Discusses possible responses to an error during a redo, undo, or recovery operation that places a SQL Server database into the SUSPECT state (error 3313, 3314, 3414, or 3456).

• Troubleshooting a Full Transaction Log (Error 9002)
  Discusses possible responses to a full transaction log and suggests how to avoid it in the future.

• Troubleshooting GROUP BY Errors
  Lists GROUP BY error messages and suggests resolutions

• Troubleshooting Insufficient Data Disk Space
  Discusses how to respond if the Database Engine lacks sufficient disk space for data files during recovery.

• Troubleshooting Insufficient Disk Space in tempdb
  Provides procedures and recommendations to help you diagnose and troubleshoot problems caused by insufficient disk space in the tempdb database.

• Troubleshooting Metadata Visibility
  Discusses how to troubleshoot problems with viewing metadata.

• Troubleshooting Orphaned Users
  Explains how to detect and resolve the situation in which the SQL Server login for a database user is undefined or is incorrectly defined on the server instance (creating an orphaned user).

• Troubleshooting Policy-Based Management Policies
  Contains information to help you troubleshoot policy failures and performance problems.

• Troubleshooting Protocol Errors During Database Engine Startup
  Discusses how to interpret error codes that you receive when the Database Engine encounters a protocol-related error during startup.

• Troubleshooting Queries
  Contains information about troubleshooting query problems in the Database Engine.

• Troubleshooting Query Notifications
  Provides troubleshooting information for common problems with query notifications.

• Troubleshooting Resource Governor
  Provides troubleshooting guidance for Resource Governor.

• Troubleshooting SQL Dependencies
  Describes common object dependency problems and their solutions.

• Troubleshooting SQL Mail
  Discusses how to troubleshoot common problems with SQL Mail.

• Troubleshooting the SQL Server Utility
  Describes how to troubleshoot common problems with the SQL Server Utility.

• Troubleshooting SQL Server Resource Health (SQL Server Utility)
  Provides information about mitigating resource health issues identified by a SQL Server UCP.

• Troubleshooting Data-tier Applications
  Discusses how to find error information about data-tier application management actions.

See Also

Reference

Concepts

Other Resources