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 Microsoft SQL Server(DBaaS)

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

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

1. All Services > Database > Microsoft SQL Server(DBaaS) Click the 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) Create button. 2. Microsoft SQL Server(DBaaS) creation Navigate to the page.
3. On the Microsoft SQL Server(DBaaS) Creation page, enter the information required to create the service and select detailed options.
   • Select the required information in the Image and version selection area.

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

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

     Category	Required status	Detailed description
     Server name Prefix	Required	The server name where the DB will be installed must start with a lowercase English letter and be entered using lowercase letters, numbers, and special characters (-) with a length of 3 to 13 characters Based on the server name, a postfix such as 001, 002 is appended to create the actual server name
     Cluster name	Required	Cluster name of the DB servers Enter using English letters, 3 - 20 characters A cluster is a unit that groups multiple servers
     Service Type > Server Type	Required	Server type for DB installation Standard: Standard specifications commonly used High Capacity: Large-capacity server with 24 vCores or more For detailed information about the server types provided by Microsoft SQL Server (DBaaS), refer to Microsoft SQL Server(DBaaS) 서버 타입
     Service Type > Planned Compute	Selection	Status of resources with Planned Compute set In Use: Number of resources with Planned Compute that are currently in use Configured: Number of resources with Planned Compute set Coverage Preview: Amount applied by Planned Compute per resource Create Planned Compute Service: Go to the Planned Compute service application page For more details, see Planned Compute 신청하기
     Service Type > Block Storage	Required	Configure Block Storage used by the DB according to its purpose Basic OS: Area where the DB engine is installed DATA: Storage area for table data, archive files, etc. After selecting the storage type, enter the capacity (see Block Storage 생성하기 for details on each Block Storage type) 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 16 to 5,120 Additional: Data storage area After selecting Use, enter the storage’s Purpose and Capacity To add storage, click the Add button; to delete, click the x button Capacity can be entered as a multiple of 8 within the range 16 to 5,120, and up to 9 can be created
     Redundant configuration	Selection	Redundancy configuration status When redundancy configuration is used, the DB instance is configured as an Active DB and a Standby DB
     Use AD	Selection	Set whether to use a pre-configured AD (Active Directory) server Domain Name: Domain name Domain NetBIOS Name: Domain NetBIOS name DNS Server IP: Enter DNS server IP / secondary DNS server IP and click the Add button Up to 5 entries can be entered AD Server ID: AD user ID AD Server Password: User password High Availability Cluster Name: Name of the failover cluster used when configuring high availability Displayed only when the high availability option is used Click Port Connection Guide to view the Security Group inbound/outbound rule information required for connecting the SQL server and AD server
     Network > Common Settings	Required	Network settings for servers created by the service Select this when you want to apply the same settings to all installed servers Select a pre‑created VPC, Subnet, IP, and Public NAT Each server’s IP is generated automatically The Public NAT feature is available only when the VPC is connected to an Internet Gateway. Use when checked, you can select from reserved IPs in the VPC product’s Public IP. For more details, see 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 for each installed server Select a pre‑created VPC, Subnet, IP, and Public NAT Enter the IP for each server The Public NAT feature is available only when the VPC is connected to an Internet Gateway. If you check Use, you can select from reserved IPs in the VPC product’s Public IP. For more information, see Public IP 생성하기
     IP access control	Selection	Service Access Policy Configuration Since the access policy is set for the IP entered on the page, you do not need to configure a separate Security Group policy. 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 entered IP.
     maintenance period	Selection	DB maintenance window If you select Use, you can set the day of the week, start time, and duration The maintenance window is a feature that allows the user to set the time slot for performing patch operations, and patch tasks within that period are performed directly by the user. For the stable operation of the system, please set a maintenance window; we are not responsible for any issues arising from not setting it or from failure to perform tasks within the window.

     Table. Microsoft SQL Server (DBaaS) service configuration items
   • Enter required database configuration information: enter or select the required information in this area.

     Category	Required status	Detailed description
     Database service name	Required	Database management unit name starts with an uppercase English letter and is entered using English characters with a length of 1 - 15
     Database name > default	Required	Server name applied during DB installation must start with an English letter and be entered using English letters, numbers, and special characters (.,_) with a length of 3 - 20 characters
     Database name > Add	Required	Enter the Database name to install after selecting Use for the server name . It must start with an English letter and be entered using English letters, numbers, and special characters (., _) with a length of 3 to 20 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, and up to 100 can be added
     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 Database user names root, user, sdscmpif, hacluster, adm, games, nobody, sshd, system, mail, postfix, sa, maxigent_cl
     Database password	Required	DB connection password English letters, numbers, and special characters(“ ‘ except) including, enter 8-30 characters
     Check database password	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 1200 - 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 > Use	Selection	Backup usage Select Use to set the backup file retention period, backup start time, Full backup schedule (day of week), and Archive backup interval
     Backup > Retention Period	Selection	Backup retention period Select the backup retention period. Set the file retention period from 7 days to 35 days Backup files incur additional charges based on size
     Backup > Backup Start Period	Selection	Backup start time Select backup start time The minutes (minutes) at which the backup runs are set randomly, and the backup end time cannot be configured
     Backup > Full backup schedule (day of week)	Selection	Full backup schedule Select the day of the week for full backup execution Full backup is performed on a weekly basis
     Backup > Archive backup schedule	Selection	Archive backup frequency Select the Archive backup frequency The Archive backup frequency is recommended at 1 hour. Selecting 5 minutes, 10 minutes, or 30 minutes may affect DB performance
     Audit Log Settings	Selection	Whether to store Audit Log Select Use to enable the Audit Log feature DDL and user connection information records are stored Enabling Audit may degrade DB performance
     ServiceWatch log collection	Selection	ServiceWatch log collection status Select Use to configure the ServiceWatch log collection feature Provided free up to 5 GB for all services within the Account, and charges apply based on storage size for usage exceeding 5 GB When collecting, log groups and log streams are created automatically, and they cannot be deleted until the resource is deleted To prevent exceeding 5 GB, it is recommended to delete log data directly or shorten the retention period
     Parameter	Required	DB configuration parameters Click the View button to view detailed information of the parameters Parameters can be modified after the service creation is complete, and a DB restart is required after modification
     DB Collation	Selection	Data sorting method Data sorting, a command that specifies the method of comparison, can produce different results depending on the settings
     Time zone	Required	Standard time zone used by the database

     Table. Microsoft SQL Server (DBaaS) Database configuration items
   • In the Additional Information Input area, enter or select the required information.

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

     Table. Microsoft SQL Server (DBaaS) Additional Information Input Items
4. Summary Verify the detailed information and estimated charges generated in the panel, then click the Create button.
   • Once creation is complete, check the created resource on the Resource List page.

Microsoft SQL Server(DBaaS) Check detailed information

The Microsoft SQL Server (DBaaS) service allows you to view and edit the full list of resources and detailed information. Microsoft SQL Server(DBaaS) Details The page consists of Details, Secondary(DR) Information, Tags, Activity History tabs, and for databases with a configured Secondary(DR), an additional Secondary(DR) Information tab is provided.

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

1. All Services > Database > Microsoft SQL Server(DBaaS) Click the 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. Microsoft SQL Server(DBaaS) List Go to the page.
3. Microsoft SQL Server(DBaaS) List Click the resource to view detailed information on the page. 3. Microsoft SQL Server(DBaaS) Details Navigate to the page.
   • Microsoft SQL Server(DBaaS) Details At the top of the page, status information and details about additional features are displayed.

     Category	Detailed description
     Cluster status	Cluster status with DB installed Creating: Cluster is being created Editing: Cluster is transitioning to an operational state Error: Cluster encountered a failure while performing a task If this persists, 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 stopping Synchronizing: Cluster is being synchronized Terminating: Cluster is being terminated Unknown: Cluster status is unknown If this persists, contact the administrator Upgrading: Cluster is being upgraded
     Cluster control	Buttons to change the 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
     View more add-ons	Cluster management buttons Service status synchronization: Retrieve real-time DB service status Backup history: If backup is configured, verify successful execution and view the backup 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 cluster as Secondary (DR) Secondary configuration (Other-Region): Configure a disaster‑recovery Secondary in another region; if the account has no region to configure, the button is disabled 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 Primary promotion: Promote a Secondary (DR) to Primary to ensure DB service continuity
     Service cancellation	Cancel Service button

     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.

Secondary(DR) information

Secondary(DR) Information tab is enabled only when Secondary(DR) is configured. Secondary(DR) Information Through the tab, you can view the Master cluster name, the number of Secondary(DR), and the status of Secondary(DR).

Tag

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

Job History

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

Managing Microsoft SQL Server (DBaaS) Resources

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

Operation Control

If changes occur to a running Microsoft SQL Server (DBaaS) resource, you can start, stop, or restart it. Also, when HA is configured, you can switch between Primary and 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. 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. Microsoft SQL Server(DBaaS) List Navigate to the page.
3. Microsoft SQL Server(DBaaS) List On the page, click the resource to control its operation. 3. Microsoft SQL Server(DBaaS) Details Go to the page.
4. Check the status of Microsoft SQL Server(DBaaS) and complete the change using the control button below.
   • Start: DB service is installed on the server and the DB service is 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 view the service status of Microsoft SQL Server(DBaaS), follow the steps below.

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. Microsoft SQL Server(DBaaS) List Navigate to the page.
3. On the Microsoft SQL Server(DBaaS) List page, click the resource to view the service status. 3. Microsoft SQL Server(DBaaS) Details Go to the page.
4. Click the Service Status Synchronization button. 4. While it is being queried, the cluster changes to Synchronizing state.
5. Once the query completes, the status in the server information item is updated, and the cluster changes to Running state.

Change Server Type

The configuration can be changed.

To change the server type, follow these steps.

1. All Services > Database > Microsoft SQL Server(DBaaS) Click the 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. Microsoft SQL Server(DBaaS) List Go to the page.
3. Microsoft SQL Server(DBaaS) List On the page, click the resource to change the server type. 3. Microsoft SQL Server(DBaaS) Details Navigate to the page.
4. Click the Edit icon for the server type you want to change at the bottom of the detailed information. 4. Edit Server Type The popup window opens.
5. Edit Server Type In the popup window, select the server type, then click the Confirm button.

Add storage

If you need more than 5 TB of data storage, you can add additional storage. In a redundant DB setup, all redundant servers are added simultaneously.

To add storage capacity, follow the steps below.

1. All Services > Database > Microsoft SQL Server(DBaaS) Click the 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. Microsoft SQL Server(DBaaS) List Go to the page.
3. Microsoft SQL Server(DBaaS) List page, click the resource to add storage. 3. Microsoft SQL Server(DBaaS) Details Go to the page.
4. Click the Add Disk button at the bottom of the detailed information. 4. Additional Storage Request The popup window opens.
5. Additional Storage Request In the popup window, after entering the 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 a redundant DB setup, 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. 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. Microsoft SQL Server(DBaaS) List Navigate to the page.
3. On the Microsoft SQL Server(DBaaS) List page, click the resource to change the server type. 3. Microsoft SQL Server(DBaaS) Details Navigate to the page.
4. Click the Edit icon for the additional Disk you want to add at the bottom of the detailed information. 4. Edit Additional Storage popup opens.
5. Edit Additional Storage After entering the expansion capacity in the popup window, click the Confirm button.

Terminate Microsoft SQL Server(DBaaS)

You can cancel unused Microsoft SQL Server (DBaaS) to reduce operating costs. However, terminating the service may cause the currently operating service to stop immediately, so you should proceed with the termination only after fully considering the impact of any service interruption.

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

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. Microsoft SQL Server(DBaaS) List Go to the page.
3. Microsoft SQL Server(DBaaS) List Select the resource to cancel on the page, and click the Cancel Service button.
4. After termination is complete, verify that the resource has been terminated on the Microsoft SQL Server(DBaaS) list page.