How-to guides

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

Microsoft SQL Server(DBaaS) Create

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

To create 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) 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.
   • Image and version selection Select the required information in the area.

     Category	Required or not	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 Enter or select the required information in the area.

     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 composed 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	Status of resources 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 by Planned Compute per resource Create Planned Compute Service: Go to the Planned Compute service application page For more details, refer to Apply for Planned Compute
     Service Type > Block Storage	Required	Block Storage settings used by DB according to purpose Basic OS: Area where the DB engine is installed DATA: Storage area for table data, archive files, etc. Select the storage type and then enter the capacity (refer to Block Storage Creation for details on each Block Storage type) SSD: High-performance general volume HDD: General volume SSD_KMS, HDD_KMS: Additional encrypted volumes using Samsung Cloud Platform KMS (Key Management System) encryption keys The configured storage type is applied identically to additional storage Capacity must be entered as a multiple of 8 within the range 16 ~ 5,120 Additional: Data storage area After selecting Use, enter the storage’s purpose and capacity Click the + button to add storage, and the x button to delete Capacity can be entered as a multiple of 8 within the range 16 ~ 5,120, and up to 9 can be created
     Redundancy Configuration	Select	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 installed 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 you check Use, you can select from reserved IPs in the VPC product’s Public IP. For more information, see Create Public IP
     Network > Server-specific Settings	Required	Network settings where servers generated by the service are deployed 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 Use is checked, you can select from reserved IPs in the VPC product’s Public IP. For more information, see Create 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 to set day of 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 Enter or select the required information in the area.

     Category	Required or not	Detailed description
     Database Service Name	Required	Database Management Unit Name Start with an uppercase English letter and use English characters, input 1~15
     Database name > Default	Required	Server name applied when installing DB Starts with an English letter, and using English letters, numbers, and special characters (.,_) 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 entered using English letters, numbers, and special characters (., _) for 3 - 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, 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 (“ ‘ excluded)
     Database password verification	Required	DB connection password verification 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 not valid, the service may not be created
     Backup > Use	Select	Backup usage status Use select 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 during which the backup is performed are set randomly, and the backup end time cannot be set
     Backup > Full Backup Schedule(Day of Week)	Select	Full Backup Schedule Select the day of week for Full backup execution Full backup is performed every week
     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 feature DDL and user connection information records are saved Enabling Audit may degrade DB performance
     Parameter	Required	DB configuration parameters Search button can be clicked to view detailed information of the parameter Parameters can be modified after the service creation is completed, and a DB restart is required after modification
     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

• Additional Information Input area, please enter 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 Generate button.
   • When 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.

Microsoft SQL Server(DBaaS) To view detailed information, 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 detailed information on the page. Microsoft SQL Server(DBaaS) Details It navigates to the 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 tasks 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: Query real-time DB service status Backup history: If backup is configured, check whether backup runs correctly and view history Database recovery: Recover 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 On the page, you can view detailed information of the selected resource and, if necessary, edit the information.

Tag

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

Work History

Microsoft SQL Server(DBaaS) List page allows you to view the operation history of the selected resource.

Microsoft SQL Server(DBaaS) Managing Resources

If you need to change the existing configuration options of a created Microsoft SQL Server (DBaaS) resource, or recover it, or manage parameters, you can perform the work 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. Click the All Services > Database > Microsoft SQL Server(DBaaS) 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. Microsoft SQL Server(DBaaS) List page, click the resource to control operation. It moves to the Microsoft SQL Server(DBaaS) Details page.
4. Microsoft SQL Server(DBaaS) Check the status and complete the change using the control button below.
   • Start: The server where the DB service is installed and the DB service is running.
   • Stop: The server where the DB service is installed and the DB service are 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. Navigate to the Microsoft SQL Server(DBaaS) List page.
3. Click the resource to view the service status on the Microsoft SQL Server(DBaaS) List page. It moves to the Microsoft SQL Server(DBaaS) Details 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 status.

Change Server Type

You can change the configured server type.

To change the server type, follow the steps below.

1. Click the All Services > Database > Microsoft SQL Server(DBaaS) 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. Go 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 server type you want to change at the bottom of the detailed information. Server Type Edit popup window opens.
5. Edit Server Type In the popup window, after selecting the server type, 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. Click the All Services > Database > Microsoft SQL Server(DBaaS) 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 page, click the resource to add storage. Microsoft SQL Server(DBaaS) Details page will be opened.
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 the purpose and capacity, click the Confirm button.

Expanding storage

You can expand the storage added to the data area 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. Click the All Services > Database > Microsoft SQL Server(DBaaS) 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. Go 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) Details Navigate to the page.
4. Click the Edit icon of the additional Disk you want to add 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 unused Microsoft SQL Server (DBaaS) to reduce operating costs. However, if you cancel the service, the running service may be stopped immediately, 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. Click the All Services > Database > Microsoft SQL Server(DBaaS) 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 page, select the resource to cancel, and click the Cancel Service button.
4. Once the termination is complete, check whether the resource has been terminated on the Microsoft SQL Server(DBaaS) list page.