The page has been translated by Gen AI.

DB Service Manage

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

Managing the Database

For the Microsoft SQL Server Enterprise edition, you can add a new database. Up to 100 can be added per cluster.

Add Database

To add a Database, follow these steps.

  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. You will be taken 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 be taken to the Microsoft SQL Server(DBaaS) Details page.
  4. Click the Add button in the Database name field. The Add Database popup window opens.
  5. In the Add Database popup window, click the + button to enter the Database name and select a drive, then click the Confirm button.

Delete Database

To delete the database, follow these steps.

  1. Click the All Services > Database > Microsoft SQL Server(DBaaS) menu. Navigate to the Service Home page of Microsoft SQL Server (DBaaS).
  2. On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. Navigate 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 be taken to the Microsoft SQL Server(DBaaS) Details page.
  4. Click the Edit button for the Database name field. The Add Database Delete popup window opens.
  5. Additional Database Deletion In the request popup, check the Database you want to delete and click the Delete button. The Database Deletion popup opens.
  6. Delete Database In the popup window, enter the name of the Database you want to delete, then click the Confirm button.

Managing Parameters

Provides a feature that enables easy viewing and modification of database configuration parameters.

Query Parameter

To view configuration parameters, follow these steps.

  1. Click the All Services > Database > Microsoft SQL Server(DBaaS) menu. You will be taken to the Service Home page of Microsoft SQL Server(DBaaS).
  2. On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. Navigate to the Microsoft SQL Server(DBaaS) List page.
  3. Microsoft SQL Server(DBaaS) List page, click the resource whose parameters you want to view or modify. Microsoft SQL Server(DBaaS) Details page will open.
  4. Click the More button, then click the Parameter Management button. The Parameter Management popup window opens.
  5. Parameter Management popup window, click the Search button. Search Notification popup window opens.
  6. Lookup Notification When the popup window opens, click the Confirm button. The lookup may take a short amount of time.

Modify Parameter

To modify the configuration parameters, follow these steps.

  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. You will be taken to the Microsoft SQL Server(DBaaS) List page.
  3. On the Microsoft SQL Server(DBaaS) List page, click the resource whose parameters you want to view or modify. You will be taken to the Microsoft SQL Server(DBaaS) Details page.
  4. Click the More button, then click the Parameter Management button. The Parameter Management popup opens.
  5. Parameter Management popup window, click the Search button. Search Notification popup window opens.
  6. Lookup Notification When the popup window opens, click the Confirm button. Retrieving the data may take a short time.
  7. If modification is needed, click the Edit button and enter the changes in the custom value area of the Parameter to be edited.
  8. When the input is complete, click the Complete button.

Managing DB Users

Provides functionality to query and manage DB user information.

Query DB Users

To retrieve DB users, 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. On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. You will be taken 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 be taken to the Microsoft SQL Server(DBaaS) Details page.
  4. Click the More button, then click the DB User Management button. You will be taken to the DB User Management page.
  5. DB User Management page, click the Search button. The search may take a short amount of time.

Change DB User Status

Follow these steps to change the status of the retrieved DB user.

  1. Click the All Services > Database > Microsoft SQL Server(DBaaS) menu. You will be taken to the Service Home page of Microsoft SQL Server(DBaaS).
  2. On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. You will be taken to the Microsoft SQL Server(DBaaS) List page.
  3. On the Microsoft SQL Server(DBaaS) List page, click the resource whose DB user you want to modify. You will be taken to the Microsoft SQL Server(DBaaS) Details page.
  4. Click the More button, then click the DB User Management button. You will be taken to the DB User Management page.
  5. On the DB User Management page, click the Search button. Retrieving may take a short time.
  6. If a correction is needed, click the Edit button, then change the status field value or enter remarks.
  7. When the input is complete, click the Complete button.

Modify Audit Settings

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

To change the Audit log storage settings of 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. On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. You will be taken to the Microsoft SQL Server(DBaaS) List page.
  3. On the Microsoft SQL Server(DBaaS) List page, click the resource to view the service status. You will be taken to the Microsoft SQL Server(DBaaS) Details page.
  4. Click the Edit icon of Audit Settings at the bottom of the detailed information. The Edit Audit Settings popup window opens.
  5. Edit Audit Settings After changing the usage in the popup window, click the Confirm button.
    • Use selected, the Audit log feature is enabled. Enabling the Audit log may degrade DB performance.
    • Disabling use will delete the Audit log storage file. Back up the Audit log file separately before disabling.

DB Log Export

Supports exporting log data that requires long-term retention among audit logs to Object Storage. Users can directly set the log types to be stored, the target Bucket for export, and the export interval. Based on the configured criteria, logs are copied to the specified Object Storage for retention. Additionally, to efficiently manage disk space, we also provide an option that exports logs to Object Storage while automatically deleting the original log files. By using this option, you can effectively free up storage capacity while safely retaining the necessary log data for long-term storage.

information
  • To use the DB Log export feature, you must create an Object Storage. For creating an Object Storage, please refer to the Object Storage User Guide.
  • Please be sure to check the expiration date and time of the authentication key. If the authentication key expires, logs will not be stored in the bucket.
  • Please ensure that authentication key information is not exposed externally.

Setting DB Log Export Mode

To set the DB Log export mode, follow these steps.

  1. Click the All Services > Database > Microsoft SQL Server(DBaaS) menu. You will be taken to the Service Home page of Microsoft SQL Server(DBaaS).
  2. On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. You will be taken to the Microsoft SQL Server(DBaaS) List page.
  3. On the Microsoft SQL Server(DBaaS) List page, click the resource whose DB Log you want to export. You will be taken to the Microsoft SQL Server(DBaaS) Details page.
  4. Click the More button, then click the DB Log Export button. You will be taken to the DB Log Export page.
  5. On the DB Log Export page, click the Register button. You will be taken to the DB Log Export Register page.
  6. On the DB Log Export Registration page, after entering the required information, click the Complete button.
    CategoryRequired
    Detailed description
    Log typeRequiredLog type to be saved
    Save bucket nameRequiredObject Storage bucket name to be saved
    Authentication key > Access keyRequiredAccess key to access the Object Storage you want to store
    Authentication key > Secret keyRequiredSecret key for accessing the Object Storage you want to store
    File creation intervalRequiredFile creation frequency in Object Storage
    Whether to delete the original logSelectionWhether to delete the original logs when exporting to Object Storage
    Table. Microsoft SQL Server (DBaaS) DB Log Export Configuration Items

Managing DB Log Export

To modify, cancel, or immediately export the DB Log export settings, 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. On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. You will be taken to the Microsoft SQL Server(DBaaS) List page.
  3. On the Microsoft SQL Server(DBaaS) List page, click the resource you want to manage DB Log export for. You will be taken to the Microsoft SQL Server(DBaaS) Details page.
  4. Click the More button, then click the DB Log Export button. You will be taken to the DB Log Export page.
  5. On the DB Log Export page, depending on the log type you want to manage, click the More button and then click the Export Now, Edit, or Cancel buttons.
    • Export Immediately: The selected logs are exported to the bucket of the previously configured Object Storage.
    • Edit: Modify the DB Log export mode settings.
    • Cancel: Cancel the DB Log export mode setting.

Minor Version Upgrade

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

Caution
  • First retrieve the service status by synchronizing it, then perform the version upgrade.
  • Please perform the version upgrade after setting up a backup. If you do not set up a backup, you may be unable to recover some data if a problem occurs during the upgrade.
  • The backed-up data will be automatically deleted after the version upgrade is completed.

To upgrade the Minor Version, 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. On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. You will be taken to the Microsoft SQL Server(DBaaS) List page.
  3. Microsoft SQL Server(DBaaS) List page, click the resource to upgrade the version. Navigate to the Microsoft SQL Server(DBaaS) Details page.
  4. Click the Edit button of the Image version item. The Version Upgrade popup window opens.
  5. Version Upgrade In the popup, select the updated version and backup setting, then click the Confirm button.
  6. Version Upgrade Notification Click the Confirm button in the popup window.
How-to guides
Backing up and restoring the DB