基本的な可用性グループを作成するには、CREATE AVAILABILITY GROUPTransact-SQL コマンドを使用して、WITH BASIC(既定値はADVANCED) オプションを指定します。 基本的な可用性グループは、バージョン 17.8 以降の SQL Server Management Studio の UI を使用して作成すること...
适用于SQL Server- 仅限 Windows 目标为 Microsoft Azure 的 SQL Server 托管备份管理并自动执行将 SQL Server 备份到 Microsoft Azure Blob 存储。 你可以选择允许 SQL Server 基于你的数据库的事务工作负荷确定备份计划,或者使用高级选项来定义计划。 保留期设置可确定备份存储在 Azure Blob 存储上的时间。 目标为...
Applies to:SQL Server When connecting to a SQL Server instance, you may encounter one or more of the followingerror messages. This article provides some steps to help you troubleshoot these errors, which are provided in order of the issues from simple to complex. ...
Log truncation deletes inactive virtual log files from the logical transaction log of a SQL Server database, freeing space in the logical log for reuse by the physical transaction log. If a transaction log is never truncated, it will eventually fill all the disk space that is allocated to ...
以下示例演示 MICROSOFT SQL Server 中的 XML 大容量加载功能。 每个示例都提供了 XSD 架构及其等效的 XDR 架构。 Bulk Loader 脚本 (ValidateAndBulkload.vbs) 以下脚本(用 Microsoft Visual Basic Scripting Edition (VBScript)编写的脚本将 XML 文档加载到 XML DOM;根据架构验证它;如果文档有效,则执行 XML 大容量...
For more information with examples that include transactions, see TRY...CATCH (Transact-SQL). Beginning with SQL Server 2012 (11.x), you can use the THROW statement to raise an exception and transfers execution to a CATCH block of a TRY...CATCH construct. For more information, see THROW...
OPENROWSETalso supports bulk operations through a built-inBULKprovider that enables data from a file to be read and returned as a rowset. Many examples in this article only apply to SQL Server only. Details and links to similar examples on other platforms: ...
This is an advanced configuration. Only attempt it if you are an experienced SQL server administrator familiar with transaction replication, and you have the necessary skills to deploy it successfully. This is the same as scenario 3, but extends it to situations where multiple StoreFront...
ChooseAdvanced Select the requiredODBC translatorfrom the list and begin the capture again. Data Migration This section contains Microsoft SQL Server and Sybase Adaptive Server data migration questions. Does the Migration Workbench support offline data loading in Microsoft SQL Server or Sybase Adaptive Se...
You can connect to any target Oracle database schema using standard Oracle database authentication. Once connected, you can perform operations on objects in the database.You can connect to schemas for selected third-party (non-Oracle) databases, such as MySQL, Microsoft SQL Server, Sybase ...