This is the multi-page printable view of this section. Click here to print.

Return to the regular view of this page.

How-to guides

1: Managing DB Service
2: DB Backup and Recovery
3: Adding Secondary
4: Microsoft SQL Server(DBaaS) server connection

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.

Notice

Before creating the service, please configure the VPC’s Subnet type as General.

If the Subnet type is Local, the creation of the corresponding Database service is not possible.

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

All Services > Database > Microsoft SQL Server(DBaaS) Click the menu. Navigate to the Service Home page of Microsoft SQL Server(DBaaS).
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.

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

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

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

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

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.

All Services > Database > Microsoft SQL Server(DBaaS) Click the menu. Navigate to the Service Home page of Microsoft SQL Server(DBaaS).
Click the Microsoft SQL Server(DBaaS) menu on the Service Home page. You will be taken to the Microsoft SQL Server(DBaaS) List page.
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.

Category	Detailed description
Server Information	Server information configured in the respective cluster Category: Server type (Primary, Secondary) Server name: Server name IP:Port: Server IP and port Status: Server status
Service	Service Name
Resource Type	Resource Type
SRN	Unique resource ID in Samsung Cloud Platform In DB service, it means cluster SRN
Resource	Resource Name In DB service, it means the cluster name
Resource ID	Unique resource ID in the service
Creator	User who created the service
Creation Date/Time	Service creation date/time
Editor	User who modified the service information
Modification Date	Date and time when service information was modified
Image Version	Installed DB Image and Version Information If a version upgrade is needed, click the Edit icon to set Minor Version Upgrade refer
Cluster Name	Name of the cluster where the servers are configured
Databse service name	Database management unit name
Database username	DB user name
Database name > default Database	Server name applied when installing DB
Database name > Add Database	Server name applied when installing DB

When adding a Database, click the **Add** button to add. Refer to [Add Database](/userguide/database/mssql/how_to_guides/managing.md#database-추가하기)

If you want to delete an added Database, click the **Edit** icon to add. Refer to [Delete Database](/userguide/database/mssql/how_to_guides/managing.md#database-삭제하기)

| | Planned Compute | Resource status with Planned Compute set

For more details, refer to [Planned Compute Apply](/userguide/financial_management/planned_compute/how_to_guides/)

| | Maintenance Period | DB Maintenance Period Status

If maintenance period setting is required, click the **Edit** icon to set

| | Backup | Backup configuration status

If backup configuration is needed, **Edit** icon to set

For details, refer to [Microsoft SQL Server(DBaas) Backup](/userguide/database/mssql/how_to_guides/backupandrestore.md#microsoft-sql-serverdbaas-백업하기)

| | Audit Log Settings | Audit Log Settings Status

If Audit Log settings are needed, click the **Edit** icon to configure

For details, refer to [Edit Audit Settings](/userguide/database/mssql/how_to_guides/managing.md#audit-설정-수정하기)

Can be checked only when high availability is configured

If you need to add or delete an IP, click the **Edit** icon to set

| | Primary & Secondary | Primary/Secondary server type, default OS, additional Disk information

If you need to modify the server type, click the **Edit** icon next to the server type to set it. Refer to [Change Server Type](#서버-타입-변경하기) for the server type modification procedure
- Modifying the server type requires a server reboot

If you need to expand storage, click the **Edit** icon next to the storage capacity to expand. Refer to [Expand Storage](#스토리지-증설하기) for the storage expansion procedure

If you need to add storage, click the **Add Disk** button next to Additional Disk to add. Refer to [Add Storage](#스토리지-추가하기) for the storage addition procedure

Table. Microsoft SQL Server(DBaaS) Database detailed information items

Category	Detailed description
Tag List	Tag List Can check the tag’s Key and Value information Up to 50 tags can be added per resource When entering tags, search and select from the existing list of Keys and Values

Work History

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

Category	Detailed description
Work History List	Resource Change History Work date/time, Resource ID, Resource name, Work details, Event topic, Work result, Verify worker information

Table. Microsoft SQL Server (DBaaS) Job History Tab Detailed Information Items

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.

Click the All Services > Database > Microsoft SQL Server(DBaaS) menu. Navigate to the Service Home page of Microsoft SQL Server(DBaaS).
Click the Microsoft SQL Server(DBaaS) menu on the Service Home page. Navigate to the Microsoft SQL Server(DBaaS) List page.
Microsoft SQL Server(DBaaS) List page, click the resource to control operation. It moves to the Microsoft SQL Server(DBaaS) Details page.
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.

All Services > Database > Microsoft SQL Server(DBaaS) Click the menu. Navigate to the Service Home page of Microsoft SQL Server(DBaaS).
Click the Microsoft SQL Server(DBaaS) menu on the Service Home page. Navigate to the Microsoft SQL Server(DBaaS) List page.
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.
Service Status Synchronization Click the button. While it is being queried, the cluster will change to Synchronizing state.
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.

Caution

If you modify the server type, a server restart is required. Please separately verify any SW license changes or SW settings and reflections due to server specification changes.

Click the All Services > Database > Microsoft SQL Server(DBaaS) menu. Go to the Service Home page of Microsoft SQL Server(DBaaS).
Click the Microsoft SQL Server(DBaaS) menu on the Service Home page. Go to the Microsoft SQL Server(DBaaS) List page.
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.
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.
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.

Caution

It is applied the same as the selected Storage type when creating a service.
For a high‑availability configured DB, adding storage is applied simultaneously to the storage of the Primary DB and the Secondary DB.

Click the All Services > Database > Microsoft SQL Server(DBaaS) menu. Go to the Service Home page of Microsoft SQL Server(DBaaS).
Click the Microsoft SQL Server(DBaaS) menu on the Service Home page. Navigate to the Microsoft SQL Server(DBaaS) list page.
Microsoft SQL Server(DBaaS) List page, click the resource to add storage. Microsoft SQL Server(DBaaS) Details page will be opened.
Click the Add Disk button at the bottom of the detailed information. The Add Storage Request popup window opens.
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.

Click the All Services > Database > Microsoft SQL Server(DBaaS) menu. Navigate to the Service Home page of Microsoft SQL Server(DBaaS).
Click the Microsoft SQL Server(DBaaS) menu on the Service Home page. Go to the Microsoft SQL Server(DBaaS) List page.
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.
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.
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.

Caution

If you terminate the DB, all stored data and any backup data will be deleted.

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

Click the All Services > Database > Microsoft SQL Server(DBaaS) menu. Go to the Service Home page of Microsoft SQL Server(DBaaS).
Click the Microsoft SQL Server(DBaaS) menu on the Service Home page. Navigate to the Microsoft SQL Server(DBaaS) List page.
Microsoft SQL Server(DBaaS) List page, select the resource to cancel, and click the Cancel Service button.
Once the termination is complete, check whether the resource has been terminated on the Microsoft SQL Server(DBaaS) list page.

1 - Managing DB Service

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

Managing Database

For Microsoft SQL Server Enterprise version, you can add new Databases. You can add up to 100 per cluster.

Adding Database

Follow these steps to add Database.

Click the All Services > Database > Microsoft SQL Server(DBaaS) menu. You will move to the Microsoft SQL Server(DBaaS)’s Service Home page.
On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. You will move to the Microsoft SQL Server(DBaaS) List page.
On the Microsoft SQL Server(DBaaS) List page, click the resource to add storage. You will move to the Microsoft SQL Server(DBaaS) Detail page.
Click the Add button in the Database name item. The Add Database popup window will open.
In the Add Database popup window, click the + button to enter Database name and select drive, then click the Confirm button.

Deleting Database

Follow these steps to delete Database.

Click the All Services > Database > Microsoft SQL Server(DBaaS) menu. You will move to the Microsoft SQL Server(DBaaS)’s Service Home page.
On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. You will move to the Microsoft SQL Server(DBaaS) List page.
On the Microsoft SQL Server(DBaaS) List page, click the resource to add storage. You will move to the Microsoft SQL Server(DBaaS) Detail page.
Click the Modify button in the Database name item. The Delete Added Database popup window will open.
In the Delete Added Database Request popup window, check the Database to delete and click the Delete button. The Delete Database popup window will open.
In the Delete Database popup window, enter the Database name to delete and then click the Confirm button.

Managing Parameters

Provides functionality to easily view and modify database configuration parameters.

Viewing Parameters

Follow these steps to view configuration parameters.

Click the All Services > Database > Microsoft SQL Server(DBaaS) menu. You will move to the Microsoft SQL Server(DBaaS)’s Service Home page.
On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. You will move to the Microsoft SQL Server(DBaaS) List page.
On the Microsoft SQL Server(DBaaS) List page, click the resource for which you want to view and modify parameters. You will move to the Microsoft SQL Server(DBaaS) Detail page.
Click the More button and click the Parameter Management button. The Parameter Management popup window will open.
In the Parameter Management popup window, click the View button. The View Notification popup window will open.
When the View Notification popup window opens, click the Confirm button. Viewing may take some time.

Modifying Parameters

Follow these steps to modify configuration parameters.

Click the All Services > Database > Microsoft SQL Server(DBaaS) menu. You will move to the Microsoft SQL Server(DBaaS)’s Service Home page.
On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. You will move to the Microsoft SQL Server(DBaaS) List page.
On the Microsoft SQL Server(DBaaS) List page, click the resource for which you want to view and modify parameters. You will move to the Microsoft SQL Server(DBaaS) Detail page.
Click the More button and click the Parameter Management button. The Parameter Management popup window will open.
In the Parameter Management popup window, click the View button. The View Notification popup window will open.
When the View Notification popup window opens, click the Confirm button. Viewing may take some time.
If modification is needed, click the Modify button and enter the modification in the custom value area of the Parameter to be modified.
When input is complete, click the Complete button.

Managing DB Users

Provides functionality to view and manage DB user information.

Viewing DB Users

Follow these steps to view DB users.

Click the All Services > Database > Microsoft SQL Server(DBaaS) menu. You will move to the Microsoft SQL Server(DBaaS)’s Service Home page.
On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. You will move to the Microsoft SQL Server(DBaaS) List page.
On the Microsoft SQL Server(DBaaS) List page, click the resource for which you want to view DB users. You will move to the Microsoft SQL Server(DBaaS) Detail page.
Click the More button and click the DB User Management button. You will move to the DB User Management page.
On the DB User Management page, click the View button. Viewing may take some time.

Changing DB User Status

Follow these steps to change the status of viewed DB users.

Click the All Services > Database > Microsoft SQL Server(DBaaS) menu. You will move to the Microsoft SQL Server(DBaaS)’s Service Home page.
On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. You will move to the Microsoft SQL Server(DBaaS) List page.
On the Microsoft SQL Server(DBaaS) List page, click the resource for which you want to modify DB users. You will move to the Microsoft SQL Server(DBaaS) Detail page.
Click the More button and click the DB User Management button. You will move to the DB User Management page.
On the DB User Management page, click the View button. Viewing may take some time.
If modification is needed, click the Modify button and change the status area value or enter remarks.
When input is complete, click the Complete button.

Modifying Audit Settings

You can change the Audit log storage settings for Microsoft SQL Server(DBaaS).

Follow these steps to change the Audit log storage settings for Microsoft SQL Server(DBaaS).

Click the All Services > Database > Microsoft SQL Server(DBaaS) menu. You will move to the Microsoft SQL Server(DBaaS)’s Service Home page.
On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. You will move to the Microsoft SQL Server(DBaaS) List page.
On the Microsoft SQL Server(DBaaS) List page, click the resource for which you want to view the service status. You will move to the Microsoft SQL Server(DBaaS) Detail page.
Click the Modify icon in Audit Settings at the bottom of the detailed information. The Modify Audit Settings popup window will open.
In the Modify Audit Settings popup window, modify the usage and then click the Confirm button.
- Selecting Use sets the Audit log function. Setting Audit logs may degrade DB performance.
- Disabling Use deletes the Audit log storage file. Please back up the Audit log file separately before disabling use.

Exporting DB Log

Supports exporting audit(Audit) log data that requires long-term retention to Object Storage. Users can directly set the log type to be saved, the destination Bucket to export to, and the cycle for exporting logs. Logs are copied and stored to the specified Object Storage according to the set criteria. Additionally, to efficiently manage disk space, provides an option to automatically delete original log files while exporting logs to Object Storage. Using this option allows you to effectively secure storage capacity while safely storing necessary log data for long-term retention.

Notice

To use the DB Log Export function, Object Storage creation is required. For Object Storage creation, please refer to the Object Storage User Guide.
Please check the expiration date of the authentication key. If the authentication key expires, logs will not be saved to the Bucket.
Please be careful not to expose authentication key information externally.

Setting DB Log Export Mode

Follow these steps to set DB Log export mode.

Click the All Services > Database > Microsoft SQL Server(DBaaS) menu. You will move to the Microsoft SQL Server(DBaaS)’s Service Home page.
On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. You will move to the Microsoft SQL Server(DBaaS) List page.
On the Microsoft SQL Server(DBaaS) List page, click the resource for which you want to export DB Log. You will move to the Microsoft SQL Server(DBaaS) Detail page.
Click the More button and click the DB Log Export button. You will move to the DB Log Export page.
On the DB Log Export page, click the Register button. You will move to the Register DB Log Export page.

On the Register DB Log Export page, enter the corresponding information and then click the Complete button.

Category	Required	Detailed Description
Log Type	Required	Log type to save
Storage Bucket Name	Required	Object Storage Bucket name to save
Authentication Key > Access key	Required	Access key to access the Object Storage to save
Authentication Key > Secret key	Required	Secret key to access the Object Storage to save
File Creation Cycle	Required	Cycle for creating files in Object Storage
Delete Original Log	Optional	Whether to delete original logs while exporting to Object Storage

Table. Microsoft SQL Server(DBaaS) DB Log Export Configuration Items

Managing DB Log Export

Follow these steps to modify, cancel, or immediately export DB Log export settings.

Click the All Services > Database > Microsoft SQL Server(DBaaS) menu. You will move to the Microsoft SQL Server(DBaaS)’s Service Home page.
On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. You will move to the Microsoft SQL Server(DBaaS) List page.
On the Microsoft SQL Server(DBaaS) List page, click the resource for which you want to manage DB Log export. You will move to the Microsoft SQL Server(DBaaS) Detail page.
Click the More button and click the DB Log Export button. You will move to the DB Log Export page.
On the DB Log Export page, click the More button according to the log type you want to manage and click the Immediate Export, Modify, or Cancel button.
- Immediate Export: The selected log is exported to the Bucket of the previously set Object Storage.
- Modify: Modifies the DB Log export mode settings.
- Cancel: Cancels the DB Log export mode settings.

Upgrading Minor Version

Provides version upgrade functionality for some feature improvements and security patches. Only Minor version upgrades within the same Major version are supported.

Caution

Please check the service status first through service status synchronization before performing version upgrade.
Please proceed with version upgrade after setting up backup. If backup is not set, some data may not be recoverable when problems occur during upgrade.
Backed up data is automatically deleted after version upgrade is complete.

Follow these steps to upgrade Minor Version.

Click the All Services > Database > Microsoft SQL Server(DBaaS) menu. You will move to the Microsoft SQL Server(DBaaS)’s Service Home page.
On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. You will move to the Microsoft SQL Server(DBaaS) List page.
On the Microsoft SQL Server(DBaaS) List page, click the resource to upgrade the version. You will move to the Microsoft SQL Server(DBaaS) Detail page.
Click the Modify button in the Image version item. The Version Upgrade popup window will open.
In the Version Upgrade popup window, select the modified version and backup setting, then click the Confirm button.
In the Version Upgrade Notification popup window, click the Confirm button.

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 for configuring 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.

Caution

If backup is set, backup is performed at the specified time after the set time, and additional fees are incurred depending on the backup capacity.

If the backup setting is changed to unset, the backup operation will be stopped immediately, and the saved backup data will be deleted and can no longer be used.

All services > Database > Microsoft SQL Server(DBaaS) menu, click. It moves to the Service Home page of Microsoft SQL Server(DBaaS).
On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. It moves to the Microsoft SQL Server(DBaaS) list page.
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.
Click the Edit button of the backup item. The Backup Settings popup window opens.
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 Use in the Backup Settings popup window and click the OK button.

Check Backup History

Notice

To set up notifications for backup success and failure, you can set them up through the Notification Manager product. For a detailed usage guide on setting up notification policies, please refer to Creating a Notification Policy.

To view the backup history, follow these steps.

Click All Services > Database > Microsoft SQL Server(DBaaS) menu. It moves to the Service Home page of Microsoft SQL Server(DBaaS).
Service Home page, click the Microsoft SQL Server(DBaaS) menu. It moves to the Microsoft SQL Server(DBaaS) list page.
Microsoft SQL Server(DBaaS) list page, click the resource to check the backup history. It moves to the Microsoft SQL Server(DBaaS) details page.
Click the Backup History button. The Backup History popup window opens.
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.

Caution

Backup files cannot be restored after deletion. Please make sure to check if the data is unnecessary before deleting it.

Click All Services > Database > Microsoft SQL Server(DBaaS) menu. It moves to the Service Home page of Microsoft SQL Server(DBaaS).
Service Home page, click the Microsoft SQL Server(DBaaS) menu. It moves to the Microsoft SQL Server(DBaaS) list page.
Microsoft SQL Server(DBaaS) list page, click the resource to check the backup history. It moves to the Microsoft SQL Server(DBaaS) details page.
Click the Backup History button. The Backup History popup window opens.
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.

Click All Services > Database > Microsoft SQL Server(DBaaS) menu. It moves to the Service Home page of Microsoft SQL Server(DBaaS).
Service Home page, click the Microsoft SQL Server(DBaaS) menu. Move to the Microsoft SQL Server(DBaaS) list page.
Microsoft SQL Server(DBaaS) resource list page, click the resource you want to restore. Move to the Microsoft SQL Server(DBaaS) details page.
Click the Database Recovery button. Go to the Database Recovery page.
Database Recovery Configuration area, enter the corresponding information and click the Complete button.

Classification	Necessity	Detailed Description
Recovery Type	Required	Set the point in time to recover Backup Point (Recommended): Recover based on the backup file. Select from the list of backup file timestamps displayed in the list Custom Point: Recover to the desired point in time within the range where backup is possible. The recoverable period is from the initial backup start time to 1 hour/30 minutes/10 minutes/5 minutes before the current time, based on the Archive backup cycle setting value. Select the date and time you want to back up
Server name prefix	Required	Recovery DB server name Start with lowercase English letters, using lowercase letters, numbers, and special characters (`-`) to input 3-16 characters A postfix such as 001, 002 is attached based on the server name, and the actual server name is created
Cluster Name	Required	Recovery DB Cluster Name Enter in English, 3-20 characters A cluster is a unit that bundles multiple servers
Service Type > Server Type	Required	Recovery DB Server Type Standard: Generally used standard specification High Capacity: High-capacity server with 24vCore or more
Service Type > Planned Compute	Selection	Current status of resources with Planned Compute set In Use: Number of resources with Planned Compute set that are in use Setting: Number of resources with Planned Compute set Coverage Preview: Amount applied by resource-based Planned Compute Create Planned Compute Service: Move to the Planned Compute service application page For more information, refer to Apply for Planned Compute
Service Type > Block Storage	Required	Recovery DB uses Block Storage settings Basic OS: Area where the DB engine is installed DATA: Data storage area The storage type set in the original cluster is applied in the same way Capacity can be entered in multiples of 8 in the range of 16 to 5,120 Additional: Data storage area The storage type set in the original cluster is applied in the same way Only DATA and TEMP purposes can be added in the recovery DB Select Use and enter the purpose and capacity of the storage To add storage, click the + button, and to delete, click the x button Capacity can be entered in multiples of 8 in the range of 16 to 5,120, and up to 9 can be created
Database username	required	Database username Applied identically to the username set in the original cluster
Database Port number	required	Database Port number Apply the same port number set in the original cluster
IP Access Control	Select	Set service access policy Set access policy for IP entered on the page, so Security Group policy setting is not required separately 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 the 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 the maintenance period for stable management of the DB. Patch work is performed at the set time and service interruption occurs If not used, Samsung SDS is not responsible for the problems that occur due to non-application of patches.
Tag	Select	Add Tag Click the Add Tag button and enter or select Key, Value

Fig. Microsoft SQL Server(DBaaS) Recovery Configuration Items

3 - Adding Secondary

Users can enter required information for Secondary through the Samsung Cloud Platform Console and create the service through detailed options.

Adding Secondary

Through Secondary configuration, you can create read-only replica servers. To configure Secondary additionally, it must be created with HA (High Availability) and Enterprise Edition, and the backup function must be enabled.

Follow these steps to configure Secondary.

Click the All Services > Database > Microsoft SQL Server(DBaaS) menu. You will move to the Microsoft SQL Server(DBaaS)’s Service Home page.
On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. You will move to the Microsoft SQL Server(DBaaS) List page.
On the Microsoft SQL Server(DBaaS) List page, click the resource to configure Secondary. You will move to the Microsoft SQL Server(DBaaS) Detail page.
Click the Add Secondary button. You will move to the Add Secondary page.

Enter information in the Secondary Configuration area and then click the Create button.

Category	Required	Detailed Description
Secondary Count	Required	Number of Secondaries to configure Can configure only 1 per cluster
Secondary Name	Required	Secondary server name Enter 3 ~ 15 characters starting with lowercase English letters, using lowercase letters, numbers, and special characters(`-`) The entered Secondary name is displayed as cluster name in the list
Service Type > Server Type	Required	Secondary server type Applied identically according to the server type set in the original DB
Service Type > Planned Compute	Optional	Status of resources with Planned Compute set In Use: Number of resources with Planned Compute set that are currently in use Set: Number of resources with Planned Compute set Coverage Preview: Amount applied by Planned Compute per resource Create Planned Compute Service: Moves to Planned Compute service application page For details, refer to Applying for Planned Compute
Network > Common Settings	Required	Network settings where servers created in the service are installed Applied identically with network settings set in original DB
Network > Per-Server Settings	Required	Network settings where servers created in the service are installed Select when applying different settings for each server being installed Applied identically with network settings set in original DB When setting per server, enter IP address within `10.10.10.0/24` range
License	Required	SQL Server License Key Enter the issued license key If the entered license key is invalid, the service may not be created

Table. Microsoft SQL Server(DBaaS) Secondary Configuration Items

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.

Architecture — Figure. Microsoft SQL Server(DBaaS) server connection architecture

Scenario Components

You can configure the scenario using the following services.

Service Group	Service	Detailed Description
Networking	VPC	A service that provides an independent virtual network in a cloud environment
Networking	VPC > Subnet	A service that allows users to subdivide the network into smaller segments according to purpose/size within the VPC
Networking	VPC > Public IP	A service that reserves public IP and assigns and returns it to Compute resources
Networking	VPC > Internet Gateway	A service that connects VPC resources to the internet
Networking	Security Group	A virtual firewall that controls the server’s traffic
Database	Microsoft SQL Server(DBaaS)	A service that easily creates and manages Microsoft SQL Server in a web environment
Compute	Virtual Server	Virtual server optimized for cloud computing
Compute	Virtual Server > Keypair	Encryption file used to connect to the Virtual Server

Table. Scenario Component List

Note

The default policy of Security Group is Deny All, so only allowed IPs must be registered.
In/Outbound’s All Open(Any IP, Any Port) policy can expose cloud resources to external threats.
- By specifying the necessary IP and Port to set the policy, you can enhance security.

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

For detailed creation methods, please refer to the Networking > VPC > How-to guides guide.

Click All services > Networking > VPC menu. It moves to the Service Home page of VPC.
On the Service Home page, click the Create VPC button. It moves to the Create VPC page.
VPC Creation page, please enter the information required for service creation.
- IP range should be entered as 192.168.x.0/16.
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

For detailed creation methods, please refer to the Networking > VPC > How-to guides > Subnet guide.

Click All services > Networking > VPC menu. It moves to the Service Home page of VPC.
Service Home page, click the Subnet menu. It moves to the Subnet list page.
Click the Subnet Creation button. It moves to the Subnet Creation page.
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.
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

For detailed creation methods, please refer to the Networking > VPC > How-to guides > Internet Gateway guide.

Click All services > Networking > VPC menu. It moves to the Service Home page of VPC.
On the Service Home page, click the Internet Gateway menu. It moves to the Internet Gateway list page.
Click the Create Internet Gateway button. It moves to the Create Internet Gateway page.
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.
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

For detailed creation methods, please refer to the Networking > VPC > How-to guides > Public IP guide.

Click All services > Networking > VPC menu. It moves to the Service Home page of VPC.
Service Home page, click the Public IP menu. It moves to the Public IP list page.
Public IP Reservation button, click. Move to the Public IP Reservation page.
Public IP Reservation page where you enter the required information necessary for service reservation.
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

For detailed creation methods, please refer to the Networking > Security Group > How-to guides guide.

Click All services > Networking > Security Group menu. It moves to the Service Home page of Security Group.
Service Home page, click the Create Security Group button. Move to the Create Security Group page.
Security Group Creation page, please enter the required information necessary for service creation.
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

For detailed creation methods, please refer to the Compute > Virtual Server > How-to guides > Keypair guide.

Click All Services > Compute > Virtual Server menu. It moves to the Service Home page of Virtual Server.
Service Home page, click the Keypair menu. It moves to the Keypair list page.
Create Keypair button will be clicked. It moves to the Create Keypair page.
Keypair creation page where you enter the required information necessary for service creation.
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

For detailed creation methods, please refer to the Compute > Virtual Server > How-to guides guide.

Click All Services > Compute > Virtual Server menu. It moves to the Service Home page of Virtual Server.
Service Home page, click the Virtual Server creation button. Move to the Virtual Server creation page.
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. Create Public IP.
- 2-1. Create Server Keypair and connect the Keypair created from there.
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

Click All Services > Compute > Virtual Server menu. It moves to the Service Home page of Virtual Server.
Service Home page, click the Virtual Server menu. Move to the Virtual Server list page.
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.
In the detailed information page, click the RDP password inquiry button in the Keypair name item. The RDP password inquiry pop-up window opens.
RDP password inquiry popup window, attach the keypair file downloaded from 2-1. Server Keypair creation.
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 credentials 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

For detailed creation methods, please refer to the Database > Microsoft SQL Server(DBaaS) > How-to guides guide.

Click on the menu for all services > Database > Microsoft SQL Server(DBaaS). It moves to the Service Home page of Microsoft SQL Server(DBaaS).
On the Service Home page, click the Create Microsoft SQL Server(DBaaS) button. It moves to the Create Microsoft SQL Server(DBaaS) page.
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.
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

For detailed creation methods, please refer to the Networking > Security Group > How-to guides guide.

Click All Services > Networking > Security Group menu. It moves to the Service Home page of Security Group.
Service Home page, click the Security Group menu. Move to the Security Group list page.
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.
Click the Rules tab on the detailed information page. It moves to the Rules tab.
Rule tab where you click the Add Rule button. Move to the Add Rule popup window.
In the Add Rule popup window, enter the rules below and click the OK button

Direction	Remote	Destination Address	Protocol	Port	Description
Inbound	CIDR	User PC IP	TCP	3389 (RDP)	Bastion connection PC → Bastion host
Outbound	CIDR	DB IP	TCP	Database Port (direct input)	Bastion host → Database

Fig. Security Group security rules to be added

4-2. Adding IGW Firewall Rules

For detailed creation methods, please refer to the Networking > Firewall > How-to guides guide.

Click All services > Networking > Firewall menu. It moves to the Service Home page of Firewall.
Service Home page, click the Firewall menu. It moves to the Firewall list page.
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.
Click the Rules tab on the detailed information page. It moves to the Rules tab.
Rule tab, click the Add Rule button. Move to the Add Rule popup window.
Add Rule In the popup window, enter the following rules and click the OK button.

Departure Address	Destination Address	Protocol	Port	Action	Direction	Description
Bastion connection PC IP	Bastion host IP	TCP	3389(RDP)	Allow	Inbound	User PC → Bastion host

Table. Internet Gateway Firewall rules to be added

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

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

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
Connect the hard drive of the user PC to upload the file to the Bastion host.
Click the Details button for local devices and resources entries in the Local Resources tab of Remote Desktop Connection.
Select the local disk where the file was downloaded to the drive and click the Confirm button.
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

Run SSMS (Microsoft SQL Server Management Studio). The Connect to Server popup window will appear.

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

Once the connection is complete, the Database will be connected. After connection, you can try performing simple queries, etc.