Microsoft SQL Server(DBaaS)

• 1: Overview
• 1.1: Server Type
• 1.2: Monitoring Metrics
• 2: How-to guides
• 2.1: Managing DB Services
• 2.2: DB Backup and Recovery
• 2.3: Add Secondary
• 2.4: Microsoft SQL Server(DBaaS) server connection
• 3: API Reference
• 4: CLI Reference
• 5: Release Note

1 - 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 the installation of Microsoft SQL Server through a web-based console and perform management functions for operation.

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

Provided Features

Microsoft SQL Server(DBaaS) provides the following features.

• Auto Provisioning: Allows installation and configuration of Database (DB) via UI, provides a Primary-Secondary redundancy configuration built on Always On. In case of Primary server failure, it automatically fails over to Secondary.
• Operation Control Management: Provides a function to control the status of running servers. In addition to start and stop, restart is possible if there is an issue with the DB or to apply configuration values. When configured for high availability (HA), the user can directly perform node switching between Primary-Secondary via Switch-over.
• Backup and Recovery: Provides data backup functionality based on its own backup commands. Backup time windows, retention agencies, and full backup days can be set by the user, and additional fees may apply based on backup volume. It also provides a recovery function for backed-up data, creating a separate database when the user performs a recovery, and the recovery proceeds to the point in time selected by the user (backup storage point, user-specified point). When restoring to a user-specified point, the restore point can be set to 5 minutes/10 minutes/30 minutes/1 hour before the stored backup file and archive file.
• Version Management: Provides version upgrade (Minor) functionality due to some feature improvements and security patches. Whether to perform backup for the version upgrade can be selected by the user, and if backup is performed, data is backed up before applying the patch, then the DB engine is updated.
• Secondary configuration: You can additionally configure a read-only Read Replica (Secondary Replica), enabling read performance scaling and load balancing.
• Audit setting: Provides an Audit setting feature that can monitor the user’s DB access and the results of DDL (Data Definition Language)/DML (Data Manipulation Language) execution.
• Parameter Management: Performance improvement and security-related DB configuration parameter modifications are possible.
• Service status query: Retrieves the final status of the current DB service.
• Monitoring: CPU, Memory, DB performance monitoring information can be checked through the Cloud Monitoring service.
• DB User Management: View and manage DB account (user) information registered in the DB.
• DB Log Export: Through Audit settings, you can export the stored logs to the user’s Object Storage.

Components

Microsoft SQL Server(DBaaS) provides pre-validated engine versions and various server types. Users can select and use them according to the scale of the service they want to configure.

Engine Version

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

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

According to the supplier’s policy, the EOS and EoTS dates may change, so 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

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

For detailed information about the server types provided by Microsoft SQL Server(DBaaS), refer to Microsoft SQL Server(DBaaS) Server Type.

Standard db1v2m4

Preliminary Service

This is a list of services that must be pre-configured before creating the service. Please refer to the guide provided for each service for details and prepare in advance.

1.1 - Server Type

Microsoft SQL Server(DBaaS) server type

Microsoft SQL Server(DBaaS) provides a server type composed of various combinations such as CPU, Memory, Network Bandwidth, etc. When creating Microsoft SQL Server (DBaaS), the Database Engine is installed according to the server type selected for the purpose of use.

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

Standard db1v2m4

db1 server type

The db1 server type of Microsoft SQL Server (DBaaS) is provided with standard specifications (vCPU, Memory) and is suitable for various database workloads.

• Up to 3.3Ghz Intel 3rd generation (Ice Lake) Xeon Gold 6342 Processor
• Supports up to 16 vCPUs and 256 GB of memory
• Up to 12.5 Gbps networking speed

DB2 server type

The db2 server type of Microsoft SQL Server(DBaaS) is provided with standard specifications (vCPU, Memory) and is suitable for various database workloads.

• Up to 3.2GHz Intel 4th generation (Sapphire Rapids) Xeon Gold 6448H Processor
• Supports up to 16 vCPUs and 256 GB of memory
• Up to 12.5 Gbps networking speed

DBH2 Server Type

The dbh2 server type of Microsoft SQL Server (DBaaS) is provided with large-capacity server specifications and is suitable for database workloads for large-scale data processing.

• Up to 3.2GHz Intel 4th generation (Sapphire Rapids) Xeon Gold 6448H Processor
• Supports up to 128 vCPUs and 1,536 GB of memory
• up to 25Gbps of networking speed

1.2 - Monitoring Metrics

Microsoft SQL Server(DBaaS) Monitoring Metrics

The following table shows the performance monitoring metrics of Microsoft SQL Server(DBaaS) that can be checked through Cloud Monitoring. For detailed usage of Cloud Monitoring, please refer to the Cloud Monitoring guide.

For server monitoring metrics of Microsoft SQL Server(DBaaS), please refer to the Virtual Server monitoring metrics guide.

2 - How-to guides

Users can enter the required information for Microsoft SQL Server (DBaaS) through the Samsung Cloud Platform Console, select detailed options, and create the service.

Creating Microsoft SQL Server(DBaaS)

You can create and use the Microsoft SQL Server (DBaaS) service from the Samsung Cloud Platform Console.

Microsoft SQL Server (DBaaS)를 생성하려면 다음 절차를 따르세요.

1. All Services > Database > Microsoft SQL Server(DBaaS) Click the menu. Navigate to the Service Home page of Microsoft SQL Server(DBaaS).
2. Click the Microsoft SQL Server(DBaaS) Create button on the Service Home page. You will be taken to the Microsoft SQL Server(DBaaS) Create page.
3. Microsoft SQL Server(DBaaS) creation On the page, enter the information required to create the service, and select detailed options.
   • Select image and version area, select the required information.

     Category	Required	Detailed description
     Image version	Required	Provide version list of Microsoft SQL Server (DBaaS)

     Table. Microsoft SQL Server (DBaaS) image and version selection items
   • Service Information Input area, enter or select the required information.

     Category	Required	Detailed description
     Server Name Prefix	Required	Server name where DB will be installed Start with a lowercase English letter, and use lowercase letters, numbers, and the special character (-) to input 3 to 13 characters Based on the server name, a postfix such as 001, 002 is attached to create the actual server name
     Cluster Name	Required	Cluster name of DB servers Enter using English letters, 3 to 20 characters A cluster is a unit that groups multiple servers
     Service Type > Server Type	Required	Server type where DB will be installed Standard: Standard specifications commonly used High Capacity: Large-capacity server with 24 vCore or more For detailed information about server types provided by Microsoft SQL Server (DBaaS), refer to Microsoft SQL Server(DBaaS) Server Types
     Service Type > Planned Compute	Select	Resource status with Planned Compute set In Use: Number of resources with Planned Compute set that are currently in use Configured: Number of resources with Planned Compute set Coverage Preview: Amount applied per resource by Planned Compute Create Planned Compute Service: Move to Planned Compute service application page Refer to Apply for Planned Compute for details
     Redundancy Configuration	Selection	Redundancy Configuration Status If redundancy configuration is used, the DB instance is configured as Active DB and Standby DB
     Network > Common Settings	Required	Network settings where servers generated by the service are deployed Select if you want to apply the same settings to all servers being installed Select a pre‑created VPC, Subnet, IP, and Public NAT IP can only be auto‑generated The Public NAT feature is available only when the VPC is connected to an Internet Gateway. If Use is checked, you can select from reserved IPs in the VPC product’s Public IP. For details, see Create Public IP
     Network > Server-specific Settings	Required	Network settings where servers generated by the service are installed Select if you want to apply different settings per installed server Select a pre‑created VPC, Subnet, IP, and Public NAT Enter each server’s IP The Public NAT feature is available only when the VPC is connected to an Internet Gateway. If you check Use, you can select a reserved IP from the VPC product’s Public IP. For more information, see Creating a Public IP.
     IP Access Control	Select	Service Access Policy Settings Since the access policy is set for the IP entered on the page, a separate Security Group policy setting is not required. Enter in IP format (e.g., 192.168.10.1) or CIDR format (e.g., 192.168.10.0/24, 192.168.10.1/32) and click the Add button To delete an entered IP, click the x button next to the entered IP
     Maintenance Period	Select	DB Maintenance Period Use is selected, set the day of the week, start time, and duration It is recommended to set a maintenance period for stable DB management. Patch work will be performed at the set time, causing service interruption If set to not use, Samsung SDS is not responsible for issues arising from patches not being applied

     Table. Microsoft SQL Server (DBaaS) Service Configuration Items

• Database Configuration Required Information Input In the area, please enter or select the required information.

  Category	Required	Detailed description
  Database service name	required	Database management unit name Start with an uppercase English letter and use English letters to input 1 - 15
  Database name > default	required	Server name applied when installing DB Start with an English letter, and use English letters, numbers, and special characters (.,_) to input 3-20 characters
  Database name > Add	Required	Server name applied when installing DB Select Use, then enter the name of the Database to install. It must start with an English letter, and be 3-20 characters using English letters, numbers, and special characters(., _) For each Database, the drive where data is stored can be selected from the drives added in Service Type > Block Storage Adding Databases is only possible in the Enterprise version, up to a maximum of 100
  Database username	Required	DB user name An account with the same name is also created on the OS Enter using lowercase English letters, 2 to 20 characters The following names cannot be used as a Database username root, user, sdscmpif, hacluster, adm, games, nobody, sshd, system, mail, postfix, sa, maxigent_cl
  Database password	Required	DB connection password Enter 8-30 characters including letters, numbers, and special characters (excluding “ ‘)
  Database Password Verification	Required	Check DB connection password Re-enter the DB connection password identically
  Database Port number	Required	DB connection port number Enter DB port within the range 1,024 - 65,535
  License	Required	SQL Server License Key Enter the issued license key If the entered license key is not valid, the service may not be created
  Backup > Use	Select	Whether to use backup Select Use to set backup file retention period, backup start time, Full backup schedule (day of week), Archive backup cycle.
  Backup > Retention Period	Select	Backup Retention Period Select the backup retention period. File retention period can be set from 7 days to 35 days Backup files incur additional charges based on size
  Backup > Backup Start Period	Select	Backup Start Time Select backup start time The minutes when the backup runs are set randomly, and the backup end time cannot be set
  Backup > Full Backup Schedule(Day)	Select	Full Backup Schedule Select the day to run Full Backup Full Backup is performed on a weekly cycle
  Backup > Archive backup frequency	Select	Archive backup frequency Select the Archive backup frequency Archive backup frequency is recommended at 1 hour. Selecting 5 minutes, 10 minutes, or 30 minutes may affect DB performance
  Audit Log Settings	Select	Whether to save Audit Log Select Use to configure the Audit Log function DDL, user connection information records are saved If Audit is set, DB performance may degrade
  Parameter	Required	DB configuration parameters Query button can be clicked to view detailed information of the parameter Parameters can be modified after the service creation is completed, and after modification a DB Restart is required
  DB Collation	Select	Data sorting method A command that specifies the data sorting and comparison method, and the result of the operation may differ depending on the setting.
  Time zone	Required	Standard time zone to be used by the Database

  Table. Microsoft SQL Server (DBaaS) Database configuration items
  • Enter additional information area, input or select the required information.

    Category	Required or not	Detailed description
    Tag	Select	Add Tag Up to 50 can be added per resource After clicking the Add Tag button, enter or select Key, Value values

    Table. Microsoft SQL Server (DBaaS) Additional Information Input Items

4. Summary Check the detailed information and estimated billing amount generated in the panel, and click the Complete button.
   • Once creation is complete, check the created resource on the Resource List page.

Microsoft SQL Server(DBaaS) Check detailed information

Microsoft SQL Server(DBaaS) service allows you to view and edit the full resource list and detailed information. Microsoft SQL Server(DBaaS) Details page consists of Details, Tags, Operation History tabs, and for databases with a configured Replica, a Replica Information tab is additionally provided.

To view detailed information of the Microsoft SQL Server (DBaaS) service, follow the steps below.

1. All Services > Database > Microsoft SQL Server(DBaaS) menu, please click. Go to the Service Home page of Microsoft SQL Server(DBaaS).
2. Click the Microsoft SQL Server(DBaaS) menu on the Service Home page. Navigate to the Microsoft SQL Server(DBaaS) List page.
3. Click the resource to view detailed information on the Microsoft SQL Server(DBaaS) List page. You will be taken to the Microsoft SQL Server(DBaaS) Details page.

• Microsoft SQL Server(DBaaS) Details At the top of the page, status information and information about additional features are displayed.

  Category	Detailed description
  Cluster Status	Cluster status with DB installed Creating: Cluster is being created Editing: Cluster is changing to operation execution state Error: Cluster encountered a failure while performing a task If it occurs continuously, contact the administrator Failed: Cluster failed during creation Restarting: Cluster is being restarted Running: Cluster is operating normally Starting: Cluster is being started Stopped: Cluster is stopped Stopping: Cluster is being stopped Synchronizing: Cluster is being synchronized Terminating: Cluster is being deleted Unknown: Cluster status is unknown If it occurs continuously, contact the administrator Upgrading: Cluster is changing to upgrade execution state
  Cluster Control	Button to change cluster state Start: Start a stopped cluster Stop: Stop a running cluster Restart: Restart a running cluster Switch-Over: Switch a standby cluster to Active
  More additional features	Cluster-related management button Service status synchronization: View real-time DB service status Backup history: If backup is configured, check whether backup runs correctly and view its history Database recovery: Recover the DB based on a specific point in time Parameter management: View and modify DB configuration parameters Add secondary: Configure a read-only cluster Replica DB user management: View and manage DB accounts (users) registered in the DB Export DB Log: Logs stored via Audit settings can be exported to the user’s Object Storage
  Service termination	Button to cancel the service

  Table. Microsoft SQL Server (DBaaS) status information and additional features

Detailed Information

Microsoft SQL Server(DBaaS) List page allows you to view detailed information of the selected resource and, if necessary, edit the information.

Tag

Microsoft SQL Server(DBaaS) List page you can view the tag information of the selected resource, and you can add, modify, or delete it.

Work History

Microsoft SQL Server(DBaaS) List You can view the operation history of the selected resource on the page.

Microsoft SQL Server(DBaaS) Managing Resources

If you need to change or recover the existing configuration options of a created Microsoft SQL Server (DBaaS) resource, or manage parameters, you can perform the tasks on the Microsoft SQL Server (DBaaS) Details page.

Operating Control

If changes occur to a running Microsoft SQL Server (DBaaS) resource, you can start, stop, or restart it. Also, if HA is configured, you can switch the Primary-Secondary servers via a switch-over.

To control the operation of Microsoft SQL Server (DBaaS), follow the steps below.

1. All Services > Database > Microsoft SQL Server(DBaaS) Click the menu. Navigate to the Service Home page of Microsoft SQL Server(DBaaS).
2. Service Home page, click the Microsoft SQL Server(DBaaS) menu. Navigate to the Microsoft SQL Server(DBaaS) list page.
3. Microsoft SQL Server(DBaaS) List On the page, click the resource to control operation. Microsoft SQL Server(DBaaS) Details Navigate to the page.
4. Check the status of Microsoft SQL Server (DBaaS) and complete the change using the control button below.
   • Start: The server where the DB service is installed and the DB service are running (Running).
   • Stop: The server where the DB service is installed and the DB service will be stopped (Stopped).
   • Restart: Only the DB service will be restarted.
   • Switch Over: You can switch the DB’s Primary server and Secondary server.

Synchronize Service Status

You can synchronize the real-time service status of Microsoft SQL Server (DBaaS).

To check the service status of Microsoft SQL Server (DBaaS), follow the steps below.

1. All Services > Database > Microsoft SQL Server(DBaaS) Click the menu. Navigate to the Service Home page of Microsoft SQL Server(DBaaS).
2. Click the Microsoft SQL Server(DBaaS) menu on the Service Home page. You will be taken to the Microsoft SQL Server(DBaaS) List page.
3. Microsoft SQL Server(DBaaS) List Click the resource to view the service status on the page. Microsoft SQL Server(DBaaS) Details Navigate to the page.
4. Service Status Synchronization Click the button. While it is being queried, the cluster will change to Synchronizing state.
5. When the query is completed, the status is updated in the server information item, and the cluster changes to Running state.

Change Server Type

You can change the configured server type.

To change the server type, follow the steps below.

1. All Services > Database > Microsoft SQL Server(DBaaS) Click the menu. Navigate to the Service Home page of Microsoft SQL Server(DBaaS).
2. Click the Microsoft SQL Server(DBaaS) menu on the Service Home page. Navigate to the Microsoft SQL Server(DBaaS) list page.
3. Click the resource to change the server type on the Microsoft SQL Server(DBaaS) List page. Navigate to the Microsoft SQL Server(DBaaS) Details page.
4. Click the Edit icon of the server type you want to change at the bottom of the detailed information. The Edit Server Type popup window will open.
5. Edit Server Type After selecting the server type in the popup window, click the Confirm button.

Add Storage

If you need more than 5 TB of data storage space, you can add storage. In the case of a redundant DB configuration, all redundant servers are added simultaneously.

To add storage capacity, follow the steps below.

1. All Services > Database > Microsoft SQL Server(DBaaS) Please click the menu. Navigate to the Service Home page of Microsoft SQL Server(DBaaS).
2. Service Home page, click the Microsoft SQL Server(DBaaS) menu. Navigate to the Microsoft SQL Server(DBaaS) list page.
3. Click the resource to add storage on the Microsoft SQL Server(DBaaS) List page. Navigate to the Microsoft SQL Server(DBaaS) Detail page.
4. Click the Add Disk button at the bottom of the detailed information. The Add Storage Request popup window opens.
5. Additional Storage Request In the popup window, after entering purpose and capacity, click the Confirm button.

Expanding Storage

Storage added to the data area can be expanded up to a maximum of 5 TB based on the initially allocated capacity. In the case of a redundant DB configuration, all redundant servers are expanded simultaneously.

To increase storage capacity, follow the steps below.

1. All Services > Database > Microsoft SQL Server(DBaaS) Click the menu. Go to the Service Home page of Microsoft SQL Server(DBaaS).
2. Click the Microsoft SQL Server(DBaaS) menu on the Service Home page. Navigate to the Microsoft SQL Server(DBaaS) list page.
3. Microsoft SQL Server(DBaaS) List Click the resource to change the server type on the page. Microsoft SQL Server(DBaaS) Detail Navigate to the page.
4. Click the Edit icon of the additional Disk you want to expand at the bottom of the detailed information. The Edit Additional Storage popup window opens.
5. Add Storage Modification After entering the expansion capacity in the popup window, click the Confirm button.

Microsoft SQL Server(DBaaS) Cancel

You can cancel the unused Microsoft SQL Server (DBaaS) to reduce operating costs. However, if you cancel the service, the running service may be immediately stopped, so you should consider the impact of service interruption sufficiently before proceeding with the cancellation.

To cancel Microsoft SQL Server (DBaaS), follow the steps below.

1. All Services > Database > Microsoft SQL Server(DBaaS) Click the menu. Navigate to the Service Home page of Microsoft SQL Server(DBaaS).
2. Click the Microsoft SQL Server(DBaaS) menu on the Service Home page. Navigate to the Microsoft SQL Server(DBaaS) List page.
3. On the Microsoft SQL Server(DBaaS) List page, select the resource to cancel, and click the Cancel Service button.
4. After termination is completed, check whether the resource has been terminated on the Microsoft SQL Server(DBaaS) list page.

2.1 - Managing DB Services

Users can manage Microsoft SQL Server (DBaaS) through the Samsung Cloud Platform Console.

Managing Databases

For Microsoft SQL Server Enterprise version, you can add new databases. Up to 100 databases can be added per cluster.

Adding a Database

To add a database, follow these steps:

1. Click All Services > Database > Microsoft SQL Server (DBaaS) menu. You will be moved to the Service Home page of Microsoft SQL Server (DBaaS).
2. On the Service Home page, click the Microsoft SQL Server (DBaaS) menu. You will be moved to the Microsoft SQL Server (DBaaS) List page.
3. On the Microsoft SQL Server (DBaaS) List page, click the resource you want to add storage to. You will be moved to the Microsoft SQL Server (DBaaS) Details page.
4. Click the Add button in the Database Name field. The Add Database popup window will open.
5. In the Add Database popup window, click the + button to enter the database name and select the drive, then click the Confirm button.

Deleting a Database

To delete a database, follow these steps:

1. Click All Services > Database > Microsoft SQL Server (DBaaS) menu. You will be moved to the Service Home page of Microsoft SQL Server (DBaaS).
2. On the Service Home page, click the Microsoft SQL Server (DBaaS) menu. You will be moved to the Microsoft SQL Server (DBaaS) List page.
3. On the Microsoft SQL Server (DBaaS) List page, click the resource you want to add storage to. You will be moved to the Microsoft SQL Server (DBaaS) Details page.
4. Click the Modify button in the Database Name field. The Delete Additional Database popup window will open.
5. In the Delete Additional Database Request popup window, check the database you want to delete and click the Delete button. The Delete Database popup window will open.
6. In the Delete Database popup window, enter the name of the database you want to delete and click the Confirm button.

Managing Parameters

It provides a feature to easily view and modify database configuration parameters.

Viewing Parameters

To view configuration parameters, follow these steps:

1. Click All Services > Database > Microsoft SQL Server (DBaaS) menu. You will be moved to the Service Home page of Microsoft SQL Server (DBaaS).
2. On the Service Home page, click the Microsoft SQL Server (DBaaS) menu. You will be moved to the Microsoft SQL Server (DBaaS) List page.
3. On the Microsoft SQL Server (DBaaS) List page, click the resource you want to view and modify parameters for. You will be moved to the Microsoft SQL Server (DBaaS) Details page.
4. Click the More button and then click the Parameter Management button. The Parameter Management popup window will open.
5. In the Parameter Management popup window, click the View button. The View Notification popup window will open.
6. When the View Notification popup window opens, click the Confirm button. It may take some time to view.

Modifying Parameters

To modify configuration parameters, follow these steps:

1. Click All Services > Database > Microsoft SQL Server (DBaaS) menu. You will be moved to the Service Home page of Microsoft SQL Server (DBaaS).
2. On the Service Home page, click the Microsoft SQL Server (DBaaS) menu. You will be moved to the Microsoft SQL Server (DBaaS) List page.
3. On the Microsoft SQL Server (DBaaS) List page, click the resource you want to view and modify parameters for. You will be moved to the Microsoft SQL Server (DBaaS) Details page.
4. Click the More button and then click the Parameter Management button. The Parameter Management popup window will open.
5. In the Parameter Management popup window, click the View button. The View Notification popup window will open.
6. When the View Notification popup window opens, click the Confirm button. It may take some time to view.
7. If modification is necessary, click the Modify button and enter the modification details in the user-defined value field of the parameter to be modified.
8. After entering the modification details, click the Save button.

Managing DB Users

It provides a feature to view and manage DB user information.

Viewing DB Users

To view DB users, follow these steps:

1. Click All Services > Database > Microsoft SQL Server (DBaaS) menu. You will be moved to the Service Home page of Microsoft SQL Server (DBaaS).
2. On the Service Home page, click the Microsoft SQL Server (DBaaS) menu. You will be moved to the Microsoft SQL Server (DBaaS) List page.
3. On the Microsoft SQL Server (DBaaS) List page, click the resource you want to view DB users for. You will be moved to the Microsoft SQL Server (DBaaS) Details page.
4. Click the More button and then click the DB User Management button. You will be moved to the DB User Management page.
5. On the DB User Management page, click the View button. It may take some time to view.

Exporting DB Logs

It supports exporting audit logs that need to be stored for a long time to Object Storage. Users can set the log type to be stored, the target bucket to export to, and the export cycle. According to the set criteria, the logs are copied and stored in the designated Object Storage.

Additionally, to efficiently manage disk space, an option to automatically delete the original log files when exporting logs to Object Storage is provided. By utilizing this option, users can effectively secure storage capacity while safely storing necessary log data for a long time.

Setting DB Log Export Mode

To set the DB Log export mode, follow these steps:

1. Click All Services > Database > Microsoft SQL Server (DBaaS) menu. You will be moved to the Service Home page of Microsoft SQL Server (DBaaS).
2. On the Service Home page, click the Microsoft SQL Server (DBaaS) menu. You will be moved to the Microsoft SQL Server (DBaaS) List page.
3. On the Microsoft SQL Server (DBaaS) List page, click the resource you want to export DB logs from. You will be moved to the Microsoft SQL Server (DBaaS) Details page.
4. Click the More button and then click the DB Log Export button. You will be moved to the DB Log Export page.
5. On the DB Log Export page, click the Register button. You will be moved to the DB Log Export Registration page.
6. On the DB Log Export Registration page, enter the required information and click the Save button.

Managing DB Log Export

To modify, cancel, or immediately export DB log settings, follow these steps:

1. Click All Services > Database > Microsoft SQL Server (DBaaS) menu. You will be moved to the Service Home page of Microsoft SQL Server (DBaaS).
2. On the Service Home page, click the Microsoft SQL Server (DBaaS) menu. You will be moved to the Microsoft SQL Server (DBaaS) List page.
3. On the Microsoft SQL Server (DBaaS) List page, click the resource you want to manage DB log export for. You will be moved to the Microsoft SQL Server (DBaaS) Details page.
4. Click the More button and then click the DB Log Export button. You will be moved to the DB Log Export page.
5. On the DB Log Export page, click the More button for the log type you want to manage and click the Immediate Export, Modify, or Cancel button.
   • Immediate Export: Exports the selected log to the Object Storage bucket.
   • Modify: Modifies the DB log export mode setting.
   • Cancel: Cancels the DB log export mode setting.

Upgrading Microsoft SQL Server (DBaaS) Version

It provides a feature to upgrade versions due to functional improvements and security patches. Only minor version upgrades are supported within the same major version.

To upgrade the version, follow these steps:

1. Click All Services > Database > Microsoft SQL Server (DBaaS) menu. You will be moved to the Service Home page of Microsoft SQL Server (DBaaS).
2. On the Service Home page, click the Microsoft SQL Server (DBaaS) menu. You will be moved to the Microsoft SQL Server (DBaaS) List page.
3. On the Microsoft SQL Server (DBaaS) List page, click the resource you want to upgrade the version for. You will be moved to the Microsoft SQL Server (DBaaS) Details page.
4. Click the Modify button in the Image/Version field. The Version Upgrade popup window will open.
5. In the Version Upgrade popup window, select the version to upgrade to and whether to set up backups, then click the Confirm button.
6. In the Version Upgrade Notification popup window, click the Confirm button.

2.2 - DB Backup and Recovery

The user can set up a backup of Microsoft SQL Server(DBaaS) through the Samsung Cloud Platform Console and restore it with the backed-up file.

Microsoft SQL Server(DBaaS) backup

Microsoft SQL Server(DBaaS) provides a data backup feature based on its own backup command, and also provides an optimized backup environment for data protection and management through backup history checking and backup file deletion functions.

Setting up backup

The method of setting up a backup for Microsoft SQL Server(DBaaS) is described in the Microsoft SQL Server(DBaaS) creation guide, please refer to it.

To modify the backup settings of the generated resource, follow these steps.

1. All services > Database > Microsoft SQL Server(DBaaS) menu, click. It moves to the Service Home page of Microsoft SQL Server(DBaaS).
2. On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. It moves to the Microsoft SQL Server(DBaaS) list page.
3. Click the resource to set up backup on the Microsoft SQL Server(DBaaS) list page. It moves to the Microsoft SQL Server(DBaaS) details page.
4. Click the Edit button of the backup item. The Backup Settings popup window opens.
5. If you set up a backup, click Use in the Backup Settings popup window, select the retention period, backup start time, and Archive backup cycle, and then click the OK button.
   • If you want to stop the backup setting, uncheck 사용 in the 백업 설정 popup window and click the 확인 button.

Check Backup History

To view the backup history, follow these steps.

1. Click All Services > Database > Microsoft SQL Server(DBaaS) menu. It moves to the Service Home page of Microsoft SQL Server(DBaaS).
2. Service Home page, click the Microsoft SQL Server(DBaaS) menu. It moves to the Microsoft SQL Server(DBaaS) list page.
3. Microsoft SQL Server(DBaaS) list page, click the resource to check the backup history. It moves to the Microsoft SQL Server(DBaaS) details page.
4. Click the Backup History button. The Backup History popup window opens.
5. Backup History popup window where you can check the backup status, version, backup start time, backup completion time, and capacity.

Deleting backup files

To delete the backup history, follow these steps.

1. Click All Services > Database > Microsoft SQL Server(DBaaS) menu. It moves to the Service Home page of Microsoft SQL Server(DBaaS).
2. Service Home page, click the Microsoft SQL Server(DBaaS) menu. It moves to the Microsoft SQL Server(DBaaS) list page.
3. Microsoft SQL Server(DBaaS) list page, click the resource to check the backup history. It moves to the Microsoft SQL Server(DBaaS) details page.
4. Click the Backup History button. The Backup History popup window opens.
5. Backup History popup window, check the file you want to delete, and then click the Delete button.

Microsoft SQL Server(DBaaS) Recovery

In the event of a disability or data loss that requires restoration with a backup file, recovery is possible based on a specific point in time through the recovery function. When performing Microsoft SQL Server (DBaaS) recovery, a new server is created with the OS image at the initial provisioning time, and the DB is installed with the version at the backup point, and the recovery proceeds with the DB configuration information and data.

To restore Microsoft SQL Server(DBaaS), follow these procedures.

1. Click All Services > Database > Microsoft SQL Server(DBaaS) menu. It moves to the Service Home page of Microsoft SQL Server(DBaaS).
2. Service Home page, click the Microsoft SQL Server(DBaaS) menu. Move to the Microsoft SQL Server(DBaaS) list page.
3. Microsoft SQL Server(DBaaS) resource list page, click the resource you want to restore. Move to the Microsoft SQL Server(DBaaS) details page.
4. Database Recovery 버튼을 클릭하세요. Database Recovery 페이지로 이동합니다.
5. Database Recovery Configuration area, enter the corresponding information and click the Complete button.

2.3 - Add Secondary

The user can enter the required information of the Secondary through the Samsung Cloud Platform Console and create the service through detailed options.

Add Secondary

You can create a read-only replica server through Secondary configuration. To configure additional Secondary, it must be created with duplication configuration (HA) and Enterprise Edition, and the backup function must be enabled.

To configure Secondary, follow these procedures.

1. Click on the menu for all services > Database > Microsoft SQL Server(DBaaS). It moves to the Service Home page of Microsoft SQL Server(DBaaS).
2. Service Home page, click the Microsoft SQL Server(DBaaS) menu. It moves to the Microsoft SQL Server(DBaaS) list page.
3. Click the resource to configure Secondary on the Microsoft SQL Server(DBaaS) list page. It moves to the Microsoft SQL Server(DBaaS) details page.
4. Secondary Add 버튼을 클릭하세요. Secondary Add 페이지로 이동합니다.
5. Secondary configuration area, enter information after, Complete button, click.

2.4 - Microsoft SQL Server(DBaaS) server connection

Scenario Overview

The Microsoft SQL Server(DBaaS) server connection scenario is a scenario where a Bastion host (Virtual Server) and a Database service are created, and the DB service is accessed through the Bastion host. To securely access Microsoft SQL Server (DBaaS) in the Samsung Cloud Platform environment, it is necessary to create a Bastion host and use it for network connection. To maintain a stable and high level of security, it is recommended to configure the Database service in a Private Subnet environment and configure the Bastion host in a limited Public Subnet environment.

This scenario largely describes the process of creating a Bastion host and Database service, and configuring the network environment for Bastion host and Database connection, and accessing it through a DB connection client.

Scenario Components

You can configure the scenario using the following services.

Scenario composition method

To configure the scenario, create the necessary services through the following procedure.

1. Configuring the Network

This describes the process of configuring the network environment for connecting to the Bastion Host and Database services.

1-1. Creating a VPC

1. Click All services > Networking > VPC menu. It moves to the Service Home page of VPC.
2. On the Service Home page, click the Create VPC button. It moves to the Create VPC page.
3. VPC Creation page, please enter the information required for service creation.
   • IP range should be entered as 192.168.x.0/16.
4. In the Summary panel, review the detailed information and estimated charges, and click the Complete button.
   • Once creation is complete, check the resource you created on the VPC list page.

1-2. Creating a Subnet

1. Click All services > Networking > VPC menu. It moves to the Service Home page of VPC.
2. Service Home page, click the Subnet menu. It moves to the Subnet list page.
3. Click the Subnet Creation button. It moves to the Subnet Creation page.
4. Subnet Creation page where you enter the information needed to create a service.
   • Subnet type should be selected as General.
   • Please select a pre-created VPC.
   • IP range should be entered as 192.168.x.0/24.
5. In the Summary panel, review the detailed information and estimated charges, and click the Complete button.
   • Once creation is complete, check the created resource on the Subnet list page.

1-3. Creating an Internet Gateway

1. Click All services > Networking > VPC menu. It moves to the Service Home page of VPC.
2. On the Service Home page, click the Internet Gateway menu. It moves to the Internet Gateway list page.
3. Click the Create Internet Gateway button. It moves to the Create Internet Gateway page.
4. Internet Gateway Creation page, please enter the required information necessary for service creation.
   • Please select a pre-created VPC.
   • Select Use in the Firewall usage item.
5. In the Summary panel, review the detailed information and estimated charges, and then click the Complete button.
   • Once the creation is complete, check the created resource on the Internet Gateway list page.

1-4. Creating a Public IP

1. Click All services > Networking > VPC menu. It moves to the Service Home page of VPC.
2. Service Home page, click the Public IP menu. It moves to the Public IP list page.
3. Public IP Reservation button, click. Move to the Public IP Reservation page.
4. Public IP Reservation page where you enter the required information necessary for service reservation.
5. In the Summary panel, review the detailed information and estimated billing amount, and click the Complete button.
   • Once creation is complete, check the created resource on the Public IP list page.

1-5. Creating a Security Group

1. Click All services > Networking > Security Group menu. It moves to the Service Home page of Security Group.
2. Service Home page, click the Create Security Group button. Move to the Create Security Group page.
3. Security Group Creation page, please enter the required information necessary for service creation.
4. Check the input information and click the Complete button.
   • Once creation is complete, check the created resource on the Security Group list page

2. Creating a Bastion host

This describes the process of configuring the Bastion Host where the database connection client should be installed.

2-1. Creating Server Keypair

1. Click All Services > Compute > Virtual Server menu. It moves to the Service Home page of Virtual Server.
2. Service Home page, click the Keypair menu. It moves to the Keypair list page.
3. Create Keypair button will be clicked. It moves to the Create Keypair page.
4. Keypair creation page where you enter the required information necessary for service creation.
5. Check the creation information and click the Complete button.
   • The key can only be downloaded for the first time, and re-issuance is not provided.
   • Please make sure to store the downloaded key in a safe place.

2-2. Creating a Bastion Host

1. Click All Services > Compute > Virtual Server menu. It moves to the Service Home page of Virtual Server.
2. Service Home page, click the Virtual Server creation button. Move to the Virtual Server creation page.
3. Virtual Server Creation page, please enter the required information necessary for service creation.
   • Image is Windows, please select it.
   • Please select a pre-created VPC and Subnet.
   • Click NAT and select the Public IP reserved in 1-4. Public IP 생성하기.
   • 2-1. Create Server Keypair and connect the Keypair created from there.
4. Summary panel, check the detailed information generated and the expected billing amount, and click the Complete button.
   • After creation is complete, check the created resource on the Virtual Server list page.

2-3. Check Bastion host connection ID and PW

1. Click All Services > Compute > Virtual Server menu. It moves to the Service Home page of Virtual Server.
2. Service Home page, click the Virtual Server menu. Move to the Virtual Server list page.
3. Virtual Serve list page, click on the resource created in 2-2. Bastion host creation. It moves to the detailed information page of the corresponding resource.
4. In the detailed information page, click the RDP password inquiry button in the Keypair name item. The RDP password inquiry pop-up window opens.
5. RDP password inquiry popup window, attach the keypair file downloaded from 2-1. Server Keypair creation.
6. After attaching, click the Password check button. The ID and password required to access the resource will be displayed.
   • The ID and Password will be used as information to connect to the Bastion host later in 5-1. Connect to Bastion host.

3. Creating a Database

It describes the process of creating a Database service.

3-1. Creating Microsoft SQL Server (DBaaS) Service

1. Click on the menu for all services > Database > Microsoft SQL Server(DBaaS). It moves to the Service Home page of Microsoft SQL Server(DBaaS).
2. On the Service Home page, click the Create Microsoft SQL Server(DBaaS) button. It moves to the Create Microsoft SQL Server(DBaaS) page.
3. Microsoft SQL Server(DBaaS) creation page, please enter the required information needed for service creation.
   • Select and connect to the pre-created VPC and Subnet.
   • Enter Database related creation information on the required information input screen.
   • Add the Bastion host IP in the IP access control item.
   • Database Port is 2866 by default, but users can also specify it.
4. In the Summary panel, review the detailed information and estimated charges, and then click the Complete button.
   • Once creation is complete, check the created resource from the Microsoft SQL Server(DBaaS) list page.

4. Setting Rules

This describes the process of setting rules for users to connect to the Bastion host and rules for the Bastion host to connect to the Database.

4-1. Security Group Add Security Rules

1. Click All Services > Networking > Security Group menu. It moves to the Service Home page of Security Group.
2. Service Home page, click the Security Group menu. Move to the Security Group list page.
3. 1-5. Creating a Security Group Select the Security Group resource created from 1-5. Creating a Security Group. It moves to the detailed information page of the corresponding resource.
4. Click the Rules tab on the detailed information page. It moves to the Rules tab.
5. Rule tab where you click the Add Rule button. Move to the Add Rule popup window.
6. In the Add Rule popup window, enter the rules below and click the OK button

4-2. Adding IGW Firewall Rules

1. Click All services > Networking > Firewall menu. It moves to the Service Home page of Firewall.
2. Service Home page, click the Firewall menu. It moves to the Firewall list page.
3. Firewall list page, select the Internet Gateway resource name created in 1-3. Creating Internet Gateway. It moves to the detailed information page of the corresponding resource.
4. Click the Rules tab on the detailed information page. It moves to the Rules tab.
5. Rule tab, click the Add Rule button. Move to the Add Rule popup window.
6. Add Rule In the popup window, enter the following rules and click the OK button.

5. Connect to Database

This describes the process of a user accessing the Database through a DB connection client program.

This guide provides instructions on how to connect using SSMS (Microsoft SQL Server Management Studio). Since there are various database client programs and CLI utilities, you can also install and use the tools that are suitable for you.

5-1. Connect to the Bastion host

1. Run Remote Desktop Connection in the Windows environment of the PC that wants to access the Bastion host, enter the NAT IP of the Bastion Host, and click the Connect button.
2. When the remote desktop connection is successful, the User Credential Input Window opens. Enter the ID and Password confirmed in 2-3. Check Bastion host access ID and PW and click the Confirm button.

5-2. Install DB connection client program (SSMS) on Bastion host

1. Go to the official Microsoft SQL Server page and download the SSMS program.
   • SSMS program download path: https://learn.microsoft.com/en-us/ssms/download-sql-server-management-studio-ssms
2. Connect the hard drive of the user PC to upload the file to the Bastion host.
3. Click the Details button for local devices and resources entries in the Local Resources tab of Remote Desktop Connection.
4. Select the local disk where the file was downloaded to the drive and click the Confirm button.
5. Download the file, copy it to the Bastion Host, and upload it, then click the SSMS (Microsoft SQL Server Management Studio) installation file to install it.

5-3. Using DB Connection Client Program (SSMS) to Connect to Database

1. Run SSMS (Microsoft SQL Server Management Studio). The Connect to Server popup window will appear.
2. Connect to Server popup window, enter the database server information created in 3-1. Microsoft SQL Server(DBaaS) service creation and click the Connect button.

   Required Input Element Items	Input Value
   Server type	Database Engine
   Server name	Database server IP, Database Port (ex. 192.168.10.1,2866)
   Authentication	SQL Server Authentication
   Login	Database username
   Password	Database password
   Encryption	Optional

   DB Connection Client Program Input Items
3. Once the connection is complete, the Database will be connected. After connection, you can try performing simple queries, etc.

3 - API Reference

4 - CLI Reference

5 - Release Note

Microsoft SQL Server(DBaaS)