How-to guides

Users can create the service by entering the required information for Microsoft SQL Server (DBaaS) and selecting detailed options through the Samsung Cloud Platform Console.

Create a Microsoft SQL Server (DBaaS)

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

To create a Microsoft SQL Server (DBaaS) instance, follow these steps.

1. Click the All Services > Database > Microsoft SQL Server(DBaaS) menu. 1. Go to the Service Home page of Microsoft SQL Server (DBaaS).
2. On the Service Home page, click the Create Microsoft SQL Server (DBaaS) button. 2. Go to the Create Microsoft SQL Server (DBaaS) page.
3. On the Create Microsoft SQL Server (DBaaS) page, enter the information required to create the service and select the detailed options.
   • Select the required information in the Image and Version Selection area.

     Category	Required	Detailed Description
     Image version	Required	Provide a list of Microsoft SQL Server (DBaaS) versions

     Table. Microsoft SQL Server (DBaaS) image and version selection options
   • Enter or select the required information in the Service Information Input area.

     Category	Required	Detailed Description
     Server Name Prefix	Required	Server name where the DB will be installed Must start with a lowercase letter and be 3 to 13 characters long, using lowercase letters, numbers, and special characters (-) A postfix such as 001 or 002 is appended to the server name to generate the actual server name
     Cluster Name	Required	The cluster name in which the DB servers are configured Enter 3 to 20 characters using English letters A cluster is a unit that groups multiple servers
     Service Type > Server Type	Required	Server type for the DB installation Standard: Standard specifications commonly used High Capacity: High-capacity servers with 24 vCores or more For details on the server types provided by Microsoft SQL Server (DBaaS), see Microsoft SQL Server (DBaaS) server types
     Service Type > Planned Compute	Select	Resource status with Planned Compute configured In Use: The number of resources in use among those with Planned Compute configured Configured: The number of resources with Planned Compute configured Coverage Preview: The amount applied by Planned Compute for each resource Create Planned Compute Service: Navigate to the Planned Compute service request page For details, refer to Request Planned Compute
     Service Type > Block Storage	Required	Configure the Block Storage used by the DB according to its purpose Basic OS: The area where the DB engine is installed DATA: The storage area for table data, archive files, and so on After selecting a storage type, enter the capacity (For details on each Block Storage type, see Create Block Storage) SSD: High-performance general volume HDD: General volume SSD_KMS, HDD_KMS: Additional encrypted volumes that use Samsung Cloud Platform KMS (Key Management System) encryption keys The configured Storage type is also applied to additional storage Enter the capacity as a multiple of 8 within the range of 16 to 5,120 Additional: Data storage area After selecting Use, enter the Purpose and Capacity of the storage To add storage, click the Add button. To delete it, click the x button The capacity can be entered as a multiple of 8 within the range of 16 to 5,120, and up to 9 can be created
     Redundancy Configuration	Select	Whether a high-availability configuration is in place When a high-availability configuration is used, the DB instance is configured with a separation between the Active DB and the Standby DB.
     Using AD	Select	Set whether to use a preconfigured AD (Active Directory) server Domain Name: Domain name Domain NetBIOS Name: Domain NetBIOS name DNS Server IP: Enter the DNS server IP/secondary DNS server IP and click the Add button Up to 5 entries can be added AD Server ID: AD user ID AD Server Password: User password High Availability Cluster Name: Failover cluster name used when configuring high availability Displayed only when using high availability options Click Port Connection Guide to view the Security Group inbound/outbound rule information required to connect the SQL server and AD server
     Network > Common Settings	Required	Network settings for the servers created by the service and installed on them. Select this option to apply the same settings to all servers being installed. Select a pre-created VPC, Subnet, IP, and Public NAT. The IP for each server is generated automatically. The Public NAT feature is available only if the VPC is connected to an Internet Gateway. When you check Use, you can select a reserved IP from the Public IPs of the VPC product. For details, see Create a Public IP.
     Network > Per-Server Settings	Required	Network settings for the servers created by the service to be installed on Select to apply different settings for each server being installed Select a pre-created VPC, Subnet, IP, and Public NAT Enter the IP for each server The Public NAT feature is available only if the VPC is connected to an Internet Gateway. When Use is checked, you can select a reserved IP from the Public IPs of the VPC product. For details, see Create a Public IP
     IP Access Control	Select	Configure Service Access Policy Access policies are configured for the IPs entered on the page, so there is no need to separately configure Security Group policies. Enter in IP format (example: 192.168.10.1) or CIDR format (example: 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 IP.
     Maintenance Period	Select	DB Maintenance Window When you select Use, you can configure the day of the week, start time, and duration. The maintenance window is a feature that allows users to set the time zone for performing patch operations. Patch operations within this time frame are the user’s responsibility. To ensure stable system operation, please configure a maintenance window. We are not responsible for any issues arising from a missing configuration or failure to perform operations within the specified window.

     Table. Microsoft SQL Server (DBaaS) service configuration items
   • Enter or select the required information in the Database Configuration Required Information section.

     Category	Required	Detailed Description
     Database service name	Required	Database management unit name Must start with an uppercase letter and be 1 to 15 characters long, using only letters
     Database Name > Default	Required	Server name applied during DB installation. It must start with a letter and be 3 to 20 characters long, using letters, numbers, and special characters (.,_)
     Database Name > Add	Required	The server name applied during DB installation. After selecting Usage, enter the name of the Database to install. The name must start with an English letter and be 3 to 20 characters long, using English letters, numbers, and special characters (., _) The drive where data is stored for each Database can be selected from the drives added under Service Type > Block Storage Adding Databases is available only in the Enterprise version, with a maximum of 100 Databases
     Database username	Required	DB user name A system account with the same name is also created on the OS. Enter 2 to 20 characters using lowercase letters. The following names cannot be used as database user names: 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 “ ‘)
     Verify the database password	Required	Verify the database connection password Re-enter the database connection password
     Database Port Number	Required	DB connection port number Enter the DB port within the range of 1200 to 65535
     License	Required	SQL Server License Key Enter the issued license key If the entered license key is invalid, the service may not be created
     Backup > Usage	Select	Whether to use backup Select Use to configure the backup file retention period, backup start time, full backup schedule (day of the week), and archive backup frequency
     Backup > Retention Period	Select	Backup retention period Select the backup retention period. The file retention period can be set from 7 to 35 days. Backup files are subject to separate charges based on capacity.
     Backup > Backup Start Period	Select	Backup start time Select the backup start time The minutes at which the backup is performed are set randomly, and the backup end time cannot be configured
     Backup > Full Backup Schedule (Day of Week)	Select	Full backup schedule Select the day of the week to run the full backup Full backups run on a weekly cycle
     Backups > Archive backup frequency	Select	Archive backup interval Select an archive backup interval A 1-hour archive backup interval is recommended. Selecting 5 minutes, 10 minutes, or 30 minutes may affect DB performance.
     Audit Log Configuration	Select	Whether to save the Audit Log Select Use to configure the Audit Log feature DDL and user connection information are recorded Enabling Audit may degrade DB performance
     ServiceWatch log collection	Select	Whether to collect ServiceWatch logs Select Use to configure the ServiceWatch log collection feature Provided free of charge for all services within the Account up to 5 GB. For usage exceeding 5 GB, fees are charged based on storage capacity When collection is enabled, log groups and log streams are created automatically and cannot be deleted until the associated resources are deleted To prevent exceeding 5 GB, we recommend directly deleting log data or shortening the retention period
     Parameter	Required	DB configuration parameters Click the View button to view detailed parameter information. Parameters can be modified only after service creation is complete. A DB restart is required after any modifications.
     DB Collation	Select	Data Alignment Method A command that specifies the data alignment and comparison method. Depending on the settings, the operation results may vary.
     Time zone	Required	The standard time zone in which the database will be used

     Table. Microsoft SQL Server (DBaaS) Database configuration items
   • Enter or select the required information in the Additional Information area.

     Category	Required	Detailed Description
     Tag	Select	Add Tag You can add up to 50 tags per resource Click the Add Tag button, then enter or select the Key and Value

     Table. Microsoft SQL Server (DBaaS) additional information input items
4. Review the details and estimated billing amount generated in the Summary panel, and then click the Generate button.
   • After generation is complete, check the created resource on the Resource List page.

Viewing Microsoft SQL Server (DBaaS) details

The Microsoft SQL Server (DBaaS) service allows you to view and modify the full resource list and detailed information. The Microsoft SQL Server (DBaaS) Details page consists of the Details, Secondary (DR) Information, Tags, and Operation History tabs. For databases with a configured Secondary (DR), the Secondary (DR) Information tab is additionally included.

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

1. Click the All Services > Database > Microsoft SQL Server(DBaaS) menu. 1. Go to the Service Home page of Microsoft SQL Server (DBaaS).
2. On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. 2. Go to the Microsoft SQL Server (DBaaS) List page.
3. On the Microsoft SQL Server (DBaaS) List page, click the resource for which you want to view detailed information. 3. Go to the Microsoft SQL Server (DBaaS) Details page.
   • The Microsoft SQL Server (DBaaS) Details page displays status information and add-on feature information at the top.

     Category	Detailed Description
     Cluster status	Cluster status with the DB installed Creating: The cluster is being created Editing: The cluster is transitioning to a state where it is performing an Operation Error: The cluster encountered a failure while performing a task If this occurs persistently, contact the administrator Failed: The cluster failed during the creation process Restarting: The cluster is being restarted Running: The cluster is operating normally Starting: The cluster is being started Stopped: The cluster is stopped Stopping: The cluster is being stopped Synchronizing: The cluster is being synchronized Terminating: The cluster is being deleted Unknown: The cluster status is unknown If this occurs persistently, contact the administrator Upgrading: The cluster is transitioning to a state where it is performing an upgrade
     Cluster Control	Buttons that can change the cluster state Start: Starts a stopped cluster Stop: Stops a running cluster Restart: Restarts a running cluster Switch-Over: Switches a Standby cluster to Active
     View additional features	Cluster-related management buttons Service Status Synchronization: Query the real-time DB service status Backup History: If backups are configured, check whether backups are running normally and review the history Database Recovery: Restore the DB based on a specific point in time Parameter Management: View and modify DB configuration parameters Secondary Configuration: Configure a read-only Secondary (DR) cluster Secondary Configuration (Other-Region): Configure a Secondary for disaster recovery in a different region. If no region is available to configure in the corresponding Account, this button is disabled DB User Management: View and manage DB account (user) information registered in the DB DB Log Export: Export logs stored through Audit settings to the user’s Object Storage Primary Promotion: Promote a Secondary (DR) to Primary to ensure DB service continuity
     Service Cancellation	Button for canceling the service

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

Detailed Information

On the Microsoft SQL Server (DBaaS) List page, you can view the details of the selected resource and modify the information as needed.

Secondary (DR) Information

The Secondary(DR) Information tab is enabled only when a Secondary(DR) is configured. You can view the master cluster name, the number of secondary (DR) clusters, and the secondary (DR) status on the Secondary(DR) Information tab.

Tag

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

Job History

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

Managing Microsoft SQL Server (DBaaS) Resources

To modify or restore existing configuration options, manage parameters, or perform other tasks for a created Microsoft SQL Server (DBaaS) resource, use the Microsoft SQL Server (DBaaS) Details page.

Controlling Operation

You can start, stop, or restart a running Microsoft SQL Server (DBaaS) resource when changes occur. Additionally, in an HA configuration, you can switch the primary and secondary servers through a switchover.

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

1. Click the All Services > Database > Microsoft SQL Server(DBaaS) menu. 1. Go to the Service Home page of Microsoft SQL Server (DBaaS).
2. On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. 2. Go to the Microsoft SQL Server (DBaaS) List page.
3. On the Microsoft SQL Server (DBaaS) List page, click the resource you want to control. 3. Go to the Microsoft SQL Server (DBaaS) Details page.
4. Check the status of Microsoft SQL Server (DBaaS) and complete the changes using the control buttons below.
   • Start: The DB service is installed on the server, and the DB service is running.
   • Stop: The server where the DB service is installed and the DB service are stopped.
   • Restart: Only the DB service is restarted.
   • Switch Over: You can switch the Primary and Secondary servers of the DB.

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 these steps.

1. Click the All Services > Database > Microsoft SQL Server(DBaaS) menu. 1. Go to the Service Home page of Microsoft SQL Server (DBaaS).
2. On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. 2. Go to the Microsoft SQL Server (DBaaS) List page.
3. On the Microsoft SQL Server (DBaaS) List page, click the resource to check its service status. 3. Go to the Microsoft SQL Server (DBaaS) Details page.
4. Click the Service Status Sync button. 4. While the query is in progress, the cluster changes to the Synchronizing state.
5. When the query is complete, the status in the server information section is updated, and the cluster changes to the Running state.

Change Server Type

You can change the configured server type.

To change the server type, follow these steps.

1. Click the All Services > Database > Microsoft SQL Server(DBaaS) menu. 1. Go to the Service Home page of Microsoft SQL Server (DBaaS).
2. On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. 2. Go to the Microsoft SQL Server (DBaaS) List page.
3. On the Microsoft SQL Server (DBaaS) List page, click the resource for which you want to change the server type. 3. Go to the Microsoft SQL Server (DBaaS) Details page.
4. Click the Edit icon for the server type you want to change at the bottom of the details section. 4. The Edit Server Type popup window opens.
5. In the Edit Server Type popup, select a server type and then click the OK button.

Add Storage

If you need more than 5 TB of data storage space, you can add storage. For a database configured for high availability, both high-availability servers are added simultaneously.

To add storage capacity, follow these steps.

1. Click the All Services > Database > Microsoft SQL Server(DBaaS) menu. 1. Go to the Service Home page of Microsoft SQL Server (DBaaS).
2. On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. 2. Go to the Microsoft SQL Server (DBaaS) List page.
3. On the Microsoft SQL Server (DBaaS) List page, click the resource to add storage. 3. Go to the Microsoft SQL Server (DBaaS) Details page.
4. Click the Add Disk button at the bottom of the details section. 4. The Request Additional Storage popup window opens.
5. In the Request Additional Storage popup, enter the purpose and capacity, then 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. For a database configured with high availability, both servers in the high-availability pair are scaled out simultaneously.

To expand storage capacity, follow these steps.

1. Click the All Services > Database > Microsoft SQL Server(DBaaS) menu. 1. Go to the Service Home page of Microsoft SQL Server (DBaaS).
2. On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. 2. Go to the Microsoft SQL Server (DBaaS) List page.
3. On the Microsoft SQL Server (DBaaS) List page, click the resource for which you want to change the server type. 3. Go to the Microsoft SQL Server (DBaaS) Details page.
4. Click the Edit icon for the additional disk you want to add at the bottom of the details section. 4. The Edit Additional Storage popup opens.
5. In the Modify Additional Storage dialog box, enter the expansion capacity and click the OK button.

Terminate Microsoft SQL Server (DBaaS)

You can reduce operational costs by canceling unused Microsoft SQL Server (DBaaS). However, if you cancel the service, the running service may be immediately interrupted. Therefore, you must carefully consider the impact of the service interruption before proceeding with the cancellation.

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

1. Click the All Services > Database > Microsoft SQL Server(DBaaS) menu. 1. Go to the Service Home page of Microsoft SQL Server (DBaaS).
2. On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. 2. Go 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 the cancellation is complete, verify that the resource has been canceled on the Microsoft SQL Server (DBaaS) list page.