The page has been translated by Gen AI.

Managing DB Services

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

Managing Database

For the Microsoft SQL Server Enterprise edition, you can add a new database. You can add up to 100 per cluster.

Add Database

To add a Database, follow these steps.

  1. All Services > Database > Microsoft SQL Server (DBaaS) Click the menu. 1. Navigate to the Service Home page of Microsoft SQL Server (DBaaS).
  2. Click the Microsoft SQL Server(DBaaS) menu on the Service Home page. 2. Microsoft SQL Server(DBaaS) List Go to the page.
  3. Microsoft SQL Server(DBaaS) List On the page, click the resource to add storage. 3. Microsoft SQL Server(DBaaS) Details Go to the page.
  4. Click the Add button for the Database name field. 4. Add Database The popup window opens.
  5. Add Database In the 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. All Services > Database > Microsoft SQL Server (DBaaS) Click the menu. 1. Navigate to the Service Home page of Microsoft SQL Server (DBaaS).
  2. On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. 2. Microsoft SQL Server(DBaaS) List Go to the page.
  3. Microsoft SQL Server(DBaaS) List On the page, click the resource to add storage. 3. Microsoft SQL Server(DBaaS) Details Go to the page.
  4. Click the Edit button for the Database name field. 4. Delete Additional Database A popup window opens.
  5. Delete added Database In the request popup, check the Database you want to delete and click the Delete button. 5. Database Delete The popup window opens.
  6. Delete Database In the popup window, after entering the name of the Database you want to delete, click the Confirm button.

Managing Parameters

Provides a feature that allows you to easily view and modify database configuration parameters.

View Parameter

To view configuration parameters, follow these steps.

  1. All Services > Database > Microsoft SQL Server (DBaaS) Click the menu. 1. Navigate to the Service Home page of Microsoft SQL Server (DBaaS).
  2. Click the Microsoft SQL Server(DBaaS) menu on the Service Home page. 2. Microsoft SQL Server(DBaaS) List Navigate to the page.
  3. Microsoft SQL Server(DBaaS) List Click the resource on the page for which you want to view or modify parameters. 3. Microsoft SQL Server(DBaaS) Details Navigate to the page.
  4. Click the More button, then click the Parameter Management button. 4. Parameter Management The popup window opens.
  5. In the Parameter Management popup, click the Search button. 5. The Lookup Notification popup window opens.
  6. When the View Notification popup appears, click the Confirm button. 6. Retrieving may take a short amount of time.

Edit Parameter

To modify the configuration parameters, follow the steps below.

  1. All Services > Database > Microsoft SQL Server(DBaaS) Click the menu. 1. Go to the Service Home page of Microsoft SQL Server (DBaaS).
  2. On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. 2. Microsoft SQL Server(DBaaS) List Go to the page.
  3. Microsoft SQL Server(DBaaS) List Click the resource on the page whose parameters you want to view and modify. 3. Microsoft SQL Server(DBaaS) Details Go to the page.
  4. Click the More button, then click the Parameter Management button. 4. Parameter Management popup window opens.
  5. Parameter Management In the popup window, click the Search button. 5. View Notification A popup window opens.
  6. When the View Notification popup appears, click the Confirm button. 6. Retrieving may take a short amount of time.
  7. If editing is required, click the Edit button and enter the changes in the custom value field of the Parameter to be edited.
  8. When the input is complete, click the Done button.

Manage DB Users

Provides functionality to view and manage DB user information.

Query DB Users

To look up DB users, follow these steps.

  1. All Services > Database > Microsoft SQL Server (DBaaS) Click the menu. 1. Navigate to the Service Home page of Microsoft SQL Server (DBaaS).
  2. On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. 2. Microsoft SQL Server(DBaaS) List Navigate to the page.
  3. Microsoft SQL Server(DBaaS) List page, click the resource whose DB users you want to view. 3. Microsoft SQL Server(DBaaS) Details Go to the page.
  4. Click the More button and then click the DB User Management button. 4. Navigate to the DB User Management page.
  5. On the DB User Management page, click the Search button. 5. Retrieving may take a short amount of time.

Changing DB User Status

To change the status of the retrieved DB user, follow these steps.

  1. All Services > Database > Microsoft SQL Server (DBaaS) Click the menu. 1. Navigate to the Service Home page of Microsoft SQL Server (DBaaS).
  2. On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. 2. Microsoft SQL Server(DBaaS) List Go to the page.
  3. Microsoft SQL Server(DBaaS) List page, click the resource for which you want to edit the DB user. 3. Microsoft SQL Server(DBaaS) Details Navigate to the page.
  4. Click the More button, then click the DB User Management button. 4. Go to the DB User Management page.
  5. On the DB User Management page, click the Search button. 5. Retrieving may take a short amount of time.
  6. If modification is required, click the Edit button, and change the status area 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. All Services > Database > Microsoft SQL Server(DBaaS) Click the menu. 1. Navigate to the Service Home page of Microsoft SQL Server (DBaaS).
  2. Click the Microsoft SQL Server(DBaaS) menu on the Service Home page. 2. Microsoft SQL Server(DBaaS) List Navigate to the page.
  3. Microsoft SQL Server (DBaaS) List Click the resource to view the service status on this page. 3. Microsoft SQL Server(DBaaS) Details Go to the page.
  4. Click the Edit icon of Audit Settings at the bottom of the detailed information. 4. Audit Settings Modification The popup window opens.
  5. Audit Settings Modification After modifying the usage in the popup window, click the Confirm button.
    • When Use is selected, the Audit log feature is enabled. * Enabling audit logging may degrade database performance.
    • If you disable usage, the Audit log storage file will be deleted. * Back up the Audit log file separately before disabling.

Export DB Log

Supports exporting log data that requires long-term retention among audit (Audit) logs to Object Storage. Users can directly configure the log types that need to be stored, the destination Bucket for export, and the log export interval. Copies logs to the specified Object Storage for retention according to the configured criteria. 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 the long term.

안내
  • To use the DB Log export feature, you need to create an Object Storage. * To create Object Storage, please refer to the Object Storage 사용자 가이드.
  • Please be sure to verify 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 to external parties.

Setting the DB Log export mode

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

  1. All Services > Database > Microsoft SQL Server (DBaaS) Click the menu. 1. Navigate to the Service Home page of Microsoft SQL Server (DBaaS).
  2. On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. 2. Microsoft SQL Server(DBaaS) List Go to the page.
  3. Microsoft SQL Server(DBaaS) List Click the resource on the page for which you want to export the DB Log. 3. Microsoft SQL Server(DBaaS) Details Go to the page.
  4. Click the More button, then click the Export DB Log button. 4. Export DB Log Go to the page.
  5. Click the Register button on the DB Log Export page. 5. Go to the DB Log Export Registration page.
  6. On the DB Log Export Registration page, after entering the required information, click the 완료 button.
    CategoryRequired
    Detailed description
    Log typeRequiredLog type to be saved
    Save bucket nameRequiredObject Storage bucket name to be saved
    Authentication key > Access keyRequiredAccess key for accessing the Object Storage you want to store
    Authentication key > Secret keyRequiredSecret key for accessing the Object Storage you want to store
    File creation cycleRequiredFile 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

Manage DB Log Export

To modify, cancel, or immediately export the DB Log export settings, follow these steps.

  1. Click the All Services > Database > Microsoft SQL Server(DBaaS) menu. 1. Navigate to the Service Home page of Microsoft SQL Server (DBaaS).
  2. On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. 2. Microsoft SQL Server(DBaaS) List Go to the page.
  3. Microsoft SQL Server(DBaaS) List Click the resource on the page for which you want to manage DB Log export. 3. Microsoft SQL Server(DBaaS) Details Navigate to the page.
  4. Click the More button, then click the DB Log Export button. 4. Export DB Log Go to the 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, Terminate buttons.
    • Export Immediately: The selected logs are exported to the bucket of the previously configured Object Storage.
    • Edit: Modify the DB Log export mode setting.
    • Cancel: Cancel the DB Log export mode setting.

Minor version upgrade

Provides version upgrade functionality due to feature enhancements and security patches. Only minor version upgrades are supported within the same major version.

Caution
  • First retrieve the service status via service status synchronization, then proceed with the version upgrade.
  • It is recommended to perform an immediate backup in advance to prepare for any issues that may arise during the upgrade process. * If not, a failure may occur and some data may not be recoverable.
  • In a DB configured with Secondary(DR), the Primary DB version cannot be higher than the Secondary(DR) version. * First check the version of the Secondary (DR), and if necessary, perform a version upgrade.
  • The backed-up data is automatically deleted after the version upgrade is completed.

To perform a minor version upgrade, follow the steps below.

  1. All Services > Database > Microsoft SQL Server(DBaaS) Click the menu. 1. Navigate to the Service Home page of Microsoft SQL Server (DBaaS).
  2. On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. 2. Microsoft SQL Server(DBaaS) List Go to the page.
  3. Microsoft SQL Server(DBaaS) List page, click the resource to upgrade the version. 3. Microsoft SQL Server(DBaaS) Details Go to the page.
  4. Click the Edit button of the Image version item. 4. Version Upgrade A popup window opens.
  5. Version Upgrade In the popup, select the updated version and whether to enable backup, then click the Confirm button.
  6. Version Upgrade Notification Click the OK button in the popup window.
How-to guides
Backing up and restoring the DB