Operations & Administration
Practical operational guides covering SQL Server administration, monitoring, performance tuning, migration, high availability, and configuration management.
Ssms
No description available.
This walkthrough demonstrates the steps used to create a SQL Server code analysis rule. The
The provided code analysis rules report on Transact-SQL design, naming, and performance warnings in your database code.
No description available.
Creating a new SDK-style SQL project is a quick task . However, if you have existing SQL p
The development cycle of a SQL database project enables database development to be integrate
A data-tier application (DAC) is a logical database entity that defines all of the SQL Server
No description available.
You can delete a registered data-tier application by using the Delete Data-tier Application
No description available.
No description available.
Exporting a database creates an export file that includes the definitions of the objects in t
No description available.
No description available.
Import a file - to create a copy of the original database, with the data, on a new instance
No description available.
No description available.
No description available.
Pre-deployment and post-deployment scripts are SQL scripts that are included in the project t
SQL projects properties In addition to the contents of the individual files, SQL database p
With project references in SQL database projects, you can create dependencies between your S
A publish profile is a file that stores deployment configuration for a SQL project. Publish
No description available.
No description available.
No description available.
The .NET Data-tier Application Framework (DacFx) library provides extensibility points that you can use to modify the behavior of the build and deployment actions for database
No description available.
SQL projects tools Tooling for SQL projects is available in several development environments and command line interfaces. The primary tools for SQL projects are the SqlPackage command line utility
No description available.
No description available.
The target platform setting is a project property that is used during project build to valida
The SQL project build output provides feedback on the database model construction and T- SQL validation.
A data-tier application (DAC) is a self-contained unit of the entire database model and is portable in an artifact known as a DAC package, or . It's a good practice to review the contents of a bef
No description available.
ﾃ Summarize this article for me SQL database projects support automatic generation of XML s
Profiler
ﾃ Summarize this article for me Use the SQL Database Projects extension for Visual Studio Code to add common database objects to your project using item templates. Item templates generate properly
06/06/2025 Use SQL Server Profiler to identify the cause of a deadlock.
No description available.
While the SQL Database Project extension in provides a graphical user interface to build SQL database projects , a command line build experience is also available for Windows, macOS, and Linux en
06/06/2025 This article describes how to clear the trace window for a trace that is running by using SQL Server Profiler. 1.
06/06/2025 This article describes how to close the trace window for traces that are running or for saved traces you're viewing by using SQL Serve
SQL Bindings for Visual Studio Code lets you develop Azure Functions with Azure SQL bindings.
Quickstart: Connect to and query a database In this quickstart, you learn how to use the MSSQL extension for Visual Studio Code to connect to a database, whether it's running locally, in a container
No description available.
06/06/2025 Using SQL Server Profiler, you can open a Microsoft Windows performance log, choose the counters you want to correlate with a trace, a
06/06/2025 This article describes how to create a new trace template by using SQL Server Profiler. 1. On the menu, point to , and then select
06/06/2025 This article describes how to create a Transact-SQL script from an existing trace file or table by using SQL Server Profiler. 1. Open
06/05/2025 This article describes how to use SQL Server Profiler to create a trace. 1. On the menu, select , and connect to an instance of SQL
The MSSQL extension for Visual Studio Code includes an integrated UI for Data API builder , so you can create REST, GraphQL, and MCP endpoints for your SQL database tables without writing configur
The Data-tier Application experience provides an easy-to-use experience to deploy and extract files and import and export files. This experience makes it easier to manage and files. It simplifies
The MSSQL extension for Visual Studio Code provides built-in tools for common database operations. You can create and manage databases, search for objects, back up and restore databases, and import
06/06/2025 This article describes how to create a trace template from an existing trace while it's running by using SQL Server Profiler. 1. If n
06/06/2025 This article describes how to create a trace template from an existing trace file or table by using SQL Server Profiler. 1.
06/06/2025 This article describes how to export an existing trace template to save as a template file (.tdf) by using SQL Server Profiler. When y
ﾃ Summarize this article for me This article provides a brief explanation of the various downloads a
No description available.
The MSSQL extension for Visual Studio Code supports connecting to SQL database in Microsoft Fabric. The Connection dialog includes a Fabric connectivity option that you use to sign in using Microsof
06/06/2025 This article describes how to filter trace events based on the event ending time by using SQL Server Profiler. 1.
06/06/2025 This article describes how to filter trace events based on the event start time by using SQL Server Profiler. 1. On the menu, select
06/05/2025 Filters limit the events collected in a trace.
06/06/2025 This article describes how to filter session identifiers (SPIDs) in a trace by using SQL Server Profiler. 1. On the menu, select ,
06/06/2025 This article describes how to search for a specific value or data column in the trace output while the trace is running by using SQL S
SqlToolsVSNativeHelpers - Property that specifies whether a given window frame is visible. The helper method is used from managed
Quickstart: Generate code In this quickstart, you learn how GitHub Copilot accelerates SQL and object-relational mapping (ORM) development by generating context-aware code directly within Visual Stu
Quickstart: Generate data for testing and In this quickstart, you learn how to use GitHub Copilot to create realistic and themed datasets to support application development, testing, and demos. By a
06/06/2025 This article describes how to import a trace template file (.tdf) by using SQL Server Profiler. 1.
This article outlines the limitations and known constraints of GitHub Copilot integration with the MSSQL extension for Visual Studio Code. This experience is designed for application developers buil
With the Local SQL Server container feature in the MSSQL extension for Visual Studio Code, you can create and manage SQL Server containers without manually running Docker commands. Containers can be
06/06/2025 You can modify templates that are saved in a file on the local computer on which SQL Server Profiler is running. You can also modify t
06/05/2025 You add filters to trace templates, which contain the trace definitions, to limit the number of events gathered by a trace. Limiting t
SQL Bindings for Visual Studio Code lets you develop Azure Functions with Azure SQL bindings.
06/06/2025 This article describes how to open a trace file by using SQL Server Profiler. 1. On the menu, select , and then select . 2.
06/06/2025 This article describes how to open an existing trace table by using SQL Server Profiler. 1. On the menu, point to , and then select
06/06/2025 You can group data columns in a trace by selecting in the trace table or dialog box, or when you define a trace.
06/06/2025 Pausing a trace prevents further event data from being captured until the trace is restarted.
Profiler templates and 06/06/2025 SQL Server Profiler shows how SQL Server resolves queries internally.
No description available.
Use the SQL Database Projects extension for Visual Studio Code to deploy database schema changes directly from a SQL project. A SQL project deployment takes the schema you define in the project, com
The Query Profiler in the MSSQL extension for Visual Studio Code captures and monitors database activity in real time using Extended Events . You can observe live T-SQL activity, identify slow ope
06/06/2025 This article describes how to replay one event at a time in a replay trace file or table by using SQL Server Profiler. 1.
06/06/2025 When you test possible solutions to a performance problem, use SQL Server Profiler to replay Transact-SQL scripts, and compare perform
06/06/2025 Replay is the ability to open a saved trace and replay it again.
06/06/2025 Replay is the ability to open a saved trace and replay it again.
06/06/2025 Before replaying a captured trace with SQL Server Profiler, specify replay options in the dialog box.
06/05/2025 In order to replay trace data with SQL Server Profiler or the Distributed Replay Utility, a specific set of event classes and columns
06/06/2025 This article describes how to set breakpoints in a trace file or table that you want to replay by using SQL Server Profiler. Setting b
06/06/2025 This article describes how to replay trace files or tables that pause when a cursor is reached by using SQL Server Profiler. Pausing t
06/06/2025 Replay is the ability to reproduce activity that has been captured in a trace.
06/06/2025 This article describes how to start a trace again after it has been paused or stopped by using SQL Server Profiler. 1.
06/06/2025 You can run SQL Server Profiler in several different ways, to support gathering trace output in various scenarios. You can start SQL S
06/06/2025 This article describes how to save trace results to a file by using SQL Server Profiler. 1. On the menu, select , and then connect t
06/06/2025 This article describes how to save trace results to a database table by using SQL Server Profiler. 1.
06/06/2025 It's important to distinguish saving trace files from saving trace templates. Saving a trace file involves saving the captured event d
This article provides an overview of the Schema Compare feature for the MSSQL extension in Visual Studio Code. Schema Compare compares two database definitions, and applies the differences from the
The Schema Designer in the MSSQL extension for Visual Studio Code provides a graphical environment for visualizing, designing, and managing database schemas without writing Transact-SQL (T-SQL) stat
The Schema Designer in the MSSQL extension for Visual Studio Code includes GitHub Copilot integration, so you can design, modify, and validate database schemas using natural language. Describe what
06/06/2025 Use the following procedure to set the maximum file size for a trace file. 1. On the menu, select , and then connect to an instance
06/06/2025 This article describes how to set a maximum table size for trace tables by using SQL Server Profiler. 1.
06/06/2025 This article describes how to set options that apply to all traces that are created with a specific instance of SQL Server Profiler.
06/06/2025 The trace definition default is the default trace template that is used for each provider or server. You can set default trace templat
06/06/2025 This article describes how to set tool options, which specify the font types, size, and style that SQL Server Profiler uses to display
06/06/2025 This article describes how to specify event classes and data columns for traces by using SQL Server Profiler. 1. On the or dialog b
SQL Notebooks (preview) SQL Notebooks in the MSSQL extension for Visual Studio Code provide notebook-based SQL development using native Visual Studio Code Jupyter notebooks. You can combine interact
SqlToolsVSNativeHelpers Library that supports SQL Server functionality in Visual Studio.
No description available.
06/06/2025 This article describes how to start traces automatically after connecting to an instance of SQL Server by using SQL Server Profiler.
06/06/2025 This article describes how to stop a trace that is running by using SQL Server Profiler. Stopping a trace stops data from being captur
Profiler Templates 06/06/2025 You can use SQL Server Profiler to create templates that define the event classes and data columns to i
The Azure Data Studio Migration feature in the MSSQL extension for Visual Studio Code helps you transition from Azure Data Studio to the MSSQL extension by importing existing connections, connection
Quickstart: Use GitHub Copilot Agent Agent Mode allows GitHub Copilot to use the tools available in the MSSQL extension for Visual Studio Code. When the extension is installed and active, Copilot ca
Quickstart: Use chat and inline GitHub GitHub Copilot provides both inline suggestions while typing in the code editor and an interactive chat experience. You can ask the chat participant questions
Quickstart: Use GitHub Copilot slash GitHub Copilot slash commands provide a quick, discoverable way to interact with your SQL Server databases directly from the GitHub Copilot chat in Visual Studio
Quickstart: Use the smart query builder In this quickstart, you learn how the query building assistant helps you craft efficient, accurate, and secure queries using either raw SQL or your preferred
Quickstart: Use the business logic explainer In this quickstart, you learn how the business logic explainer helps developers understand and work with complex application logic implemented in SQL, ob
Quickstart: Localization and formatting GitHub Copilot helps developers build globally aware applications by addressing localization and formatting needs directly within SQL and ORM-based workflows.
Quickstart: Query optimizer assistant GitHub Copilot helps developers optimize queries and analyze performance bottlenecks without needing expertise in database internals, especially developers with
Quickstart: Use the schema explorer and In this quickstart, you learn how GitHub Copilot assists developers in designing, understanding, and evolving database schemas with context-aware suggestions.
Quickstart: Security analyzer GitHub Copilot helps developers identify and address common security risks in SQL code and application-layer queries. It detects vulnerabilities like SQL injection, ove
06/06/2025 Use SQL Server Profiler to view captured event data in a trace. SQL Server Profiler displays data based on defined trace properties. O
06/06/2025 This article describes how to view filters on data columns for event classes by using SQL Server Profiler. 1.
Sqlpackage
SqlPackage CLI reference SqlPackage is a command-line utility for database portability and deployments in Windows, Linux, and macOS environments. The SqlPackage command-line interface (CLI) parses e
ﾃ Summarize this article for me SqlPackage runs on Windows, macOS, and Linux, and is available to install through or as a standalone zip download. For details about the latest release, see the rel
This article lists the features and fixes delivered by the released versions of SqlPackage. The column in each section is scoped as follows: SqlPackage CLI - command-line actions (publish, import,
This article lists the features and fixes delivered by the released versions of SqlPackage. For the latest version information, see Release notes for SqlPackage . The column in each section is sc
SqlPackage deploy report and drift report 07/30/2025 The SqlPackage DeployReport action creates an XML report of the changes that would be made by a publish action. The SqlPackage DriftReport a
SqlPackage Export parameters and properties 07/28/2025 The SqlPackage Export action exports a connected database to a BACPAC file (.bacpac). By default, data for all tables will be included in the
SqlPackage Extract parameters and properties Article • 04/15/2025 The SqlPackage Extract action creates a schema of a connected database in a DACPAC file (.dacpac). By default, data isn't include
SqlPackage for Azure Synapse Analytics This article covers SqlPackage support for .
SqlPackage Import parameters and properties Article • 11/21/2024 The SqlPackage Import action imports the schema and table data from a BACPAC file (.bacpac) into a new or empty database in SQL Se
SqlPackage in development pipelines 06/27/2025 SqlPackage is a command-line utility that automates several database development tasks and can be incorporated into CI/CD pipelines. If SqlPackage i
SqlPackage Publish parameters, properties, and SQLCMD variables 07/30/2025 The SqlPackage publish operation incrementally updates the schema of a target database to match the structure of a source
SqlPackage Script parameters and properties 07/30/2025 The SqlPackage Script action creates a Transact-SQL incremental update script that updates the schema of a target database to match the schema
SqlPackage with data in Parquet files 07/30/2025 This article covers SqlPackage support for interacting with data stored in Azure Blob Storage that is in Parquet format. With extract , the datab
SqlPackage In some scenarios, SqlPackage operations take longer than expected or fail to complete. This article describes some frequently suggested tactics to troubleshoot or improve performance of
Linux Operations
07/03/2025 - Linux This article provides an overview of Active Directory authentication for SQL Server on Linux. Active Directory authentication is also known as Integrated
availability basics for Linux on Linux Starting with SQL Server 2017 (14.x), SQL Server is supported on both Linux and Windows.
on Linux This article shows how to use the bcp utility to bulk copy data between an instance of SQL Server on Linux and a data file in a user-specified format.
on Linux This guide provides instructions to create a two-node shared disk cluster for SQL Server on SUSE Linux Enterprise Server (SLES). The clustering layer is based on SU
on Linux This guide provides instructions to create a two-node shared disk failover cluster for SQL Server on Red Hat Enterprise Linux. The clustering layer is based on Red
No description available.
07/03/2025 - Linux This article explains how to create a SQL Server Always On Availability Group (AG) on Linux without a cluster manager. This architecture provides read-s
on Linux This article describes how to create a SQL Server Always On availability group (AG) for high availability on Linux. There are two configuration types for AGs.
on Linux This article explains how you can configure and customize SQL Server Linux containers using Docker.
No description available.
2017 (14.x) and later versions This article explains the steps to create an Always On availability group (AG) with one replica on a Windows server and the other replica on a
No description available.
07/03/2025 - Linux This article provides an example of how to prepare a machine key for SQL Server running on Linux in a contained availability group (AG). A contained AG
on Linux This article describes how to configure the Microsoft Distributed Transaction Coordinator (MSDTC) on Linux. MSDTC on Linux is supported on SQL Server 2017 (14.x) C
on Linux When an Always On availability group (AG) or failover cluster instance (FCI) spans more than one site, each site usually has its own networking, which often means t
on Linux This article describes how to create a three-node cluster on Linux using Pacemaker, and add a previously created availability group as a resource in the cluster. Fo
on Linux on Linux This article describes how to configure the persistent memory (PMEM) for SQL Server 2019 (15.x) and later versions on Linux. SQL Server 2019 (
07/03/2025 SQL Server 2019 (15.x) and later - Linux SQL Server Reporting Services (2019 and later) This article explains how to install and configure the Power BI Report Server (PBIRS
on Linux This article describes how to configure the correct repository for installing and upgrading SQL Server 2025 (17.x) on Red Hat Enterprise Linux (RHEL) and Ubuntu. F
on Linux This article describes how to configure the correct repository for installing and upgrading SQL Server 2017 (14.x), SQL Server 2019 (15.x), and SQL Server 2022 (16.
on Linux You run the configuration script when you install SQL Server Integration Services (SSIS) for Red Hat Enterprise Linux and Ubuntu. For more info about installing SS
2025 (17.x) - Linux This article guides you to enable and run database files on the filesystem in SQL Server 2025 (17.x). SQL Server on Linux and containers traditionally
07/03/2025 - Linux This article describes how to configure the time zone for SQL Server 2017 (14.x) on Linux.
07/03/2025 - Linux This article describes how to configure the time zone for SQL Server 2019 (15.x) on Linux.
07/03/2025 - Linux This article describes how to configure the time zone for SQL Server 2022 (16.x) and later versions on Linux. You can also configure the time zone on Lin
on Linux By default, Microsoft collects information about how its customers use SQL Server. Specifically, SQL Server collects information about the installation experience,
on Linux This article explains how to configure a SQL Server Always On availability group (AG) on Linux using custom high availability and failover logic. This architecture
on Azure VM This tutorial explains how to configure a SQL Server Always On availability group with DH2i DxEnterprise running on Linux-based Azure Virt
on Linux This tutorial explains how to configure SQL Server availability groups with HPE Serviceguard for Linux, running on on-premises virtual machines (VMs) or in Azure-ba
on Linux is a configuration script that installs with SQL Server for Red Hat Enterprise Linux, SUSE Linux Enterprise Server, and Ubuntu.
No description available.
on Linux SQL Server 2017 (14.x) containers start up as the root user by default, which can cause some security concerns. This article talks about security options that you h
on Linux SQL Server jobs are used to regularly perform the same sequence of commands in your SQL Server database. This tutorial provides an example of how to create a SQL Se
on Linux This tutorial shows how to create and configure an availability group (AG) for SQL Server on Linux. Unlike SQL Server 2016 (13.x) and earlier versions on Windows, y
10/20/2025 - Linux This article presents supported deployment configurations for SQL Server Always On availability groups on Linux servers. An availability group supports h
2025 (17.x) This article describes how you can use PolyBase services with SQL Server on Linux. Beginning with SQL Server 2025 (17.x), deployments on Linux can use ODBC data s
07/03/2025 - Linux This article shows how to set up Database Mail and use it with SQL Server Agent ( ) on Linux. SQL SQL Ｕ Caution
on Linux This tutorial describes the tasks required to deploy a Linux Pacemaker cluster for a SQL Server Always On availability group (AG) or failover cluster instance (FCI)
- Linux This tutorial explains how to configure SQL Server Always On availability groups (AGs) for SQL Server Linux based containers deployed to an A
on Linux This tutorial explains how to configure SQL Server Always On availability groups (AGs) for SQL Server Linux based containers deployed to an Azure Kubernetes Service
on Linux This tutorial provides instructions on setting up SQL Server configured with Always On availability groups (AGs) in an Azure Kubernetes Service (AKS) cluster.
on Linux This article explains how to deploy and connect to SQL Server Linux containers. For other deployment scenarios, see: Windows Linux Container cluster on Azure Th
No description available.
No description available.
No description available.
on Linux This tutorial walks you through manually enabling Microsoft Entra ID authentication for SQL Server running in containers. Because Azure Arc doesn't currently suppor
on Linux SQL Server on Linux can use Transport Layer Security (TLS) to encrypt data that is transmitted across a network between a client application and an instance of SQL
on Linux You can use several different environment variables to configure SQL Server on Linux.
07/03/2025 - Linux This article shows how to use SQL Server Management Studio (SSMS) and SqlPackage to export and import a database on SQL Server on Linux. SSMS and Sql
on Linux This article explains the concepts related to SQL Server failover cluster instances (FCI) on Linux.
on Linux This article describes limitations and known issues for SQL Server Integration Services (SSIS) on Linux.
on Linux If you're a Linux user who is new to SQL Server, the following tasks walk you through some of the performance features.
on Linux - Linux If you're a Linux user who is new to SQL Server, the following tasks walk you through some of the security tasks. These
This article helps you get started with SQL Server as a confined service on a Security-Enhanced Linux (SELinux) distribution based on Red Hat Enterprise Linux (RHEL). Security-Enhanced Linux (SELi
on Linux This article contains best practices and guidance for running SQL Server containers on Kubernetes with StatefulSets. We recommend deploying one SQL Server container
Quickstart: Install SQL Server and create a on Linux In this quickstart, you install SQL Server 2025 (17.x) on Red Hat Enterprise Linux (RHEL) 9.x or 10.x. Then you connect
Quickstart: Install SQL Server and create a on Linux In this quickstart, you install SQL Server 2025 (17.x) on Ubuntu 22.04.
No description available.
on Linux This article describes how to enable or install the SQL Server Agent on Linux. The SQL Server Agent runs scheduled SQL Server jobs. Starting with SQL Server 2017
on Linux The following steps install Full-Text Search ( ) on Linux.
- Linux Follow the steps in this article to install SQL Server Integration Services ( ) on Linux. For more information about the features that are supported in Integration
07/11/2025 SQL Server 2019 (15.x) - Linux and later versions Learn how to install the Java Language Extension component for SQL Server on Linux. The Java Language Extension is part o
on Linux The following steps install the command-line tools, Microsoft ODBC drivers, and their dependencies. The package contains: : Command-line query utility.
on Linux The tool is a command-line interface (CLI) utility for configuring and managing Windows Active Directory domains for SQL Server on Linux and containers. It elimina
on Linux on Linux This article explains how to configure iSCSI storage for a failover cluster instance (FCI) on Linux.
on Linux This article provides general guidance on how to join a SQL Server Linux host machine to an Active Directory domain.
SQL Server on Linux: Known issues The following sections describe known issues with SQL Server on Linux. The following table lists the most common issues with SQL Server on Linux. The length of the
on Linux frequently asked on Linux The following sections provide common questions and answers for SQL Server running on Linux. 1.
07/03/2025 - Linux This article describes how to start, stop, or restart the SQL Server Database Engine and SQL Server Agent on Linux by using the command line, or Transact
on Linux SQL Server's backup and restore feature is the recommended way to migrate a database from SQL Server on Windows to SQL Server on Linux. In this tutorial, you walk t
on Linux This tutorial demonstrates how to move and restore a SQL Server backup file into a SQL Server 2025 (17.x) Linux container image running on Docker.
07/03/2025 - Linux This article introduces SQL Server Migration Assistant that helps you easily migrate databases to SQL Server on Linux from Microsoft Access, DB2, MySQL
Tutorials, quickstarts, and other educational resources meant to teach you to work with SQL Server on Linux for users who are familiar with SQL Server but new to Linux. ｄ Introduction to Linux ｄ
on Linux This article provides a learning path through an introduction to Linux concepts. Use the sections in the article as a guided learning path to familiarize yourself w
Tutorials, quickstarts, and other educational resources meant to teach you to work with SQL Server on Linux for users who are familiar with Linux. ｄ What is a database? System databases Database
on Linux 07/03/2025 - Linux This article explains how to configure NFS storage for a failover cluster instance (FCI) on Linux. NFS, or network file system, is a
on Linux You can configure replication with SQL Server on Linux instances listening on any port configured with the mssql-conf setting.
on Linux This document describes how to do the following tasks for SQL Server on a shared disk failover cluster with Red Hat Enterprise Linux. Manually fail over the cluste
07/03/2025 - Linux Before you upgrade an availability group, review the patterns and practices at Upgrade availability group replicas .
on Linux This article explains how to operate a SQL Server failover cluster instance (FCI) on Linux. If you haven't created a SQL Server FCI on Linux, see Configure failove
on Linux Starting with SQL Server 2017 (14.x), SQL Server is supported on both Linux and Windows. Like Windows-based SQL Server deployments, SQL Server databases and instanc
in the Azure portal SQL Server on Azure VM In this quickstart tutorial, you use the Azure portal to create a Linux virtual machine with SQL Server 2017 installed.
on Linux This sample bash script installs SQL Server on Red Hat Enterprise Linux (RHEL) without interactive input.
on Linux Under certain circumstances, you might need to restore the database on an instance of SQL Server in single-user mode on Linux.
on Linux Based on your organization's security best practices, you might be required to rotate the password regularly for the Windows Active Directory account provided as i
Quickstart: Run SQL Server in the cloud on Linux In this quickstart, you install SQL Server on Red Hat Enterprise Linux (RHEL), SUSE Linux Enterprise Server (SLES), or Ubun
Quickstart: Run SQL Server Linux container on Linux In this quickstart, you use Docker to pull and run the SQL Server 2025 (17.x) Linux container image, mssql-server-linux
on Linux When you run SQL Server Integration Services (SSIS) and SQL Server on Windows, you can automate the execution of SSIS packages by using SQL Server Agent. When you r
SQL Server on Linux - Security and 10/15/2025 This article describes the required service accounts, and file system permissions for SQL Server on Linux. For more information about SQL Server on Win
2022 (16.x) and later versions on Linux This article describes how to set up and manage password policies for SQL Server logins on Linux. Custom password policies are availab
on Linux This tutorial explains how to configure SQL Server on Linux containers to support Active Directory authentication, also known as integrated authentication. For an o
- Linux This article explains how to configure SMB storage for a failover cluster instance (FCI) on Linux.
on Linux The snapshot folder is a directory that you have designated as a share; agents that read from and write to this folder must have enough permissions to access it. B
SQL Assessment API The SQL Assessment API provides a mechanism to evaluate the configuration of your SQL Server for best practices.
- Linux This article provides details of features supported by the various editions of SQL Server 2017 (14.x) on Linux.
2017 (14.x) on Linux The following release notes apply to SQL Server 2017 (14.x) running on Linux. This article is broken into sections for each release. For detailed support
2017 (14.x) on Linux This article describes the major features and services available for SQL Server 2017 (14.x) running on Linux.
The following table lists the release history for SQL Server 2017 (14.x). CU 31 GDR (May 2026) 14.0.3530.2 2026-05-12 CU 31 GDR (Apr 2026) 14.0.3525.1 2026-04-14 CU
- Linux This article provides details of features supported by the various editions of SQL Server 2019 (15.x) on Linux.
2019 (15.x) on Linux The following release notes apply to SQL Server 2019 (15.x) running on Linux. This article is broken into sections for each release. For detailed support
2019 (15.x) on Linux This article describes the major features and services available for SQL Server 2019 (15.x) running on Linux.
The following table lists the release history for SQL Server 2019 (15.x). CU 32 GDR (May 2026) 15.0.4470.1 2026-05-12 CU 32 GDR (Apr 2026) 15.0.4465.1 2026-04-14 CU
on Linux This article provides details of features supported by the various editions of SQL Server 2022 (16.x) on Linux. For editions and supported features of SQL Server o
2022 (16.x) on Linux The following release notes apply to SQL Server 2022 (16.x) running on Linux. This article is broken into sections for each release. For detailed support
2022 (16.x) on Linux This article describes the major features and services available for SQL Server 2022 (16.x) running on Linux.
The following table lists the release history for SQL Server 2022 (16.x). CU 24 GDR (May 2026) 16.0.4252.3 2026-05-12 CU 24 GDR (Apr 2026) 16.0.4250.1 2026-04-14 CU
on Linux This article provides details of features supported by the various editions of SQL Server 2025 (17.x) on Linux. For editions and supported features of SQL Server o
2025 (17.x) on Linux The following release notes apply to SQL Server 2025 (17.x) running on Linux. This article is broken into sections for each release. For detailed support
2025 (17.x) on Linux This article describes the major features and services available for SQL Server 2025 (17.x) running on Linux.
The following table lists the release history for SQL Server 2025 (17.x). CU 4 GDR (May 2026) 17.0.4040.1 2026-05-12 CU 4 17.0.4035.5 2026-04-16 CU 3 GDR (Apr 2026)
No description available.
No description available.
on Linux This sample bash script installs SQL Server 2022 (16.x) on SUSE Linux Enterprise Server (SLES) without interactive input. It provides examples of installing the Dat
- Linux This article helps you troubleshoot Active Directory Domain Services authentication issues with SQL Server on Linux and containers. It includ
on Linux This article talks about common errors seen when deploying and using SQL Server Docker containers, and provide troubleshooting techniques to help resolve the issue.
on Linux This article describes how to troubleshoot SQL Server running on Linux or in a Linux container.
on Linux This sample bash script installs SQL Server on Ubuntu without interactive input. It provides examples of installing the Database Engine, the SQL Server command-line
on Linux This article provides you details on how Active Directory authentication works for SQL Server deployed on Linux or containers.
To minimize downtime and risk, you should consider several approaches when planning to upgrade the SQL Server Database Engine from an earlier release of SQL Server on Linux. Upgrade in place Minute
on Linux This tutorial explains how to configure SQL Server on Linux to support Active Directory authentication, also known as integrated authentication.
on Linux This tutorial explains how to configure Windows Active Directory authentication for SQL Server on Linux using . For another method of configuring Active Directory
on Linux Log shipping is a SQL Server high availability (HA) configuration where a database from a primary server is replicated onto one or more secondary servers.
Linux containers 07/03/2025 - Linux This article explains how to set up SQL Server Linux containers for distributed transactions, including special requirements
07/11/2025 - Linux This article introduces SQL Server PowerShell and walks you through a couple of examples on how to use it with PowerShell on macOS and Linux. PowerShel
No description available.
on Linux This article introduces SQL Server Management Studio (SSMS) and walks you through a few common tasks. SSMS is a Windows application, so use SSMS when you have a W
Quickstart: Connect to and query a database In this quickstart, you learn how to use the MSSQL extension for Visual Studio Code to connect to a database, whether it's running locally, in a container
on Linux 07/03/2025 - Linux This article introduces SQL Server PowerShell and walks you through a couple of examples on how to use it with SQL Server on Linux
No description available.
Azure Synapse
This article lists the server and database roles and mappings that the installation of Azure extension for SQL Server creates. When you install Azure extension for SQL Serve
enabled by Azure Arc The best practices assessment feature provides a mechanism to evaluate the configuration of your SQL Server instanc
You can configure automatic updates for SQL Server enabled by Azure Arc. Automatic updates: Establish a maintenance window for an Azure Arc-enabled SQL Server instance. Work
enabled by Azure Arc 06/30/2025 The Azure extension for SQL Server can perform backups automatically to local storage or network shares. Backups are written to t
No description available.
No description available.
No description available.
enabled by Azure Arc SQL Server 2025 (17.x) This article describes how to use a managed identity to back up and restore databases with Azure Blob storage using SQL Server e
08/28/2025 On SQL Server enabled by Azure Arc, Azure extension for SQL Server can automatically rotate certificates for Microsoft Entra ID for service managed certificates a
This article teaches you how to view client connections to SQL Server enabled by Azure Arc in Azure portal. To collect client connection data for SQL Server enabled by Azure
You can configure your instance of SQL Server enabled by Azure Arc with Microsoft Defender for Cloud by following these steps. Your Windows-based SQL
The information security principle of least privilege asserts that accounts and applications only have access to the data and operations they require. With SQL Server enabled
: SQL Server 2025 (17.x) SQL Server 2025 introduces managed identity support for linked servers, enabling secure, credential-free authentication between SQL Server instances.
Each Azure Arc-enabled server includes a set of properties that apply to all SQL Server instances installed on that server. You can configure these properties after Azure Ext
SQL Server enabled by Azure Arc 07/03/2025 This article describes how to configure communication for a SQL Server enabled by Azure Arc instance so that it connects to Azure without going over inter
This article explains how to connect your SQL Server instance to Azure Arc on an Arc-enabled server. For example, you need to use this method to connect a SQL Server instance
This article explains how to connect your SQL Server instance to Azure Arc. Before you proceed, complete the Prerequisites - SQL Server enabled by Azure Arc .
This article describes the data that SQL Server enabled by Azure Arc transmits to Microsoft. Specifically: SQL Server enabled by Azure Arc collects u
Azure Arc automatically installs the Azure extension for SQL Server when a server connected to Azure Arc has SQL Server installed. All the SQL Server instance resources are a
enabled by Azure Arc automatically produces an assessment for migration to Azure.
SQL Server enabled by Azure Arc Index of articles about SQL Server enabled by Azure Arc. ｅ ｐ SQL Server best practices assessment Secure SQL Server instances Auto backups Video - Data Exposed
09/21/2025 The Defender for SQL Servers on Machines plan is one of the Defender for Databases plans in Microsoft Defender for Cloud. Use Defender for SQL Servers on Machines to protect SQL virtual
Extended Security Updates SQL Server 2014 (12.x) This article explains how to manage a SQL Server subscription to Extended Security Updates enabled by Azure Arc.
ﾃ Summarize this article for me This article provides information about known issues associated with SQL Server enabled by Azure Arc. If a database isn't online and updatable, required permissions
This article explains how to manage licensing and billing of SQL Server enabled by Azure Arc. SQL Server enabled by Azure Arc directly supports only the core-based licensing methods. For information
06/10/2025 An Always On availability group is an enterprise level high availability and disaster recovery solution for SQL Server. This article describes how to manage a SQL
instances are automatically connected to Azure Arc when they are installed on an Azure Arc-enabled Server and the Arc server resource is in a supported region .
This article explains how to transition the SQL Server instances to pay-as-you-go subscriptions. This option is available for instances of SQL Server that currently: Use a SQL Server license with So
2025 (17.x) This article shows you how to use managed identities for Extensible Key Management (EKM) with Azure Key Vault (AKV) on SQL Server enabled by Azure Arc . Starti
2025 (17.x) SQL Server 2025 (17.x) includes managed identity support for SQL Server on Windows. Use a managed identity to interact with resources in Azure by using Microsoft
This article shows you how to perform a SQL Server migration in Azure Arc to Azure SQL Managed Instance in the Azure portal for your SQL Server instance enabled by Azure A
This article shows you how to perform a SQL Server migration in Azure Arc to SQL Server on Azure VMs in the Azure portal for your SQL Server instance enabled by Azure Arc
The migration dashboard is a convenient view that shows all instances of SQL Server enabled by Azure Arc and their migration readiness. SQL Server enabled by Azure Arc automa
You can monitor SQL Server enabled by Azure Arc by using the performance dashboard in the Azure portal. Performance metrics are automatically collecte
09/30/2025 This article describes how you can move resources to a new resource group or subscription with SQL Server enabled by Azure Arc. The capability applies to both: SQL Server instances Data
This article demonstrates how to restore a database to a point-in-time as a new database on the same instance of SQL Server enabled by Azure Arc. The
No description available.
migration in Azure Arc This article helps you prepare your environment for a Log Replay Service (LRS) migration of your SQL Server instance enabled by Azure Arc
No description available.
This article shows how to register an Azure Arc-enabled SQL Server instance. It also shows how to authenticate and interact with Azure Arc-enabled SQL Server in Microsoft Pur
This article lists: Features in preview Features that have reached general availability (GA) within the last 12 months Release dates Azure extension for SQL Server version
This article lists the permissions the Azure Extension for SQL Server grants to the account when you use least privilege for SQL Server instances enabled by A
on Azure VM This article provides an overview of SQL Server on Azure Virtual Machines (VMs) on the Windows platform.
This article lists system objects that Azure extension for SQL Server deploys and manages.
Before you proceed, verify all the necessary are met. The extension log file is at: The log file name depends on the version Azure Exten
ﾃ Summarize this article for me This article helps you troubleshoot common issues you might encounter when migrating SQL Server databases to Azure SQL Managed Instance by using SQL Server migration
06/30/2025 In addition to the usual endpoints, the Azure Arc extension for SQL Server connects to two other endpoints: Data processing service (DPS) endpoint The collected
Before you start, note the logs locations.
This article describes ways to identify unhealthy extensions that aren't installed correctly, running properly, or not connected to Azure. You can use the built-in extensio
SQL Server enabled by Azure Arc in US This article describes features and limitations currently available for SQL Server enabled by Azure Arc on US Government regions. It also: Points to instructio
06/24/2025 Activity logs for SQL Server enabled by Azure Arc provide insight into events related to SQL Server enabled by Azure Arc and View Azure Arc-enabled inventory
Azure portal provides information about SQL Server failover cluster instances when they are enabled by Azure Arc. The Azure SQL extension agent must b
When SQL Server engine instances or associated services are enabled by Azure Arc, you can use Azure to manage your inventory. Verify that the SQL Server service is Version
Azure Arc
This article describes how to disconnect SQL Server instances from Azure Arc by using the Azure portal or a command shell. It applies to SQL Server instances enabled by Azure
2022 (16.x) This article describes a step-by-step process to set up authentication with Microsoft Entra ID with app registration, and demonstrates how to use different Micros
Yes, you can use the setting in the Azure Policy to indicate the SQL Server instances that you don't want to include in the onboarding process. For example, if you have any standby instances, you m
Event Classes
No description available.
The event class occurs whenever a login is added or removed as a database user to a database.
The event class occurs when a Microsoft SQL Server login is added or removed. If you set additional
The event class occurs whenever a login is added or removed from a fixed server role.
The event class occurs whenever a login is added to or removed from a database role.
The event class occurs when a database role is added to or removed from a database.
The event class occurs whenever a password is changed for an application role.
The event class occurs whenever a backup or restore command is issued. Description Name of the client application that created the connection to a
creates an event to report audit messages related to Service Broker dialog security. Desc
creates an event to report audit messages related to Service Broker transport security. D
The event class occurs whenever an audit trace modification is made. Description Name of the client
The event class occurs when you use the ALTER AUTHORIZATION statement to change the owner of a databa
The event class occurs when a database is created, altered, or dropped.
creates an event to report audit messages related to database mirroring transport security
The event class occurs when database objects, such as schemas, are accessed.
No description available.
No description available.
The event class occurs when a change of owner for objects within database scope occurs. Description
The event class occurs when operations in a database, such as checkpoint or subscribe query notificat
The event class occurs when an impersonation occurs within the database scope, such as EXECUTE AS <
The event class occurs when principals, such as users, are created, altered, or dropped from a databa
The event class occurs whenever a GRANT, REVOKE, or DENY is issued for a statement permission by any user in Microsoft SQL Server
The event class occurs whenever a DBCC command is issued. Description Name of the client application
The event class occurs when SQL Server connects to and communicates with the full-text filter daemon
The event class occurs whenever a user changes their Microsoft SQL Server login password. Descriptio
The event class occurs when you use the stored procedure, the stored procedure, or the ALTER LOGIN
The event class indicates that a user has successfully logged in to Microsoft SQL Server. Events in t
ﾃ Summarize this article for me The event class indicates that a user tried to sign in to Microsoft SQL Server and failed.
The event class occurs whenever a Microsoft Windows login right is added or removed.
The event class indicates that a user has logged out of (logged off) Microsoft SQL Server.
The event class records when a CREATE, ALTER, or DROP command is issued for a specified object. This
The event class occurs when an object permission (such as SELECT) is used.
No description available.
The event class occurs when server objects are created, altered, or dropped.
No description available.
The event class occurs for all statements that check for the ALTER TRACE permission.
No description available.
The event class occurs in the case of CREATE, ALTER, or DROP for server objects. Description Name o
The event class occurs when the owner is changed for objects in server scope. Description Name of t
The event class occurs when Security Audit operations such as altering settings, resources, external
No description available.
The event class occurs when server principals are created, altered, or dropped.
The event class occurs when a GRANT, REVOKE, or DENY is issued for permissions in the server scope, s
The event class occurs when the Microsoft SQL Server service state is modified.
The event class occurs whenever a statement permission (such as CREATE TABLE) is used.
The event class indicates that an automatic updating of index and column statistics has occurred. al
The event class occurs when a background job has terminated abnormally.
The event class can be used to monitor bitmap filter usage in queries. The event subclass c
No description available.
The event category contains general Service Broker events. Description Broker:Activation Event Class An event generated
generates a event when a queue monitor starts an activation stored procedure, sends a QUEUE_ACTIVATION notific
generates a event to report the status of a transport connection managed by Service Broker. Description The
generates a event to report the progress of a Service Broker conversation.
No description available.
creates a event when Service Broker receives a corrupted message. Description The name of the client applica
No description available.
generates a Broker:Forwarded Message Sent event when Service Broker forwards a message. Description Applicati
generates a event when Service Broker determines the routing for a message.
generates a event when Service Broker is unable to retain a received message that should have been delivered t
generates a event when Service Broker sends or receives a message acknowledgement. Description The name of t
The event category includes event classes that are produced by the execution of .NET Framework common
No description available.
Creates a versioned object for the root hosting interface.
Cursor close events occur when the Database Engine closes and deallocates a cursor.
No description available.
No description available.
The event class describes cursor open events that occur in application programming interfac
No description available.
No description available.
The event category contains event classes that are used to monitor the behavior of cursors.
The event class provides information about cursor unprepare events that occur in applicatio
The event class indicates that the data file grew automatically. This event is not triggere
The event class indicates that the data file has been shrunk. This event is not triggered i
The event category contains event classes to monitor the SQL Server Database Engine. Descr
generates a event to report the status of a transport connection managed by Database Mirroring.
The event class indicates when the state of a mirrored database changes. Include this event class in traces that are monitoring c
The event class indicates when a page is added to the suspect_pages table in msdb . Incl
2016 (13.x) and later versions Azure SQL Managed Instance The event class provides an XML description of a deadlock. T
No description available.
No description available.
The event category contains general deprecation events. Description Deprecation Announceme
No description available.
Use the event class to monitor the state of SQL Server Database Engine transactions coordinated through Microsoft Distributed Tra
No description available.
The event category contains general error and warning events. Description Attention Event
No description available.
The Exception event class indicates that an exception has occurred in SQL Server. Descriptio
No description available.
The Exec Prepared SQL event class indicates that the SqlClient, ODBC, OLE DB, or DB-Library
No description available.
No description available.
The event class indicates that an exception has been encountered during a full-text crawl.
The event class indicates that a full-text crawl (population) has started.
The event class indicates that a full-text crawl (population) has stopped. The stop can be due to a s
The event category contains general full-text events. Description FT:Crawl Aborted Event Class Indi
Retrieves a registry string from an instance specific registry tree by the given instance ID, the subtree, and the name of the value. This article describes a native code API
Retrieves the instance ID of an instance when given the friendly name, conditioned to search only the instance maps for the given service.
No description available.
2016 (13.x) and later versions Azure SQL Managed Instance The Lock:Acquired event class indicates that acquisition of a
No description available.
No description available.
No description available.
No description available.
No description available.
No description available.
2016 (13.x) and later versions Azure SQL Managed Instance The Lock:Timeout event class indicates that a request for a l
No description available.
The event class indicates that the log file grew automatically. This event is not triggered
The event class indicates that the log file shrank automatically. This event is not trigger
No description available.
The Missing Join Predicate event class indicates that a query is being executed that has no j
The Mount Tape event class occurs when a tape mount request is received.
No description available.
No description available.
The Object:Deleted event class indicates that an object has been deleted; for example, by DR
The event category contains general objects events. Description Auto Stats Event Class I
The Object Type trace event column is used in a variety of trace events. This topic describes
No description available.
The OLEDB DataRead event class occurs when SQL Server calls an OLE DB provider for distributed queries
The OLEDB Errors event class occurs in Microsoft SQL Server when a call to an OLE DB provider returns
The event category contains general OLEDB events.
No description available.
No description available.
Use the event category to monitor event classes and event classes that are produced from t
No description available.
No description available.
No description available.
The PreConnect:Completedevent class indicates when a LOGON trigger or the Resource Governor
The PreConnect:Starting event class indicates when a LOGON trigger or the Resource Governor
The Prepare SQL event class indicates that SqlClient, ODBC, OLE DB, or DB-Library has prepar
The event category contains the event class. Description Progress Report: Online Index Op
The Progress Report: Online Index Operation event class indicates the progress of an online
The QN:Dynamics event class reports information about the background activity that the Datab
No description available.
The QN:Subscription event reports information on notification subscriptions. Description Ap
The QN:Template event reports information on the internal use of query templates.
No description available.
The RPC Output Parameter event class traces the output parameter values of remote procedure
The event class indicates that a remote procedure call has been completed. Description Nam
The RPC:Starting event class indicates that a remote procedure call has started. Description
The Scan:Started event class occurs when a table or index scan is started. Description Appl
The Scan:Stopped event class occurs when a table or index scan stops. Description Applicati
The event category contains scan events. Description Scan:Started Event Class Indicates t
The event category contains security audit events. Description Audit Add DB User Event Class Indica
The event category contains general server events.
The event class occurs when Microsoft SQL Server memory usage has increased or decreased by either 1
The event category contains the event class. Description ExistingConnection Event Class
The Showplan All event class occurs when Microsoft SQL Server executes a SQL statement. The
The Showplan All for Query Compile event class occurs when Microsoft SQL Server compiles a S
The Showplan Statistics Profile event class occurs when Microsoft SQL Server executes a SQL
No description available.
The Showplan Text event class occurs when Microsoft SQL Server executes a SQL statement. The
The Showplan XML event class occurs when Microsoft SQL Server executes a SQL statement. Incl
The Showplan XML For Query Compile event class occurs when Microsoft SQL Server compiles a S
The Showplan XML Statistics Profile event class occurs when Microsoft SQL Server executes a
The Sort Warnings event class indicates that sort operations do not fit into memory.
The SP:CacheHit event class indicates that a stored procedure is in the plan cache. Descript
No description available.
The SP:CacheMiss event class indicates that the procedure is not found in the cache.
No description available.
The SP:Completed event class indicates that the stored procedure has completed executing. De
No description available.
The SP:Starting event class indicates that a stored procedure is beginning execution. Descri
No description available.
No description available.
SQL:BatchCompleted Event Class The SQL:BatchCompleted event class indicates that the Transac
SQL:BatchStarting Event Class The SQL:BatchStarting event class indicates that a Transact-SQ
No description available.
SQL:StmtCompleted Event Class The SQL:StmtCompleted event class indicates that a Transact-SQ
No description available.
SQL:StmtStarting Event Class The SQL:StmtStarting event class indicates that a Transact-SQL
SQLTransaction Event Class Use the SQLTransaction event class to monitor when transactions b
The event category contains general stored procedure events. Description RPC:Completed Eve
The event category contains general Transact-SQL events. Description Exec Prepared SQL Eve
No description available.
The TM: Begin Tran Starting event class indicates that a BEGIN TRANSACTION request is starti
The TM: Commit Tran Completed event class indicates that a COMMIT TRANSACTION request comple
No description available.
No description available.
No description available.
No description available.
No description available.
The TM: Save Tran Completed event class indicates that a SAVE TRANSACTION request has comple
The TM: Save Tran Starting event class indicates that a SAVE TRANSACTION request is starting.
The event class indicates that a trace file has been closed during a trace file rollover. Descriptio
Use the TransactionLog event class to monitor activity in the transaction logs in an instance
The event classes can be used to monitor the status of transactions.
No description available.
No description available.
The event category contains the event classes. Description User-Configurable Event Class
Use the User-Configurable event category to monitor user-defined events. Create user-defined
The XQuery Static Type event class occurs when SQL Server executes an XQuery expression. Thi
Ssb Diagnose
No description available.
09/10/2025 You can use the tools provided by SQL Server Data Tools to determine whether you can improve the performance of your query, stored procedures, or scripts. For example, by monitoring clie
SQL Server Data Tools usage and 09/10/2025 The SQL Server Data Tools (SSDT) component is enabled through the Data workload in Visual Studio. The Visual Studio Customer Experience Improvement Progra
Identifies which utility generated the output XML file. XML Description Identifies the utility that generated the XML output file. Identifies the product that generated
09/10/2025 You can compare the data in a source database and a target database and specify which tables should be compared. The data can be reviewed to guide a decision about which changes to s
No description available.
09/10/2025 You can run SQL Server unit tests to verify whether changes to one or more database objects in a schema have broken existing functionality in a database application. These tests complemen
09/10/2025 You can add custom test conditions for SQL Server unit tests. However, you must first install the test condition before you can use it, whether you created the extension or you're install
09/09/2025 Visual Studio provides extensibility points that you can use to modify the behavior of the build and deployment actions for database projects. You can create an extension for the extensi
SQL projects properties In addition to the contents of the individual files, SQL database p
09/10/2025 The Transact-SQL debugger allows you to interactively debug stored procedures by displaying the SQL call stack, local variables, and parameters for the SQL stored procedure. The Transact-
The element contains all elements that report the diagnostic information found by the utility. is the root element of a XML output file. XML Description N/A Descriptio
09/09/2025 To view and manage all the open breakpoints, you can use the window. Use the window to view breakpoint information and to take actions such as deleting, disablin
09/10/2025 You can create feature extensions that let you extend features such as unit testing, and database code analysis. For more information, see the following articles: Customize database buil
09/10/2025 You can add test conditions to a SQL Server unit test by using the SQL Server Unit Test . When you save the test class, the test conditions are automatically saved in your test project
09/10/2025 The SQL Server Object Explorer in Visual Studio now contains a dedicated Projects node, under which all SQL Server database projects in your solution are grouped in a SQL Server Manageme
09/10/2025 You can compare the data that is contained in two databases. The databases that you compare are known as the source and the target . As the data is compared, a Data Manipulation Lan
09/10/2025 By configuring your test project, you can specify several settings that control aspects of how your SQL Server unit tests are run. These configuration settings are stored in your test pro
09/10/2025 A common task for database administrators and developers is to connect to a live database, design, or browse its schema and query against its objects. The SQL Server Object Explorer in V
09/10/2025 A file provides you with a read-only representation of the database schema at the time it's created. It's essentially being treated as a database schema from which you can import the sc
09/10/2025 Before you can start to write unit tests that evaluate database objects, you must first create a test project. This project contains SQL Server unit tests, but it could contain other type
09/09/2025 Include unit tests in your database project to verify changes you make to database objects don't break existing functionality. The following procedures explain how to create SQL Server u
No description available.
09/10/2025 If you prefer to use scripts to create or edit views, stored procedures, functions, triggers, or user-defined-types, you can use the Transact-SQL Editor. The Transact-SQL Editor provides
09/10/2025 You can write unit tests that evaluate changes to any database object. However SQL Server Data Tools includes support for creating tests for database functions, triggers, and stored proc
09/10/2025 You can use the extensible TestCondition class to create new test conditions. For example, you might create a new test condition that verifies the number of columns or the values in a r
09/10/2025 A SQL Server unit test consists: Unit test code written in C# or Visual Basic. This code, which is generated by the SQL Server Unit Test Designer, is responsible for submitting the Trans
09/10/2025 The Transact-SQL debugger allows you to interactively debug stored procedures by displaying the SQL call stack, local variables, and parameters for the SQL stored procedure. The Transact-
09/10/2025 When you rename or delete an object in SQL Server Object Explorer , SQL Server Data Tools (SSDT) automatically detects all its dependency objects, and prepares an script to rename or
09/10/2025 You can edit the definition of a table or its data by writing a Transact-SQL query. To view or enter data in a table visually, use the Data Editor as described in Connected Database Dev
09/10/2025 The Transact-SQL Editor allows you to highlight a specific segment of the script and execute it as a single query. This makes it easy for you to debug sections of complex queries. 1. In
09/10/2025 The Error List pane displays any deployment or build errors. Syntax and semantic errors caused by editing in either the Transact-SQL Editor or Table Designer also shows up in the list whe
09/10/2025 You can add rules for analyzing database code, conditions for database unit tests and build/deployment contributors to increase the functionality that Visual Studio editions including SQ
09/10/2025 The Transact-SQL Editor for offline development provides two useful navigation tools that are familiar to Visual Studio users: Go To Definition and Find All References. For example, you c
09/10/2025 After you create a SQL Server unit test, you use the SQL Server Unit Test Designer to add Transact-SQL statements and test conditions. The tests created by using the designer generate
09/10/2025 SQL Server Data Tools includes a code library consisting of code snippets that are ready to be inserted in your application. Each snippet performs a complete scripting task such as creati
09/10/2025 You can run a SQL Server unit test in any one of several ways, such as using various windows and the Command Prompt window. The ways that are available to you depend on the software that
09/10/2025 You can use Team Foundation Build to run your SQL Server unit tests as part of a build verification test (BVT). You can configure your unit tests to deploy the database, generate test da
09/10/2025 SQL Server Data Tools (SSDT) Power Buffer technology makes it easy for you to apply changes to your connected database by storing all your edits in the current session. Any errors caused
09/10/2025 The contextual menu in the Transact-SQL Editor allows you to rename or move an object to a different schema and preview all affected areas before committing the change. You can also use
09/10/2025 The Table Designer provides a visual experience alongside the Transact-SQL Editor for creating and editing table structure, including table-specific programming objects, for SQL Server d
09/10/2025 You can view, edit, and delete data in an existing table by using a visual Data Editor. 1. Right-click the table in SQL Server Object Explorer , and select . 2. The Data Editor launc
09/10/2025 After you compare the data in two databases, you see each database object that you compared and its status. You can also view results for the records within each object, grouped by stat
09/10/2025 In addition to the Transact-SQL programming language, you can use .NET Framework languages to create database objects that retrieve and update data. Database objects that are written in
09/10/2025 You can modify unit tests to run within the scope of a single transaction. If you take this approach, you can roll back any changes that the test enacted after the test ends. The followi
09/10/2025 When you run a SQL Server unit test, test results are automatically produced, saved to disk, and summarized in the window. As soon as you start a test run, the window appears and displa
Reports an issue that was found by the utility. The XML output file has one Issue element per issue reported. Description Identifies which categor
09/10/2025 You can use the following keyboard shortcuts to navigate within the SQL Server Unit Test Designer. Move from the Transact-SQL editor to the navigation bar. + Move forward through navig
09/10/2025 Topics in this section describe how to use the Table Designer to design tables and manage table relationships. Additional articles describe how to fix common syntax or semantic errors. D
09/10/2025 To run SQL Server unit tests, you must connect to a database server by using one or two specific connection strings. Each connection string represents an account that has the specific pe
The provided code analysis rules report on Transact-SQL design, naming, and performance warnings in your database code.
09/10/2025 You can start the Transact-SQL debugger after you open a Database Engine Query Editor window.
09/10/2025 To improve and maintain the quality of your code, you can create and run SQL Server unit tests that verify the behavior of any database object and then check in those tests to version con
09/09/2025 Each SQL Server unit test contains a single pre-test action, test action, and post-test action. Each of these actions in turn contains: A Transact-SQL script that executes on a database.
09/09/2025 A breakpoint action specifies a custom task that the Transact-SQL debugger performs for a breakpoint. If the specified hit count is reached and a specified breakp
09/10/2025 A breakpoint condition is a Transact-SQL expression that the debugger evaluates when the breakpoint is reached.
09/10/2025 A breakpoint filter limits the breakpoint to acting only on specified computers, operating system processes, and threads.
09/09/2025 A breakpoint hit count is a counter that the Transact-SQL debugger increments each time the breakpoint is reached. If the specified hit count is reached and any s
SQL Server unit test files 09/10/2025 Like the unit tests for managed code, SQL Server unit tests reside in test projects. You can see the items that compose a SQL Server unit test in the hierarchy
09/10/2025 The Transact-SQL debugger enables you to control which Transact-SQL statements are run in a Database Engine Query Editor window.
No description available.
09/15/2025 The Transact-SQL debugger helps you find errors in Transact-SQL code by investigating the run-time behavior of the code. After you set the Database Engine Query E
09/09/2025 Every time that the debugger pauses execution on a specific Transact-SQL statement, you can use the various debugger windows to view the current execution state.
09/09/2025 This article describes some of the options of the Transact-SQL Editor. To set these options, go to the dialog through the > menu. Description The default value of indicates that SQL
09/10/2025 The act of setting a breakpoint on a Transact-SQL statement is called toggling a breakpoint. Once the breakpoint is set, it's represented by an icon in the gray b
09/10/2025 You might encounter the following issues when you work with SQL Server unit tests on a database. If you modify the file in the test project, you must rebuild the test project before th
09/10/2025 You can upgrade an older test project, which was created in Visual Studio 2010 and that contains database unit tests, to use the new SQL Server Data Tools database unit testing runtime a
09/10/2025 The Transact-SQL Editor provides you with a rich editing and debugging experience when you're working with scripts. It's invoked when you use the contextual menu to open a database enti
09/10/2025 In a SQL Server unit test, a Transact-SQL test script runs and returns a result. Sometimes, the results are returned as a results set. You can validate results by using test conditions. F
09/10/2025 In a SQL Server unit test, one or more Transact-SQL test scripts are executed. The results can be evaluated within the Transact-SQL script and or used to return an error and fail the t
09/10/2025 You can use SQL Server unit tests to establish a baseline state for your database and then to verify any subsequent changes that you make to database objects. To establish a baseline sta
No description available.
No description available.
This walkthrough demonstrates the steps used to create a SQL Server code analysis rule. The
09/10/2025 In this walkthrough, you create a SQL Server unit test that verifies the behavior of several stored procedures. You create SQL Server unit tests to help identify code defects that might
09/10/2025 You can create a build contributor to perform custom actions when you build a database project. In this walkthrough, you create a build contributor named ModelStatistics that outputs sta
09/10/2025 You can create deployment contributors to perform custom actions when you deploy a SQL project. You can create either a DeploymentPlanModifier or a DeploymentPlanExecutor. Use a Deployme
09/09/2025 You can create deployment contributors to perform custom actions when you deploy a SQL project. You can create either a DeploymentPlanModifier or a DeploymentPlanExecutor . Use a Dep
09/10/2025 In this feature extension walkthrough, you create a test condition, and you verify its functionality by creating a SQL Server unit test. The process includes creating a class library pro
The utility delivers its output as an XML file when you run it with the switch. The XML output file lists header information and the errors that it found in the Service Bro
Data Tools
09/10/2025 Under specific circumstances you might need to use a different version of DacFx with the SQL Server Data Tools interface in Visual Studio. When possible, it's recommended to use a stan
09/09/2025 This article shows how a user can connect to an existing database in SQL Server Data Tools (SSDT). SSDT allows you to connect to an existing database, run queries with Transact-SQL (T- S
09/10/2025 To use a test unit condition that you created in a version before SQL Server Data Tools, you must upgrade it. To update the project references: 1. For Visual Basic only, in , select .
No description available.
09/09/2025 SQL Server Data Tools (SSDT) provides project templates a
Required permissions for SQL Server Data 09/09/2025 Before you can perform an action on a database in Visual Studio, you must sign in with an account that has certain permissions on that database.
SQL Server Data Tools SQL Server Data Tools (SSDT) is a set of development tools in Visual Studio with focus on building SQL Server databases and Azure SQL databases. SSDT can be extended to Analys
SQL Server Data Tools, SDK-style (preview) SQL Server Data Tools (SSDT) is a set of development tools in Visual Studio with focused on building SQL Server databases and Azure SQL databases. SDK-sty
Upgrade
06/04/2025 - Windows only Analysis Services instances can be upgraded to a SQL Server version of the same server mode to take advantage of features introduced in the curren
08/22/2025 - Windows only SQL Server Setup supports edition upgrade among various editions of SQL Server. For information about supported edition upgrade paths, see Suppor
06/04/2025 - Windows only In SQL Server 2016 (13.x) and later, some changes are only enabled once the database compatibility level has been changed.
No description available.
ﾃ Summarize this article for me on Windows There are several approaches to consider when you're planning to upgrade the Database Engine from a prior release of SQL Server,
06/16/2025 Compatibility certification allows businesses to upgrade and modernize a SQL Server database on-premises, in the c
06/04/2025 - Windows only After upgrading the Database Engine, complete the following tasks: Perform a full backup of each database.
06/04/2025 - Windows only This article provides information on how to upgrade your existing installation of SQL Server Data Quality Services (DQS).
end of support options SQL Server 2014 (12.x) This article explains your options for addressing SQL Server products that reach end of support.
2014 (12.x) General frequently asked questions about Extended Security updates can be found at the Extended security updates FAQ .
? SQL Server 2014 (12.x) This article provides information on how to receive Extended Security Updates (ESUs) for versions of SQL Server that are out of extended support. Ex
06/03/2025 - Windows only The SQL Server Installation Wizard provides a single feature tree for an in-place upgrade of SQL Server components to the latest version of SQL Se
This article lists various builds or updates that are available for different versions of SQL Server.
06/04/2025 - Windows only The following are the scenarios for upgrading Microsoft SQL Server Master Data Services. Upgrade without Database Engine Upgrade Upgrade with Dat
06/04/2025 The articles in this section help you upgrade the SQL Server Database Engine from a prior release of SQL Server to SQL Server 2022 (16.x). 1. Choose a Database
on Windows This article provides guidance on how to upgrade or patch SQL Server instances that participate in peer-to-peer (P2P) replication , both outside of an Always On
06/16/2025 - Windows only To perform a successful SQL Server upgrade, regardless of approach, appropriate planning is required.
06/03/2025 - Windows only This article summarizes the steps required to upgrade a deployment of Power Pivot for SharePoint to Microsoft SQL Server 2016 (13.x) Power Pivot f
No description available.
- Windows only SQL Server supports upgrading replicated databases from previous versions of SQL Server; it isn't required to stop activity at other n
06/04/2025 - Windows only SQL Server supports upgrade from SQL Server 2008 (10.0.x) and later versions. This article documents support and behavior for upgrading SQL Server
06/03/2025 - Windows only You can upgrade from SQL Server 2008 (10.0.x), SQL Server 2008 R2 (10.50.x), SQL Server 2012 (11.x), and SQL Server 2014 (12.x).
06/04/2025 - Windows only You can upgrade from SQL Server 2008 (10.0.x), SQL Server 2008 R2 (10.50.x), SQL Server 2012 (11.x), SQL Server 2014 (12.x), and SQL Server 2016 (
06/16/2025 - Windows only You can upgrade from SQL Server 2012 (11.x), SQL Server 2014 (12.x), SQL Server 2016 (13.x), and SQL Server 2017 (14.x).
06/16/2025 - Windows only This article lists the supported upgrade paths from the following SQL Server versions, and the supported edition upgrades for SQL Server 2022 (16.
- Windows only This article lists the supported upgrade paths from the following SQL Server versions, and the supported edition upgrades for SQL Server 2025 (17.x).
Migration
Backward compatibility is important to understand if you are upgrading, or if you have more than one version of SQL Server
After you have configured replication, it is important to understand how to administer a replication topology.
This topic describes breaking changes in SQL Server Replication.
This article explains how to set up a SQL Server replication distribution database in an Always On availability group (AG). SQL Server 2017 CU6 and S
This topic describes how to configure publishing and distribution in SQL Server by using SQL Server Management Studio, Tra
No description available.
This article describes how to create a publication in SQL Server by using SQL Server Management Studio, Transact-SQL, or R
This topic describes how to delete a publication in SQL Server by using SQL Server Management Studio, Transact-SQL, or Rep
This topic describes how to deliver a snapshot through FTP in SQL Server by using SQL Server Management Studio or Transact-SQL. By default, snapshots
This topic describes the deprecated Replication features that are still available in SQL Server. These features are schedu
This topic describes how to disable publishing and distribution in SQL Server by using SQL Server Management Studio, Trans
No description available.
A database is implicitly enabled for replication when a member of the fixed server role creates a publication with the Ne
Enable a Publisher to use a remote Distributor on the page. This page is available in the Configure Distribution Wizard a
ﾃ Summarize this article for me The following questions and answers provide guidance on a variety of tasks faced by administrators of replicated
In this guide, you learn how to migrate your Microsoft Access databases to SQL Server by using SQL Server Migration Assistant for Access (SSMA for Acc
In this guide, you learn how to migrate your user databases from IBM Db2 to SQL Server by using SQL Server Migration Assistant (SSMA) for Db2.
In this guide, you learn how to migrate your MySQL databases to SQL Server. For other migration guides, see Azure Database Migration Guides . Befor
In this guide, you learn how to migrate your Oracle databases to SQL Server by using SQL Server Migration Assistant for Oracle (SSMA for Oracle). For
In this guide, you learn how to migrate your SAP ASE databases to SQL Server by using SQL Server Migration Assistant for SAP ASE (SSMA for SAP ASE).
In this guide, you learn how to upgrade your user databases from previous versions of SQL Server to SQL Server 2025 (17.x) by using the SQL Server migration component in SQL Server Management Studio
No description available.
Replication Replication is a set of technologies for copying and distributing data and database objects from o
This topic describes how to set the expiration period for subscriptions in SQL Server by using SQL Server Management Studi
Specify the minimum distribution retention period and maximum distribution retention period on the dialog box. This is a
Specify the history retention period on the page of the dialog box. This setting controls how long replication agent history is stored.
This topic describes how to specify schema options in SQL Server by using SQL Server Management Studio or Transact-SQL. Wh
This topic describes how to view and modify publication properties in SQL Server by using SQL Server Management Studio, Tr
This topic describes how to view and modify Distributor and Publisher properties in SQL Server by using SQL Server Managem
2022 (16.x) This article provides steps to configure Transactional and Snapshot replication by using authentication with Microsoft Entra ID ( formerly Azure Active Directory
Monitor
Product Name Event ID 10001 Event Source MSSQLSERVER Component SQLEngine S
Product Name Event ID 10003 Event Source MSSQLSERVER Component SQLEngine S
This article details various scenarios and provides resolutions for the following errors: A connection was successfully established with the server, but then an error occurre
Product Name Event ID 10061 Event Source MSSQLSERVER Component SQLEngine
Product Name Event ID
Product Name Event ID 10502 Event Source MSSQLSERVER Component SQLEngine
Product Name Event ID 10507 Event Source MSSQLSERVER Component SQLEngine
Product Name Event ID 10509 Event Source MSSQLSERVER Component SQLEngine
Product Name Event ID 10519 Event Source MSSQLSERVER Component SQLEngine
Product Name Event ID 10520 Event Source MSSQLSERVER Component SQLEngine
Product Name Event ID 10521 Event Source MSSQLSERVER Component SQLEngine
Product Name Event ID 10531 Event Source MSSQLSERVER Component SQLEngine
Product Name Event ID 10532 Event Source MSSQLSERVER Component SQLEngine
Product Name Event ID 10533 Event Source MSSQLSERVER Component SQLEngine
Product Name Event ID 10534 Event Source MSSQLSERVER Component SQLEngine
Product Name Event ID 10535 Event Source MSSQLSERVER Component SQLEngine
Product Name Event ID 10536 Event Source MSSQLSERVER Component SQLEngine
Product Name Event ID 10537 Event Source MSSQLSERVER Component SQLEngine
Product Name Event ID 10538 Event Source MSSQLSERVER Component SQLEngine
Product Name Event ID 10539 Event Source MSSQLSERVER Component SQLEngine
Product Name Event ID 107 Event Source MSSQLSERVER Component SQLEngine Sym
Product Name MSSQLSERVER Event ID 10737 Event Source MSSQLSERVER Component SQLEngine
Product Name MSSQLSERVER Event ID 10770 Event Source MSSQLSERVER Component SQLEngine
Product Name MSSQLSERVER Event ID 10771 Event Source MSSQLSERVER Component SQLEngine
Product Name MSSQLSERVER Event ID 10772 Event Source MSSQLSERVER Component SQLEngine
Product Name MSSQLSERVER Event ID 10773 Event Source MSSQLSERVER Component SQLEngine
Product Name MSSQLSERVER Event ID 10785 Event Source MSSQLSERVER Component SQLEngine
Product Name MSSQLSERVER Event ID 10787 Event Source MSSQLSERVER Component SQLEngine
Product Name MSSQLSERVER Event ID 10794 Event Source MSSQLSERVER Component SQLEngine
Product Name Event ID 11001 Event Source MSSQLSERVER Component SQLEngine
Product Name Event ID 1101 Event Source MSSQLSERVER Component SQLEngine
Product Name Event ID 1105 Event Source MSSQLSERVER Component SQLEngine
Product Name Event ID 11409 Event Source MSSQLSERVER Component SQLEngine S
Product Name Event ID 1203 Event Source MSSQLSERVER Component SQLEngine S
Product Name Event ID 1204 Event Source MSSQLSERVER Component SQLEngine
Product Name Event ID 1205 Event Source MSSQLSERVER Component SQLEngine Symbolic N
Product Name Event ID 1222 Event Source MSSQLSERVER Component SQLEngine Sy
Product Name Event ID 12300 Event Source MSSQLSERVER Component SQLEngine S
Product Name Event ID 12301 Event Source MSSQLSERVER Component SQLEngine S
Product Name Event ID 12302 Event Source MSSQLSERVER Component SQLEngine S
Product Name Event ID 12303 Event Source MSSQLSERVER Component SQLEngine S
Product Name Event ID 12304 Event Source MSSQLSERVER Component SQLEngine Symbolic Name HK_UNSUPPORTED_IDENTITY_TABLE_VAR Message
Product Name Event ID 12305 Event Source MSSQLSERVER Component SQLEngine S
Product Name Event ID 12306 Event Source MSSQLSERVER Component SQLEngine S
Product Name Event ID 12307 Event Source MSSQLSERVER Component SQLEngine S
Product Name Event ID 12308 Event Source MSSQLSERVER Component SQLEngine S
Product Name Event ID 12329 Event Source MSSQLSERVER Component SQLEngine
Product Name Event ID 125 Event Source MSSQLSERVER Component SQLEngine Sym
Product Name Event ID 137 Event Source MSSQLSERVER Component SQLEngine Sym
Product Name Event ID 1401 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBM_MASTERSTART
Product Name Event ID 1406 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBM_BADSTATEFORF
Product Name Event ID 1418 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBM_PARTNERNOTF
Product Name Event ID 14265 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SQLErrorNum14265 Message Text The MSSQLS
Product Name Event ID 14420 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SQLErrorNum14420 Message Text The log s
Product Name Event ID 14421 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SQLErrorNum14421 Message Text The log s
Product Name Event ID 1457 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBM_PAGE_UNDO_
Product Name Event ID 1458 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBM_FAILREDO_ON_PRIMARY Message Text The
Product Name Event ID 1461 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBM_SAFETY_MISMATCH Message Text Differen
Product Name Event ID 1462 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBM_DISABLED_DUE_TO_FAILED_REDO Message Text
Product Name Event ID 1505 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DUP_KEY Message Text CREATE UNIQUE INDEX
Product Name Event ID 15401 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SEC_INVALIDLOGINORGROUP Message Text Windo
10/24/2025 Product Name Event ID 15404 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SEC_NTGRP_ERROR Message Text Could not obtain informat
Product Name Event ID 15517 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SEC_CANNOTEXECUTEASUSER Message Text Can
Product Name Event ID 15581 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SEC_NODBMASTERKEYERR Message Text Please
Product Name Event ID 15599 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SEC_LOCAL_TEMP_AUDIT_PERMISSIONS Message Te
Product Name Event ID 15661 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SQLErrorNum15661 Message Text The sp_esti
Product Name Event ID 16591 Event Source MSSQLSERVER Component SQLEngine Symbolic Name POLARIS_MULTIPLE_LOGICAL_FILE_PATH_LIMIT
Product Name Event ID 16594 Event Source MSSQLSERVER Component SQLEngine Symbolic Name POLARIS_MULTIPLE_FILE_PATHS_DUPLICATE_PATH_R
No description available.
Product Name Event ID 17065 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SQLASSERT_BOTH Message Text
Product Name Event ID 17066 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SQLASSERT_ONLY Message Text
Product Name Event ID 17067 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SQLASSERT_MESG Message Text
No description available.
Product Name Event ID 17084 Event Source MSSQLSERVER Component SQLEngine Symbolic Name P3_ATOMIC_WITH_MISSING_OPTION Message Text
Product Name Event ID 17112 Event Source MSSQLSERVER Component SQLEngine Symbolic Name INIT_INVCOMMAND Message Text An invalid
No description available.
Product Name Event ID 17128 Event Source MSSQLSERVER Component SQLEngine Symbolic Name INIT_NOBUFSPACE Message Text initdata: No
No description available.
No description available.
Product Name Event ID 17142 Event Source MSSQLSERVER Component SQLEngine Symbolic Name INIT_SRVC_PAUSED Message Text
Product Name Event ID 17147 Event Source MSSQLSERVER Component SQLEngine Symbolic Name STARTUP_SERVERKILLED Message Text SQL Se
Product Name Event ID 17148 Event Source MSSQLSERVER Component SQLEngine Symbolic Name STARTUP_SERVERUNINSTALL Message Text SQL
Product Name Event ID 17182 Event Source MSSQLSERVER Component SQLEngine Symbolic Name INIT_TDSSNICLIENT Message Text TDSSNIClie
Product Name Event ID 17194 Event Source MSSQLSERVER Component SQLEngine Symbolic Name Message Text The server was unable to l
Product Name Event ID 17204 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBLKIO_DEVOPENFAILED Message Text %ls: Cou
Product Name Event ID 17207 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBLKIO_OS2DISKERROR Message Text %ls: Op
Product Name Event ID 17300 Event Source MSSQLSERVER Component SQLEngine Symbolic Name PROC_OUT_OF_SYSTASK_SESSIONS Message Te
No description available.
Product Name Event ID 17660 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DEMO_BOOTNORECOVERY Message Text Starting
Product Name Event ID 17676 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DEMO_SIGNALSHUTDOWN Message Text SQL Ser
No description available.
No description available.
No description available.
No description available.
Product Name Event ID 1785 Event Source MSSQLSERVER Component SQLEngine Symbolic Name CRTFKINVTOPO Message Text Introducing FO
Product Name Event ID 17883 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SRV_SCHEDULER_NONYIELDING Message Text
Product Name Event ID 17884 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SRV_SCHEDULER_DEADLOCK Message Text Ne
Product Name Event ID 17887 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SRV_IO_COMP_LISTENER_NONYIELDING Message
Product Name Event ID 17890 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SRV_WS_TRIMMED Message Text A significa
ﾃ Summarize this article for me Product Name Event ID 17892 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SRV_LOGON_FAILED_BY_TRIGGER Messa
Product Name Event ID 1793 Event Source MSSQLSERVER Component SQLEngine Symbolic Name FILESTREAM_BASEDATA_NEED_SAME_PARTITION Mess
No description available.
Product Name Event ID 18053 Event Source MSSQLSERVER Component SQLEngine Symbolic Name TERSEPRINT_ERROR Message Text Error: %d,
No description available.
Product Name Event ID 18210 Event Source MSSQLSERVER Component SQLEngine Symbolic Name STRMIO_IOFAILED Message Text %s: %s failur
No description available.
Product Name Event ID 18452 Event Source MSSQLSERVER Component SQLEngine Symbolic Name LOGON_INVALID_CONNECT Message Text Login
No description available.
Product Name Event ID 18482 Event Source MSSQLSERVER Component SQLEngine Symbolic Name REMLOGIN_INVALID_SITE Message Text Could
Product Name Event ID 18483 Event Source MSSQLSERVER Component SQLEngine Symbolic Name REMLOGIN_INVALID_USER Message Text Could
Product Name Event ID 18752 Event Source MSSQLSERVER Component SQLEngine Symbolic Name REPL_INUSE Message Text Only one Log R
Product Name Event ID 1904 Event Source MSSQLSERVER Component SQLEngine Symbolic Name KEYCOUNT Message Text The %S_MSG '%.*ls'
Product Name Event ID 19407 Event Source MSSQLSERVER Component SQLEngine Symbolic Name HADR_AG_LEASE_EXPIRED Message Text The lease between availabil
Product Name Event ID 19419 Event Source MSSQLSERVER Component SQLEngine Symbolic Name HADR_AG_LEASE_EXPIRED_WAITING_FOR_RENEW Message Text Windows Se
No description available.
Product Name Event ID 2020 Event Source MSSQLSERVER Component SQLEngine Symbolic Name Message Text The dependencies reported f
No description available.
Product Name Event ID 20572 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SQLErrorNum20572 Message Text Subscriber
Product Name Event ID 20574 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SQLErrorNum20574 Message Text Subscriber '
Product Name Event ID 207 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SQ_BADCOL Message Text Invalid column name '
No description available.
Product Name MSSQLSERVER Event ID 21862 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SQLErrorNum21862 Message Text FILESTREA
Product Name Event ID 21871 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SQLErrorNum21871 Message Text Publisher %s
No description available.
Product Name Event ID 21889 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SQLErrorNum21889 Message Text The SQL
No description available.
No description available.
No description available.
No description available.
This article helps you troubleshoot network-related or instance-specific errors that occur when you connect to a SQL Server instance.
Product Name Event ID 2501 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC_NO_SUCH_TABLE_NAME Message Text Cannot
Product Name Event ID 2508 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC_OUT_OF_DATE_PAGE_OR_ROW_COUNT Message
Product Name Event ID 2511 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC_KEYS_OUT_OF_ORDER Message Text Table
No description available.
Product Name Event ID 2515 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC_DIFF_MAP_OUT_OF_SYNC Message Text Pa
Product Name Event ID 2516 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC_REPAIR_DIFF_MAP_INVALIDATED Message
Product Name Event ID 2518 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC_NO_EXPRESSION_EVAL_CLR_DISABLED Messa
Product Name Event ID 2519 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC_NO_EXPRESSION_EVALUATOR Message Text
Product Name Event ID 2522 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC_INDEX_FILEGROUP_IS_INVALID Message Text
Product Name Event ID 2527 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC_INDEX_FILEGROUP_IS_OFFLINE Message Text
No description available.
Product Name Event ID 2533 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC_PAGE_WAS_NOT_SEEN Message Text Tabl
Product Name Event ID 2534 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC_PAGE_ALLOCATED_TO_OTHER_OBJECT Messag
Product Name Event ID 2536 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC_SUMMARY_FIRST_LINE Message Text DBCC r
Product Name Event ID 2537 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC_RECORD_CHECK_FAILED Message Text Ta
Product Name Event ID 2538 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC_ALLOCATION_SUMMARY_PER_FILE Message Te
Product Name Event ID 2539 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC_ALLOCATION_SUMMARY_FOR_DATABASE Messa
Product Name Event ID 2540 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC_REPAIR_ERROR_NOT_REPAIRABLE Message Tex
Product Name Event ID 2546 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC_INDEX_MARKED_DISABLED Message Text In
Product Name Event ID 2570 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC_COLUMN_VALUE_OUT_OF_RANGE Message Te
Product Name Event ID 2574 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC_EMPTY_INDEX_TREE_LEVEL_PAGE Message T
Product Name Event ID 2575 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC_IAM_PAGE_WAS_NOT_SEEN Message Text
Product Name Event ID 2576 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC_IAM_PARENT_PAGE_WAS_NOT_SEEN Message
Product Name Event ID 2577 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC_IAM_CHAIN_SEQUENCE_OUT_OF_ORDER Mess
Product Name Event ID 2579 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC_EXTENT_OUT_OF_RANGE Message Text Tab
Product Name Event ID 2592 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC_REPAIR_INDEX_REBUILT Message Text Rep
Product Name Event ID 2593 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC_OBJECT_ROW_PAGE_SUMMARY Message Text T
Product Name Event ID 2596 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC_DATABASE_IN_READ_ONLY_MODE Message Text
Product Name Event ID 26013 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SNI_SSL_READY Message Text The certificate
Product Name Event ID 26014 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SNI_SSL_USER_CERT_FAILURE Message Text
07/17/2025 Product Name Event ID 2814 Event Source MSSQLSERVER Component SQLEngine Symbolic Name PR_POSSIBLE_INFINITE_RECOMPILE Message Text A possibl
Product Name Event ID 30053 Event Source MSSQLSERVER Component SQLEngine Symbolic Name FTXT_QUERY_E_WORDBREAKINGTIMEOUT Message
Product Name Event ID 30089 Event Source MSSQLSERVER Component SQLEngine Symbolic Name IFTS_FDHOST_TERMINATEDABNORMAL Message
No description available.
Product Name Event ID 3023 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DB_IN_USE_DUMP Message Text Backup and f
Product Name Event ID 3043 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DMP_PAGE_ERROR_DURING_BACKUP Message Text B
No description available.
Product Name Event ID 3151 Event Source MSSQLSERVER Component SQLEngine Symbolic Name LDDB_MASTER_LOAD_FAILED Message Text Fai
No description available.
No description available.
No description available.
Product Name Event ID 3169 Event Source MSSQLSERVER Component SQLEngine Symbolic Name NA Message Text The database was backed
No description available.
Product Name Event ID 3181 Event Source MSSQLSERVER Component SQLEngine Symbolic Name LDDB_STORAGE_VERIFY Message Text Attemptin
Product Name Event ID 3183 Event Source MSSQLSERVER Component SQLEngine Symbolic Name LDDB_PAGE_ERROR_DURING_RESTORE Message Text
No description available.
Product Name Event ID 32040 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SQLErrorNum32040 Message Text The alert f
Product Name Event ID 32042 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SQLErrorNum32042 Message Text The alert f
Product Name Event ID 32043 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SQLErrorNum32043 Message Text The alert f
Product Name Event ID 32044 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SQLErrorNum32044 Message Text The alert f
No description available.
Product Name Event ID 3271 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DMPIO_IO_ERROR Message Text A nonrecoverabl
Product Name Event ID 33027 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SEC_CRYPTOPROV_CANTLOADDLL Message Text
Product Name Event ID 33028 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SEC_CRYPTOPROV_CANTOPENSESSION Message Text
Product Name Event ID 33081 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SEC_DLL_TRUST_VERIFICATION_FAILED Message
Product Name Event ID 33085 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SEC_CRYPTOPROVE_METHOD_CANNOT_FOUND Message
Product Name Event ID 33128 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SEC_DEPRECATED_ALGO Message Text Encryptio
Product Name Event ID 33129 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SEC_CANNOT_DISABLE_WIN_GROUP Message Text
Product Name Event ID 3313 Event Source MSSQLSERVER Component SQLEngine Symbolic Name ERR_LOG_RID1 Message Text During redoing
Product Name Event ID 3314 Event Source MSSQLSERVER Component SQLEngine Symbolic Name ERR_LOG_RID2 Message Text During undoing
Product Name Event ID 3413 Event Source MSSQLSERVER Component SQLEngine Symbolic Name MARKDB Message Text Database ID %d. Coul
Product Name Event ID 3414 Event Source MSSQLSERVER Component SQLEngine Symbolic Name REC_GIVEUP Message Text An error occurre
Product Name Event ID 3417 Event Source MSSQLSERVER Component SQLEngine Symbolic Name REC_BADMASTER Message Text Cannot recove
No description available.
No description available.
Product Name Event ID 3452 Event Source MSSQLSERVER Component SQLEngine Symbolic Name REC_CHECKIDENTITY Message Text Recovery o
Product Name Event ID 3456 Event Source MSSQLSERVER Component SQLEngine Symbolic Name REC_REDOLSNMISMATCH Message Text Could
Product Name Event ID 35250 Event Source MSSQLSERVER Component SQLEngine Symbolic Name HADR_PRIMARYNOTACTIVE Message Text The connection to the primary r
Product Name Event ID 35267 Event Source MSSQLSERVER Component SQLEngine Symbolic Name HADR_DISCONNECTED_DB Message Text Alwa
Product Name Event ID 360 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DML_UPDATE_SPARSE_AND_COLSET Message Text
No description available.
Product Name Event ID 3619 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SYS_NOLOG Message Text Could not write a
No description available.
Product Name Event ID 3859 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC_CHECKCAT_DIRECT_UPDATE Message Text W
Product Name MSSQLSERVER Event ID 3937 Event Source MSSQLSERVER Component SQLEngine Symbolic Name XACT_FILESTREAM_ROLLBACK_ERROR Message Te
Product Name Event ID 3961 Event Source MSSQLSERVER Component SQLEngine Symbolic Name XACT_METADATA_INVALID Message Text Snap
Product Name Event ID 3988 Event Source MSSQLSERVER Component SQLEngine Symbolic Name XACT_UNSUPPORT_PARALLEL_TRAN2 Message Text
Product Name Event ID 3989 Event Source MSSQLSERVER Component SQLEngine Symbolic Name XACT_UNSUPPORT_PARALLEL_TRAN3 Message Text
Product Name Event ID 4064 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DB_UFAIL_FATAL Message Text Cannot open user default database. Logi
Product Name Event ID 41030 Event Source MSSQLSERVER Component SQLEngine Symbolic Name OPEN_CLUSTER_SUB_KEY Message Text Fail
Product Name Event ID 4104 Event Source MSSQLSERVER Component SQLEngine Symbolic Name ALG_MULTI_ID_BAD Message Text The multi-par
Product Name Event ID 41301 Event Source MSSQLSERVER Component SQLEngine Symbolic Name COMMIT_DEPENDENCY_FAILURE Message Text A
No description available.
Product Name Event ID 41305 Event Source MSSQLSERVER Component SQLEngine Symbolic Name HK_TX_COMMIT_RR_VALIDATION Message Text Th
No description available.
Product Name Event ID 41325 Event Source MSSQLSERVER Component SQLEngine Symbolic Name HK_TX_COMMIT_SR_VALIDATION Message Text Th
Product Name Event ID 41332 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SQL_SNAPSHOT_NOT_SUPPORTED Message Text
Product Name Event ID 41333 Event Source MSSQLSERVER Component SQLEngine Symbolic Name CROSS_CONTAINER_ISOLATION_FAILURE Messag
No description available.
Product Name Event ID 41349 Event Source MSSQLSERVER Component SQLEngine Symbolic Name HK_ENCRYPTION_ON Message Text Warning:
Product Name Event ID 41350 Event Source MSSQLSERVER Component SQLEngine Symbolic Name HK_CREATE_TABLE_WITH_ENCRYPTION Message
Product Name Event ID 41359 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SQL_READ_COMMITTED_SNAPSHOT_NOT_SUPPORTED
Product Name Event ID 41365 Event Source MSSQLSERVER Component SQLEngine Symbolic Name HK_MERGE_SCHEDULE_ERROR Message Text Me
Product Name Event ID 41368 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SQL_IMPLICIT_AND_EXPLICIT_TX_NOT_SUPPORTE
Product Name Event ID 41396 Event Source MSSQLSERVER Component SQLEngine Symbolic Name MAX_SORT_ROWS_EXCEEDED Message Text The
Product Name Event ID 41399 Event Source MSSQLSERVER Component SQLEngine Symbolic Name MAX_SORT_ROW_WIDTH_EXCEEDED Message Text
Product Name Event ID 4186 Event Source MSSQLSERVER Component SQLEngine Symbolic Name Message Text Column '%ls.%.*ls' cannot b
Product Name Event ID 41962 Event Source MSSQLSERVER Component SQLEngine Message Text Operation was aborted as r
Product Name Event ID 41973 Event Source MSSQLSERVER Component SQLEngine Message Text The link cannot be establi
Product Name Event ID 41974 Event Source MSSQLSERVER Component SQLEngine Message Text The link cannot be establi
Product Name Event ID 41976 Event Source MSSQLSERVER Component SQLEngine Message Text Connection with availabili
Product Name Event ID 41977 Event Source MSSQLSERVER Component SQLEngine Message Text Connection with availabili
Product Name Event ID 41986 Event Source MSSQLSERVER Component SQLEngine Message Text
Product Name Event ID 42108 Event Source MSSQLSERVER Component SQLEngine Symbolic Name GATEWAY_SQL_POOL_CONNECT_ACTIVATION_BLOCKED
Product Name Event ID 42109 Event Source MSSQLSERVER Component SQLEngine Symbolic Name GATEWAY_SQL_POOL_CONNECT_ACTIVATION_TIMEOUT
No description available.
No description available.
No description available.
No description available.
No description available.
Product Name Event ID 5120 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DSK_FCB_FAILURE Message Text Table error: U
No description available.
Product Name Event ID 5228 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC4_ANTIMATTER_COLUMN_DETECTED Message
Product Name Event ID 5229 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC4_ANTIMATTER_IN_HEAP_OR_CLUSTERED_INDEX
Product Name Event ID 5231 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC4_DEADLOCK_SKIPPED_OBJECT Message Text
Product Name Event ID 5233 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC4_INCORRECT_VALUE_IN_PAGE_HEADER_NO_META
Product Name Event ID 5235 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC4_ERRORLOG_SUMMARY_PREMATURE_TERMINATI
Product Name Event ID 5237 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC4_INDEXED_VIEW_CHECK_QUERY_FAILED_NO_ERR
Product Name Event ID 5242 Event Source MSSQLSERVER Component SQLEngine Symbolic Name Message Text An inconsistency was detected
Product Name Event ID 5243 Event Source MSSQLSERVER Component SQLEngine Symbolic Name Message Text An inconsistency was detected
Product Name Event ID 5245 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC4_TABLE_LOCK_TIMEOUT_EXCEEDED Message
Product Name Event ID 5250 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC4_CRITICAL_DATABASE_PAGE_CORRUPT Messa
Product Name Event ID 5256 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC4_INCORRECT_PAGE_ID_IN_HEADER_NO_METADA
Product Name MSSQLSERVER Event ID 5512 Event Source MSSQLSERVER Component SQLEngine Symbolic Name FS_TRUNCATEDIR_FAILED Message Text Error 0
Product Name MSSQLSERVER Event ID 5515 Event Source MSSQLSERVER Component SQLEngine Symbolic Name FS_OPEN_CONTAINER_FAILED Message Text Co
No description available.
Product Name Event ID 556 Event Source MSSQLSERVER Component SQLEngine Symbolic Name WRONGPAGE Message Text INSERT EXEC failed b
No description available.
No description available.
Product Name Event ID 611 Event Source MSSQLSERVER Component SQLEngine Symbolic Name VAR_SIZE_TOO_BIG Message Text Cannot insert
No description available.
Product Name Event ID 6522 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SQLCLR_UDF_EXEC_FAILED Message Text A .NET
No description available.
Product Name Event ID 701 Event Source MSSQLSERVER Component SQLEngine Symbolic Name NOSYSMEM Message Text There's insufficient s
Product Name Event ID 7105 Event Source MSSQLSERVER Component SQLEngine Symbolic Name TXT_PGNOTEXIST Message Text The Database
No description available.
Product Name Event ID 7357 Event Source MSSQLSERVER Component SQLEngine Symbolic Name RMT_ZERO_COL_OBJECT Message Text Cannot process the object "%ls".
Product Event ID 7391 Event Source MSSQLSERVER Component SQLEngine Symbolic Name RMT_TRANS_JOIN_FAIL Message Text The operation
Product Event ID 7399 Event Source MSSQLSERVER Component SQLEngine Symbolic Name RMT_HRESULT_FAIL Message Text The OLE DB provide
Product Name Event ID 7711 Event Source MSSQLSERVER Component SQLEngine Symbolic Name PRT_RANGE_OVERLAP Message Text The DATA_CO
Product Name Event ID 7901 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC2_DATABASE_IN_EMERGENCY_MODE Message T
Product Name Event ID 7903 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC2_FS_ORPHANED_FILE Message Text Table
Product Name Event ID 7904 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC2_FS_MISSING_FILE Message Text Table
Product Name Event ID 7905 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC2_FS_INVALID_ROWSET_DIRECTORY Message Te
Product Name Event ID 7906 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC2_FS_INVALID_TOP_LEVEL_FILE Message Text
Product Name Event ID 7907 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC2_FS_INVALID_COLUMN_DIRECTORY Message T
Product Name Event ID 7908 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC2_FS_INVALID_COLUMN_LEVEL_FILE Message T
Product Name Event ID 7910 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC2_REPAIR_PAGE_ALLOCATED Message Text
Product Name Event ID 7911 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC2_REPAIR_PAGE_DEALLOCATED Message Text
Product Name Event ID 7912 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC2_REPAIR_EXTENT_ALLOCATED Message Text
Product Name Event ID 7913 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC2_REPAIR_EXTENT_DEALLOCATED Message Te
Product Name Event ID 7914 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC2_REPAIR_ALLOCATION_PAGE_REBUILT Message
Product Name Event ID 7915 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC2_REPAIR_IAM_CHAIN_REBUILT Message Tex
Product Name Event ID 7916 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC2_REPAIR_RECORD Message Text Repair:
Product Name Event ID 7920 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC2_SUMMARY_ENTRIES Message Text Processe
Product Name Event ID 7923 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC2_SUMMARY_TABLE_NAME Message Text Table
Product Name Event ID 7931 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC2_FS_DOUBLE_ROWSET_ACTUAL_FACT Message T
Product Name Event ID 7932 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC2_FS_ROWSET_IN_WRONG_FILEGROUP Message
Product Name Event ID 7933 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC2_FS_ORPHANED_ROWSET_DIRECTORY Message
Product Name Event ID 7934 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC2_FS_MISSING_ROWSET_DIRECTORY Message T
Product Name Event ID 7935 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC2_FS_MISSING_COLUMN Message Text Tabl
Product Name Event ID 7936 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC2_FS_ORPHANED_COLUMN_DIRECTORY Message
Product Name Event ID 7937 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC2_FS_MISSING_COLUMN_DIRECTORY Message
Product Name Event ID 7984 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC2_PRE_CHECKS_BAD_PAGE_TYPE Message Tex
Product Name Event ID 7986 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC2_PRE_CHECKS_CROSS_OBJECT_LINKAGE Mess
Product Name Event ID 7987 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC2_PRE_CHECKS_CHAIN_LINKAGE_MISMATCH Me
Product Name Event ID 7988 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC2_PRE_CHECKS_CHAIN_LOOP_DETECTED Messa
Product Name Event ID 7995 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC2_SYSTEM_CATALOGS_CORRUPT Message Text
Product Name Event ID 802 Event Source MSSQLSERVER Component SQLEngine Symbolic Name NO_BUFS Message Text There is insufficient m
No description available.
No description available.
No description available.
Product Name Event ID 832 Event Source MSSQLSERVER Component SQLEngine Symbolic Name B_CONSTPAGECHANGED Message Text A page t
Product Name Event ID 833 Event Source MSSQLSERVER Component SQLEngine Symbolic Name BUF_LONG_IO Mes
No description available.
Product Name Event ID 8443 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SB_DIALOG_WO_CONV_GROUP Message Text The
05/30/2025 Product Name Event ID 845 Event Source MSSQLSERVER Component SQLEngine Symbolic Name BUFLATCH_TIMEOUT Message Text Time-out occurred while w
No description available.
Product Name Event ID 847 Event Source MSSQLSERVER Component SQLEngine Symbolic Name N/A Message Text Time-out occurred while w
Product Name Event ID 8525 Event Source MSSQLSERVER Component SQLEngine Symbolic Name Message Text Distributed transaction comple
No description available.
Product Name Event ID 855 Event Source MSSQLSERVER Component SQLEngine Symbolic Name BAD_MEMORY_OUTSIDE_BPOOL Message Text Unco
Product Name Event ID 856 Event Source MSSQLSERVER Component SQLEngine Symbolic Name BAD_MEMORY_CLEAN_DATABASE_PAGE Message Tex
Product Name Event ID 8601 Event Source MSSQLSERVER Component SQLEngine Symbolic Name INVALID_INTERFACE_ERR Message Text Interna
Product Name Event ID 8621 Event Source MSSQLSERVER Component SQLEngine Symbolic Name OPTIMIZER_STACK_OVERFLOW_ERR Message Text
Product Name Event ID 8623 Event Source MSSQLSERVER Component SQLEngine Symbolic Name OPTIMIZER_NOPLAN_ERR Message Text The q
Product Name Event ID 8630 Event Source MSSQLSERVER Component SQLEngine Symbolic Name EXECUTION_ERR Message Text Internal Query
Product Name Event ID 8632 Event Source MSSQLSERVER Component SQLEngine Symbolic Name QUERY_EXPRESSION_TOO_COMPLEX Message Text
No description available.
Product Name Event ID 8645 Event Source MSSQLSERVER Component SQLEngine Symbolic N
No description available.
No description available.
Product Name Event ID 8680 Event Source MSSQLSERVER Component SQLEngine Symbolic Name REMOTE_ERR Message Text Internal Query Pr
Product Name Event ID 8689 Event Source MSSQLSERVER Component SQLEngine Symbolic Name USEPLAN_ERR_NO_DB Message Text Database '%
Product Name MSSQLSERVER Event ID 8710 Event Source MSSQLSERVER Component SQLEngine Symbolic Name QUERY2_CUBE_ILLEGAL_AGG_FUNC Message Te
Product Name Event ID 8712 Event Source MSSQLSERVER Component SQLEngine Symbolic Name USEPLAN_ERR_NO_INDEX Message Text Index '
Product Name Event ID 8966 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC3_FAILED_TO_READ_AND_LATCH_PAGE Message
Product Name Event ID 8974 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC3_OFF_ROW_DATA_NODE_HAS_TWO_PARENTS M
Product Name Event ID 898 Event Source MSSQLSERVER Component SQLEngine Symbolic Name BPOOL_SCAN_LONG_DURATION Message Text Ce
06/09/2025 Product Name Event ID 8992 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC3_CHECK_CATALOG Message Text Check Catalog Msg ERRO
Product Name Event ID 8993 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC3_MISSING_FORWARDED_ROW Message Text
Product Name Event ID 8994 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC3_MISSING_FORWARDING_ROW Message Text
Product Name Event ID 8996 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBCC3_IAM_PAGE_RANGE_IN_WRONG_FILEGROUP Me
No description available.
Product Name Event ID 9002 Event Source MSSQLSERVER Component SQLEngine Symbolic Name LOG_IS_FULL Message Text The transaction
No description available.
Product Name Event ID 9004 Event Source MSSQLSERVER Component SQLEngine Symbolic Name LOG_CORRUPT Message Text An error occurre
Product Name Event ID 9017 Event Source MSSQLSERVER Component SQLEngine Symbolic Name LOG_MANY_VLFS Message Text Database %ls has more than %d virtual
Product Name Event ID 905 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBSTARTUP_EE_PARTITIONING Message Text Dat
2019 (15.x) and later - Windows only Product Name Event ID 912 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DB_RUN
Product Name Event ID 916 Event Source MSSQLSERVER Component SQLEngine Symbolic Name NOTUSER Message Text The server principal "
Product Name Event ID 926 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DB_SUSPECT Message Text Database '%.*ls' c
Product Name Event ID 945 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DB_IS_SHUTDOWN Message Text Database '%.*l
No description available.
Product Name Event ID 9254 Event Source MSSQLSERVER Component SQLEngine Symbolic Name XMLERR_INVALID_COLUMNSET_XML Message Text
Product Name Event ID 9532 Event Source MSSQLSERVER Component SQLEngine Symbolic Name XMLERR_COLUMNSET_CANNOT_CONVERT_FROM_TO Me
Product Name Event ID 9692 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SB2_CANT_LISTEN_PORT_IN_USE Message Text T
Product Name Event ID 9790 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SB3_XMIT_ERROR_ENTRANCE_BROKER_SINGLE_USER
No description available.
Product Name Event ID 9955 Event Source MSSQLSERVER Component SQLEngine Symbolic Name FTXT2_MSSEARCHACCESSDENY Message Text S
No description available.
Explanations for the schemas, tables, and stored procedures in the WideW
The WideWorldImporters database contains all the transaction information and daily data for sales and purchases, as well as sensor
08/26/2025 When an error is raised by the SQL Server Database Engine, the severity of the error indicates the type of problem encountered by SQL Server.
development partners 09/09/2025 For support developing SQL Server database solutions, choose from a wide variety of industry- leading tools. This article highlig
SQL Server docs navigation guide This article provides some tips and tricks for navigating the SQL Server technical documentation space. The SQL Server hub page can be found at https://aka.ms/sqld
Anyone can contribute to SQL Server documentation. This includes correcting typos, suggesting b
Tutorials, quickstarts, and other educational resources meant to teach you to work with SQL Server and Azure SQL Database. ｄ Azure SQL for beginners Azure SQL fundamentals Azure SQL hands-on labs
No description available.
The released versions of the WideWorldImporters and WideWorldImportersDW databases have data from January 1, 2013, up to the day t
SQL Server help and feedback ﾃ Summarize this article for me This article explains different ways to get assistance with an issue or provide feedback for SQL Server or the SQL Server technical doc
high availability and disaster 09/08/2025 To provide high availability and disaster recovery for your SQL Server services, choose from a wide variety of industry
This article contains installation and config
Wide World Importers OLTP database installation and configuration instructions. SQL Server 2016 (or higher) or Azure SQL Databas
managing partners 09/09/2025 To manage your SQL Server services, choose from a wide variety of industry-leading tools. This article highlights Microsoft partner
Product Name Product Version 11
No description available.
WideWorldImporters use of SQL Server features and capabilities in the OLTP database.
This page provides video content for learning about Transact-SQL (T-SQL). In this video series , you learn the basics of Transact-SQL.
SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft F
High Availability
ﾃ Summarize this article for me This article describes how to add a secondary database to an existing log shipping configuration in SQL Server by using SQL Server Managemen
This topic describes how to add dependencies to an Always On failover cluster instance (FCI) resource by using the Failover Cluster Manager snap-in. T
Use this procedure to manage nodes to an existing SQL Server failover cluster instance.
If the database mirroring endpoints use Windows Authentication, you can use SQL Server Management Studio to add or replace a witness.
Use the to help you add a new secondary replica to an existing Always On availability group.
This topic describes how to add a secondary replica to an existing Always On availability group by using SQL Server Management Studio, Transact-SQL, o
To set up a witness for a database, the database owner assigns a Database Engine instance to the role of witness server.
Maintenance tasks like adding or removing nodes from an existing Always On Failover Cluster Instance (FCI) are accomplished using the SQL Server Setup
No description available.
No description available.
Automatic page repair is supported by database mirroring and by Always On availability groups.
In SQL Server 2012 and 2014, the only way to initialize a secondary replica in a SQL Server Always On availability group is to use backup, copy, and r
08/29/2025 : Availability Database Suspension State : Availability database is suspended. : Warning : Availability database This policy checks the state of data movement
: Availability Group Automatic Failover Readiness : Availability group is not ready for automatic failover.
: Availability Group Online State : Availability group is offline.
06/26/2025 In Always On availability groups, the availability mode is a replica property that determines whether a given availability replica can run in synchronous-commit
: Availability Replica Role State : Availability replica does not have a healthy role.
: Availability Replica Join State : Availability Replica is not joined.
on Azure VM This article introduces Always On availability groups (AG) for SQL Server on Azure Virtual Machines (VMs). To get started, see the Availability group tutorial
The Always On availability groups active secondary capabilities include support for taking backups on secondary replicas. Backup operations can put significant strain on I/O
10/24/2025 Always On basic availability groups provide a high availability solution for SQL Server 2016 (13.x) and later versions on Standard edition. A basic availability g
Before you install a SQL Server failover cluster, you must select the hardware and the operating system on which SQL Server will run.
This topic describes how to change the availability mode of an availability replica in an Always On availability group in SQL Server by using SQL Serv
This topic describes how to change the failover mode of an availability replica in an Always On availability group in SQL Server by using SQL Server M
No description available.
This topic describes how to configure the session-timeout period of an Always On availability replica by using SQL Server Management Studio, Transact-
- Windows only This topic describes how to switch the HADR cluster context of an instance of SQL Server by using Transact-SQL in SQL Server 2012 SP1
This topic describes how to change the IP address resource in an Always On Failover Cluster Instance (FCI) by using the Failover Cluster Manager snap-
Transaction safety is the attribute that controls the operating mode of the session. At any time, however, the database owner can change the transacti
Use this page to specify which server instances you want to configure now. You must select at least one server instance before continuing the wizard.
In an Always On availability group, you can configure one or more availability replicas to allow read-only connections when running under the secondar
on Windows This topic describes the requirements and steps for clustering the Microsoft Distributed Transaction Coordinator (DTC) service for Always On availability groups.
No description available.
ﾃ Summarize this article for me This article describes how to configure log shipping in SQL Server by using SQL Server Management Studio or Transact-SQL.
No description available.
2016 introduced automatic seeding of availability groups. When you create an availability group with automatic seeding, SQL Server automati
This topic describes how to configure backup on secondary replicas for an Always On availability group by using SQL Server Management Studio, Transact
05/27/2025 To create a distributed availability group, you must create two availability groups each with its own listener. You then combine these availability groups into a
Use the FailureConditionLevel property to set the conditions for the Always On Failover Cluster Instance (FCI) to fail over or restart.
- Windows only This topic describes how to configure the flexible failover policy for an Always On availability group by using Transact-SQL or PowerS
2017 (14.x) and later versions support all distributed transactions including databases in an availability group.
No description available.
This article contains information about the requirements for configuring an instance of SQL Server to support Always On availability groups in SQL Ser
This topic describes how to configure NodeWeight settings for a member node in a Windows Server Failover Clustering (WSFC) cluster. NodeWeight setting
By default both read-write and read-intent access are allowed to the primary replica and no connections are allowed to secondary replicas of an Always
To configure an Always On availability group to support read-only routing in SQL Server, you can use either Transact-SQL or PowerShell.
You can configure a SQL Server Always On availability group for read-scale workloads on Windows. There are two types of architecture for availability
- Windows only Configuring SQL Server replication and Always On availability groups involves seven steps.
To connect to a database mirroring session, a client can use either SQL Server Native Client or .NET Framework Data Provider for SQL Server.
This article teaches you how to connect to an Always On availability group listener for SQL Server.
ﾃ Summarize this article for me SQL Server 2022 (16.x) A contained availability group is an Always On availability group (AG) that supports: managing metadata objects (users, logins,
This article contains information about the using a contained database with Always On availability groups in SQL Server. Before adding a contained database to an availabilit
No description available.
This topic describes how to create a database mirroring endpoint that uses Windows Authentication in SQL Server by using Transact-SQL.
- Windows only This article walks you through a complete configuration of a clustered DTC resource for a SQL Server Always On availability group (AG)
This topic describes how to create a database mirroring endpoint for use by Always On availability groups in SQL Server by using PowerShell. Requires
This article describes how to create or configure a single availability group listener for an Always On availability group by using SQL Server Mana
02/05/2024 The topics in this section explain how to deploy a Always On availability groups implementation on instances of SQL Server 2012 (11.x) that reside on different Wi
: Availability Database Data Synchronization State : Data synchronization state of availability database is not healthy. : Warning : Availability d
: Availability Replica Data Synchronization State : Data synchronization state of some availability database is not healthy. : Warning : Availabili
Starting in SQL Server 2016, database level health detection (DB_FAILOVER) option is available when configuring an Always On availability group. The d
09/02/2025 Database mirroring is a solution for increasing the availability of a SQL Server database. Mirroring is implemented on a per-database basis and works only with d
The Database Mirroring Monitor is part of the SQL Server Monitor, which is launched from SQL Server Management Studio. 1.
If you have the correct permissions, you can use Database Mirroring Monitor to monitor any subset of the mirrored databases on a server instance. Moni
You can create a database snapshot on a primary or secondary database in an availability group. The replica role must be either or , and can't be in the state. You should
You can take advantage of a mirror database that you are maintaining for availability purposes to offload reporting.
All critical errors and warning events for the SQL Server Resource DLL are written to the Windows event log. A running log of the diagnostic informati
This topic describes how to add a database to an Always On availability group by using SQL Server Management Studio, Transact-SQL, or PowerShell in SQ
This topic contains information about how to use the dialog box of SQL Server Management Studio to create an Always On availability group on instance
No description available.
A distributed availability group (AG) is a special type of availability group that spans two separate availability groups.
This article describes cross-database and distributed transactions support for Always On availability groups and database mirroring. SQL Server 2017
Always On availability groups (AGs) require an underlying Windows Server Failover Cluster (WSFC).
This article describes considerations for client connectivity to Always On availability groups, including prerequisites, restrictions, and recommendations for client configur
No description available.
No description available.
This article contains information about the using currently encrypted or recently decrypted databases with Always On availability groups in SQL Server
08/29/2025 - Windows only To participate in Always On availability groups or database mirroring a server instance requires its own, dedicated d
In SQL Server 2012 and 2014, if a database participating in an availability group on the primary replica loses the ability to write transactions, it w
To establish a database mirroring session and to modify the properties of database mirroring for a database, use the page of the dialog box.Before y
After the mirror database is prepared (see Prepare a Mirror Database for Mirroring (SQL Server) ), you can establish a database mirroring session. T
No description available.
This example shows all the stages required to create a database mirroring session using certificate-based authentication. The examples in this topic u
SQL) This example shows all the stages required to create a database mirroring session with a witness using Windows Authentication. The examples in t
defines Extended Events that are specific to availability groups. You can monitor these Extended Events in a session to help with root-caus
2016 (13.x) and later versions Azure SQL Managed Instance You can mirror databases from SQL Server (2016-2025), Azure S
No description available.
06/16/2025 This article describes failover and failover modes for SQL Server Always On availability groups .
No description available.
08/26/2025 - Windows only Always On availability groups, the high availability and disaster recovery solution introduced in SQL Server 2012 (11.x), requires Windows Server
No description available.
Failing over to a log shipping secondary is useful if the primary server instance fails or requires maintenance. Typically, the primary and secondary
- Windows only This article contains information about the using the FILESTREAM and FileTable features with Always On availability groups in SQL Serv
This topic describes the steps for configuring server instances to use certificates to authenticate inbound connections for database mirroring. Before
This topic describes the steps for configuring server instances to use certificates to authenticate outbound connections for database mirroring. Outbo
This topic describes how to force a Windows Server Failover Clustering (WSFC) cluster node to start without a quorum. This may be required in disaster
No description available.
10/06/2025 This article describes how to perform a forced failover (with possible data loss) on an Always On availability group by using SQL Server Management Studio, Transa
No description available.
No description available.
resource DLL health diagnostic To monitor the health of the primary availability replica, the SQL Server resource DLL run by the Windows S
Use this dialog box to view the history of mirroring status for a mirrored database on a specified server instance. Start Database Mirroring Monitor
Managing an existing Always On availability group in SQL Server involves one or more of the following tasks: Altering the properties of an existing a
Use this page to specify whether you want to include a witness server in this security configuration for database mirroring. Establish a Database Mir
Client tools such as SQL Server Management Studio are shared features common across all instances on the same machine. They are backward compatible, w
08/26/2025 To install a SQL Server failover cluster, you must create and configure a failover cluster instance by running SQL Server Setup. To install a failover cluster, y
This article documents interoperability of Always On availability groups with other SQL Server features. The following table lists SQL Server feature
Database mirroring can be used with the following features or components of SQL Server: Always On Failover Cluster Instances (SQL Server Failover Clus
This topic explains how to join a secondary database to an Always On availability group by using SQL Server Management Studio, Transact-SQL, or PowerS
08/26/2025 This topic describes how to join a secondary replica to an Always On availability group by using SQL Server Management Studio, Transact-SQL, or PowerShell in SQL
No description available.
No description available.
A given database can be mirrored or log shipped; it can also be simultaneously mirrored and log shipped.
Log shipping involves two copies of a single database that typically reside on different computers. At any given time, only one copy of the database i
Use this page to configure and to modify the properties of the log shipping monitor server. For an explanation of log shipping concepts, see About Lo
You should routinely maintain the same set of user logins and SQL Server Agent jobs on every primary database of an Always On availability group (AG),
No description available.
When the mirrored database is synchronized (that is, when the database is in the SYNCHRONIZED state), the database owner can initiate manual failover
When the mirrored database is synchronized (that is, when the database is in the SYNCHRONIZED state), the database owner can initiate manual failover
This topic describes how to prepare a database for an Always On availability group in SQL Server by using SQL Server Management Studio, Transact-SQL,
No description available.
No description available.
Use this page to specify information about the server instance with the mirror database. Establish a Database Mirroring Session Using Windows Authenti
During a database mirroring session, the mirrored database is always in a specific state (the mirroring state ). The state of the database reflects t
After you have configured log shipping, you can monitor information about the status of all the log shipping servers.
To monitor the properties and state of an Always On availability group you can use the following tools. System Center Monitoring pack for SQL Serv
The performance aspect of Always On Availability Groups is crucial to maintaining the service- level agreement (SLA) for your mission-critical databas
No description available.
multi-subnet clustering 08/26/2025 A SQL Server multi-subnet failover cluster is a configuration in which each failover cluster node is connected to a different
This topic describes the synchronous and asynchronous operating modes for database mirroring sessions. This section introduces a few terms that are c
No description available.
This topic describes how to pause or resume database mirroring in SQL Server by using SQL Server Management Studio or Transact-SQL. Security SQL Ser
The database owner can pause and later resume a database mirroring session at any time. Pausing preserves the session state while suspending mirroring
This topic describes how to perform a manual failover without data loss (a planned manual failover ) on an Always On availability group by using SQL
The Always On availability groups system policies are used by the Always On Dashboard to provide information on the availability group health to the u
The Always On availability groups health model evaluates a set of predefined policy based management (PBM) policies.
Physical, operating system, or SQL Server problems can cause a failure in a database mirroring session.
Physical, operating system, or SQL Server problems can cause a failure in a session between two availability replicas. An availability replica doesn't
This topic describes how to use PowerShell cmdlets to create and configure an Always On availability group by using PowerShell in SQL Server.
Microsoft PowerShell is a task-based command-line shell and scripting language designed especially for system administration. Always On availability g
Before a database mirroring session can start, the database owner or system administrator must make sure that the mirror database has been created and is ready for mirroring.
Prerequisites, restrictions, and This article describes considerations for deploying Always On availability groups, including prerequisites, restrictions, and recommendation
Prerequisites, Restrictions, and This topic describes the prerequisites and recommendations for setting up database mirroring.
Use this page to specify information about the server instance of the principal database.
This topic discusses special considerations for maintaining a publication database when you use Always On availability groups. Maintaining an Always
Both SQL Server Always On availability groups and Always On Failover Cluster Instances (FCI) take advantage of Windows Server Failover Clustering (WSF
Whenever a witness is set for a database mirroring session, quorum is required. Quorum is a relationship that exists when two or more server instanc
No description available.
No description available.
No description available.
This topic describes how to recover from cluster failures by using the Failover Cluster Manager snap-in after a failover occurs in SQL Server. The Fai
Use this dialog box to register one or more mirrored databases on a given server instance by adding the database or databases to the Database Mirrorin
Always On availability groups can provide a high-availability and disaster recovery solution for Remote Blob Store (RBS) BLOB objects (bl
ﾃ Summarize this article for me This article describes how to remove log shipping in SQL Server by using SQL Server Management Studio or Transact-SQL. 1.
Use this procedure to uninstall an Always On SQL Server failover cluster instance. Consider the following important points before you uninstall a SQL
ﾃ Summarize this article for me This article describes how to remove a log shipping secondary database in SQL Server by using SQL Server Management Studio or Transact-SQL.
This article describes how to delete (drop) an Always On availability group by using SQL Server Management Studio, Transact-SQL, or PowerShell in SQL
This topic describes how to remove an availability group listener from an Always On availability group by using SQL Server Management Studio, Transact
This topic describes how to remove database mirroring from a database in SQL Server by using SQL Server Management Studio or Transact-SQL.
The database owner can manually stop a database mirroring session at any time, at either partner. When mirroring is removed, the following occurs: T
No description available.
This topic describes how to remove a secondary replica from an Always On availability group by using SQL Server Management Studio, Transact-SQL, or Po
This topic describes how to remove a secondary database from an Always On availability group by using SQL Server Management Studio, Transact-SQL, or P
This topic describes how to remove a witness from a database mirroring session in SQL Server by using SQL Server Management Studio or Transact-SQL. At
No description available.
Database mirroring can be used in conjunction with replication to improve availability for the publication database. Database mirroring involves two c
Replication, change data capture (CDC), and change tracking (CT) are supported on Always On availability groups.
This article contains information about configuring Reporting Services to work with Always On availability groups (AG) in SQL Server. The three scenar
You can resume a suspended availability database in Always On availability groups by using SQL Server Management Studio, Transact-SQL, or PowerShell i
Some diagnostic Always On availability group (AG) information can be obtained from the SQL Server ring buffers, or the dynamic management view (DMV).
Within the context of a database mirroring session, the principal and mirror roles are typically interchangeable in a process known as role switching
: Availability Database Join State : Secondary database is not joined.
Use this dialog box to configure and to modify the properties of a secondary database in the log shipping configuration.
No description available.
When using Windows Authentication, if the server instances use different accounts, specify the service accounts for SQL Server. These service accounts
This topic contains information about configuring Service Broker to work with Always On availability groups in SQL Server. 1. For more information,
This topic describes the prerequisites and recommendations for setting up database mirroring. For an introduction to database mirroring, see Database Mirroring (SQL Server)
No description available.
Use this dialog box to enable and configure one or more warning thresholds for the database selected in the navigation tree of the dialog box. The d
: Availability Replicas Connection State : Some availability replicas are disconnected.
: Availability Replicas Data Synchronization State : Some availability replicas are not synchronizing data.
: Availability Replicas Role State : Some availability replicas do not have a healthy role.
: Synchronous Replicas Data Synchronization State : Some synchronous replicas are not synchronized.
Setting up a database mirroring session requires a server network address for each of the server instances.
To host an availability replica for an availability group, a server instance must possess a database mirroring endpoint.
- Windows only An Always On availability group is a predefined collection of SQL Server relational databases that failover together when conditions t
error log (Always On The SQL Server error log reports events affecting Always On Availability Groups, such as: Communication with the Wind
This topic describes how to use the pane of SQL Server Management Studio to monitor and manage existing Always On availability groups, availability r
This topic contains information about how to start data synchronization after you add a database to an Always On availability group.
No description available.
When an Always On availability group (AG) fails over, containing a database that is a replication subscriber, the replication subscription might fail.
You can suspend an availability database in Always On availability groups by using SQL Server Management Studio, Transact-SQL, or PowerShell in SQL Se
Description sys.database_mirroring_witnesses Contains a row for every witness role that a server plays in a database mirroring partnership. Descrip
10/21/2025 - Windows only This article serves as a reference page to all the various system objects that can be used when working with availability groups (AGs). Descripti
For monitoring availability groups and replicas and the associated databases by using Transact- SQL, Always On availability groups provides a set of c
This topic introduces the Transact-SQL statements that support deploying Always On availability groups and creating and managing an given availability
This topic describes how to use Transact-SQL to create and configure an availability group on instances of SQL Server on which the Always On availabil
This topic describes all of the tables and stored procedures associated with a log shipping configuration. All log shipping tables are stored in on e
This topic describes how to take an Always On availability group from the ONLINE state to the OFFLINE state by using Transact-SQL in SQL Server 2012 S
Use this dialog box to configure and modify the transaction log backup settings for a log shipping configuration. For an explanation of log shipping
Transport security involves authentication and, optionally, encryption of messages exchanged between the databases. For database mirroring and Always On availability groups,
This article provides information to help you troubleshoot typical problems with configuring server instances for Always On availability groups. Typical configuration problem
This topic provides information to help you troubleshoot problems in setting up a database mirroring session.
In some Always On availability group deployments, file paths differ between the system that hosts the primary replica and systems that host a secondary replica. If the file p
No description available.
No description available.
No description available.
The client application completes an update on the primary replica successfully, but querying the secondary replica shows that the change is not reflec
10/21/2025 This article provides information about the following issues: Basic troubleshooting steps Recover from a failover cluster failure Resolve the most common failov
This guide helps you get started on monitoring availability groups and troubleshooting some of the common issues in availability groups.
By default, SQL Server compresses data streams where appropriate for availability groups.
No description available.
ﾃ Summarize this article for me SQL Server supports upgrading a failover cluster to a new version of SQL Server, to a new SQL Server service pack or cumulative update, or w
ﾃ Summarize this article for me To preserve your log shipping disaster recovery solution, upgrade, or apply servicing updates in the appropriate order.
08/15/2025 When upgrading a SQL Server instance that hosts an Always On availability group (AG) to a new SQL Server version, to a new SQL Server service pack or cumulative u
To enable certificate authentication for database mirroring on a given server instance, the system administrator must configure each server instance t
When a database is backed up, the TRUSTWORTHY database property is set to OFF. Therefore, on a new mirror database TRUSTWORTHY is always OFF.
This article lists useful links to tools for troubleshooting and performance tuning for Always On Availability Groups. Always On Availability Groups
No description available.
This topic describes how to determine the operational health of an Always On availability group by using an Always On policy in SQL Server Management
No description available.
This topic describes how to view NodeWeight settings for each member node in a Windows Server Failover Clustering (WSFC) cluster. NodeWeight settings
This topic describes how to view the properties of an availability replica for an Always On availability group by using SQL Server Management Studio o
This topic explains how to view the Transaction Log Shipping Status report in SQL Server Management Studio. You can run a status report at a monitor s
During a database mirroring session, you can view the status on the page of the dialog box. 1.
When troubleshooting Always On Availability Groups latency, wait statistics can be monitored for accumulation using the availability groups-specific w
This topic contains information about the SQL Server events for which warning thresholds can be configured and managed for database mirroring.
Displays a read-only list of warnings supported on database mirroring events and the specified warning threshold values, if available. Start Database
08/26/2025 SQL Server Always On failover cluster instances use Windows Server Failover Clustering (WSFC) to provide local high availability. A failover cluster instance (FCI
No description available.
No description available.
No description available.
Use this page to specify information about the server instance that is to serve as the witness for the session. Establish a Database Mirroring Sessio
Use the Add Database to Availability Group Wizard to help you add one or more databases to an existing Always On availability group.
This topic describes how to use the in SQL Server Management Studio to create and configure an Always On availability group in SQL Server. An availa
- Windows only : WSFC Cluster State : WSFC cluster service is offline. : : Instance of SQL Server This policy checks the state of the Windows Serv
Configuration
06/06/2025 This tutorial is intended for users who are new to SQL Server and who have installed SQL Server or SQL Server Express.
When you install the SQL Server Database Engine, the tools that are installed depend upon the edition and your setup choices. This lesson describes the principal tools, and d
No description available.
Granting a user access to a database involves three steps. F
08/26/2025 For enhanced security, the Database Engine of SQL Server Developer, Express, and Evaluation editions can't be accessed from another computer when initially instal
This short lesson removes the objects that you created in Le
Administrative and operational procedures for SQL Server.
No description available.
This tutorial illustrates signing stored procedures using a certificate generated by SQL Server. Signi
2016 (13.x) and later versions This tutorial helps you understand how to use the Azure Blob Storage for data files and backups in SQL Server 2016 (13.x) and later versions.