Overview

Service Overview

Microsoft SQL Server(DBaaS) is a representative relational database management system (RDBMS) used in various applications. Samsung Cloud Platform provides an environment that can automate Microsoft SQL Server installation and perform management functions for operation through a web-based console.

Microsoft SQL Server (DBaaS) is designed with an Always On‑based availability architecture, so when the Primary server’s content changes, it is synchronously replicated to the Secondary server. Additionally, it provides an automatic backup feature at user-specified times to prepare for issues with the DB server or data, enabling recovery of data at the desired point in time.

Provided features

Microsoft SQL Server (DBaaS) provides the following features.

• Auto Provisioning (Auto Provisioning): UI allows installation and configuration of Database (DB), and provides a Primary-Secondary redundancy configuration built on Always On. * When the Primary server fails, it automatically fails over to the Secondary.
• Operation Control Management: Provides a function to control the status of running servers. * In addition to start and stop, a restart is possible if there is a DB issue or to apply configuration changes. * When high availability (HA) is configured, the node transition between Primary and Secondary can be performed directly by the user through a switch-over.
• Backup and Recovery: Provides data backup functionality based on its own backup commands. * Backup time slots and storage locations, as well as the day of full backups, can be set by the user, and additional fees may apply based on backup size. * It also provides a recovery feature for backed‑up data, so when a user initiates a recovery, a separate database is created and the recovery proceeds to the point in time selected by the user (the backup creation time or a user‑specified time). * When restoring to a user-specified point in time, you can set the restore point up to 5 minutes, 10 minutes, 30 minutes, or 1 hour before the stored backup and archive files.
• Version Management: Provides a Minor version upgrade feature based on some functionality improvements and security patches.
• Secondary configuration: It is possible to add a Read Replica (Secondary Replica) for read load balancing and disaster recovery (DR).
• Audit setting: Provides an Audit setting feature that can monitor users’ DB access and the results of DDL (Data Definition Language)/DML (Data Manipulation Language) operations.
• Parameter management: You can modify DB configuration parameters related to performance improvement and security.
• Service Status Query: Retrieves the final status of the current DB service.
• Monitoring: CPU, memory, performance monitoring information can be viewed through Cloud Monitoring and Servicewatch.
• DB User Management: View and manage the DB account (user) information registered in the DB.
• DB Log Export: You can export stored logs to the user’s Object Storage through Audit settings.

Components

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

Engine version

The engine versions supported by Microsoft SQL Server(DBaaS) are as follows.

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

Since the EOS and EoTS dates may change according to the supplier’s policy, please refer to the supplier’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.

Please refer to Microsoft SQL Server(DBaaS) 서버 타입 for detailed information about the server types provided by Microsoft SQL Server (DBaaS).

Standard db1v2m4

Preceding Service

This is a list of services that must be pre‑configured before creating the service. For detailed information, please refer to the guide provided for each service and prepare in advance.