Overview

Service Overview

Microsoft SQL Server (DBaaS) is a representative relational database management system (RDBMS) used in a wide range of applications. The Samsung Cloud Platform provides an environment that automates the installation of Microsoft SQL Server through a web-based console and performs management functions for operations.

Microsoft SQL Server (DBaaS) is designed with an Always On-based availability architecture, synchronously replicating changes from the primary server to the secondary server. Additionally, to prepare for issues with the DB server or data, it provides an automatic backup feature at user-specified times, enabling data recovery at the desired point in time.

Features

Microsoft SQL Server (DBaaS) provides the following features.

• Auto Provisioning: You can install and configure the database (DB) through the UI, and it provides a primary-secondary high-availability configuration based on Always On. * If the primary server fails, the system automatically fails over to the secondary server.
• Operational Control Management: Provides functionality to control the status of running servers. * In addition to start and stop, you can restart the service to address database issues or apply configuration changes. * When high availability (HA) is configured, you can manually perform a switch-over to switch the primary and secondary nodes.
• Backup and Recovery: Provides a data backup feature based on proprietary backup commands. * Backup time zones, retention periods, and full backup days are user-configurable, and additional fees apply based on backup capacity. * It also provides a data restoration feature. When a user initiates a restore, a separate database is created, and the restoration process proceeds to the user-selected point in time (either the backup storage point or a custom point in time). * When restoring to a user-specified point in time, the restore point can be set up to 5 minutes, 10 minutes, 30 minutes, or 1 hour before the time, based on the stored backup and archive files.
• Version Control: Provides minor version upgrade functionality for certain feature improvements and security patches.
• Secondary Configuration: You can configure additional Read Replicas (Secondary Replicas) for read load balancing and disaster recovery (DR).
• Audit Configuration: Provides an audit configuration feature that monitors users’ database access and the results of DDL (Data Definition Language) and DML (Data Manipulation Language) operations.
• Parameter management: You can modify DB configuration parameters related to performance improvements and security.
• Service Status Check: Retrieves the final status of the current DB service.
• Monitoring: You can view CPU, memory, and performance monitoring information through Cloud Monitoring and Servicewatch.
• DB User Management: Query and manage DB account (user) information registered in the DB.
• Export DB Logs: You can export logs stored through audit settings to the user’s Object Storage.

Components

Microsoft SQL Server (DBaaS) provides pre-validated engine versions and a variety of server types. Users can select and use the appropriate option based on the scale of the service they want to configure.

Engine version

The following engine versions are supported in Microsoft SQL Server (DBaaS).

Technical support is available until the supplier’s End of Technical Service (EoTS) date. The End of Sale (EOS) date, when new creation is discontinued, is set six months before the EoTS date.

Because the EOS and EoTS dates may change depending on the vendor’s policies, please refer to the vendor’s license management policy page for details.

• Microsoft SQL Server: https://learn.microsoft.com/ko-kr/lifecycle/products/?terms=sql%20server

Server type

The server types supported by Microsoft SQL Server (DBaaS) are as follows.

For details on the server types provided by Microsoft SQL Server (DBaaS), see Microsoft SQL Server (DBaaS) server types.

Standard db1v2m4

Preceding Service

A list of services that must be configured before creating the specified service. For details, refer to the guides provided for each service and prepare in advance.