The page has been translated by Gen AI.

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.

  1. Click the All Services > Database > Microsoft SQL Server(DBaaS) menu. You will move to the Microsoft SQL Server(DBaaS)’s Service Home page.
  2. On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. You will move to the Microsoft SQL Server(DBaaS) List page.
  3. 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.
  4. Click the Add button in the Database name item. The Add Database popup window will open.
  5. 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.

  1. Click the All Services > Database > Microsoft SQL Server(DBaaS) menu. You will move to the Microsoft SQL Server(DBaaS)’s Service Home page.
  2. On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. You will move to the Microsoft SQL Server(DBaaS) List page.
  3. 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.
  4. Click the Modify button in the Database name item. The Delete Added Database popup window will open.
  5. 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.
  6. 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.

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

Modifying Parameters

Follow these steps to modify configuration parameters.

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

  1. Click the All Services > Database > Microsoft SQL Server(DBaaS) menu. You will move to the Microsoft SQL Server(DBaaS)’s Service Home page.
  2. On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. You will move to the Microsoft SQL Server(DBaaS) List page.
  3. On the Microsoft SQL Server(DBaaS) List page, click the resource for which you want to view DB users. You will move to the Microsoft SQL Server(DBaaS) Detail page.
  4. Click the More button and click the DB User Management button. You will move to the DB User Management page.
  5. 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.

  1. Click the All Services > Database > Microsoft SQL Server(DBaaS) menu. You will move to the Microsoft SQL Server(DBaaS)’s Service Home page.
  2. On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. You will move to the Microsoft SQL Server(DBaaS) List page.
  3. On the Microsoft SQL Server(DBaaS) List page, click the resource for which you want to modify DB users. You will move to the Microsoft SQL Server(DBaaS) Detail page.
  4. Click the More button and click the DB User Management button. You will move to the DB User Management page.
  5. On the DB User Management page, click the View button. Viewing may take some time.
  6. If modification is needed, click the Modify button and change the status area value or enter remarks.
  7. 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).

  1. Click the All Services > Database > Microsoft SQL Server(DBaaS) menu. You will move to the Microsoft SQL Server(DBaaS)’s Service Home page.
  2. On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. You will move to the Microsoft SQL Server(DBaaS) List page.
  3. On the Microsoft SQL Server(DBaaS) List page, click the resource for which you want to view the service status. You will move to the Microsoft SQL Server(DBaaS) Detail page.
  4. Click the Modify icon in Audit Settings at the bottom of the detailed information. The Modify Audit Settings popup window will open.
  5. 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.

  1. Click the All Services > Database > Microsoft SQL Server(DBaaS) menu. You will move to the Microsoft SQL Server(DBaaS)’s Service Home page.
  2. On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. You will move to the Microsoft SQL Server(DBaaS) List page.
  3. On the Microsoft SQL Server(DBaaS) List page, click the resource for which you want to export DB Log. You will move to the Microsoft SQL Server(DBaaS) Detail page.
  4. Click the More button and click the DB Log Export button. You will move to the DB Log Export page.
  5. On the DB Log Export page, click the Register button. You will move to the Register DB Log Export page.
  6. On the Register DB Log Export page, enter the corresponding information and then click the Complete button.
    CategoryRequired
    Detailed Description
    Log TypeRequiredLog type to save
    Storage Bucket NameRequiredObject Storage Bucket name to save
    Authentication Key > Access keyRequiredAccess key to access the Object Storage to save
    Authentication Key > Secret keyRequiredSecret key to access the Object Storage to save
    File Creation CycleRequiredCycle for creating files in Object Storage
    Delete Original LogOptionalWhether 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.

  1. Click the All Services > Database > Microsoft SQL Server(DBaaS) menu. You will move to the Microsoft SQL Server(DBaaS)’s Service Home page.
  2. On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. You will move to the Microsoft SQL Server(DBaaS) List page.
  3. On the Microsoft SQL Server(DBaaS) List page, click the resource for which you want to manage DB Log export. You will move to the Microsoft SQL Server(DBaaS) Detail page.
  4. Click the More button and click the DB Log Export button. You will move to the DB Log Export page.
  5. 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.

  1. Click the All Services > Database > Microsoft SQL Server(DBaaS) menu. You will move to the Microsoft SQL Server(DBaaS)’s Service Home page.
  2. On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. You will move to the Microsoft SQL Server(DBaaS) List page.
  3. 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.
  4. Click the Modify button in the Image version item. The Version Upgrade popup window will open.
  5. In the Version Upgrade popup window, select the modified version and backup setting, then click the Confirm button.
  6. In the Version Upgrade Notification popup window, click the Confirm button.
How-to guides
DB Backup and Recovery