PrepAway - Latest Free Exam Questions & Answers

12 Comments on “Is the SQL Server Audit feature supported in the Amazon RDS SQL Server engine?

  1. Chef says:

    No. it does not.

    Amazon RDS currently does not support the following SQL Server features:

    Maintenance Plans
    Database Mail
    Distributed Queries (i.e., Linked Servers)
    Database Log Shipping
    Change Data Capture (CDC) – Consider using Change Tracking as an alternative to CDC.
    Replication
    The ability to run Reporting, Analysis, Integration, or Master Data Services on the same server as the DB instance. If you need to do this, we recommend that you either install SQL Server on an EC2 instance or use an on-premise SQL Server instance to act as the Reporting, Analysis, Integration, or Master Data Services server.
    Performance Data Collector
    Service Broker or additional T-SQL endpoints (all operations using CREATE ENDPOINT are unavailable)
    Distribution Transaction Coordinator (MSDTC)
    WCF Data Services
    FILESTREAM support
    Policy-Based Management
    SQL Server Audit
    BULK INSERT and OPENROWSET(BULK…) features
    Data Quality Services
    Instant file initialization
    Always On (2012 Enterprise Edition)
    File tables
    Server level triggers




    0



    0
  2. Ran says:

    The following Microsoft SQL Server features are not supported on Amazon RDS:

    Always On (2012 Enterprise Edition)

    Stretch database

    Backing up to Microsoft Azure Blob Storage

    Buffer pool extension

    BULK INSERT and OPENROWSET(BULK…) features

    Data Quality Services

    Database Log Shipping

    Database Mail

    Distributed Queries (i.e., Linked Servers)

    Distribution Transaction Coordinator (MSDTC)

    File tables

    FILESTREAM support

    Maintenance Plans

    Performance Data Collector

    Policy-Based Management

    PolyBase

    R

    Replication

    Resource Governor

    SQL Server Audit

    Server-level triggers

    Service Broker endpoints

    T-SQL endpoints (all operations using CREATE ENDPOINT are unavailable)

    WCF Data Services




    0



    0

Leave a Reply

Your email address will not be published. Required fields are marked *