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 Databases

For Microsoft SQL Server Enterprise version, you can add new databases. Up to 100 databases can be added per cluster.

Adding a Database

To add a database, follow these steps:

  1. Click All Services > Database > Microsoft SQL Server (DBaaS) menu. You will be moved 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 moved to the Microsoft SQL Server (DBaaS) List page.
  3. On the Microsoft SQL Server (DBaaS) List page, click the resource you want to add storage to. You will be moved to the Microsoft SQL Server (DBaaS) Details page.
  4. Click the Add button in the Database Name field. The Add Database popup window will open.
  5. In the Add Database popup window, click the + button to enter the database name and select the drive, then click the Confirm button.

Deleting a Database

To delete a database, follow these steps:

  1. Click All Services > Database > Microsoft SQL Server (DBaaS) menu. You will be moved 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 moved to the Microsoft SQL Server (DBaaS) List page.
  3. On the Microsoft SQL Server (DBaaS) List page, click the resource you want to add storage to. You will be moved to the Microsoft SQL Server (DBaaS) Details page.
  4. Click the Modify button in the Database Name field. The Delete Additional Database popup window will open.
  5. In the Delete Additional Database Request popup window, check the database you want to delete and click the Delete button. The Delete Database popup window will open.
  6. In the Delete Database popup window, enter the name of the database you want to delete and click the Confirm button.

Managing Parameters

It provides a feature to easily view and modify database configuration parameters.

Viewing Parameters

To view configuration parameters, follow these steps:

  1. Click All Services > Database > Microsoft SQL Server (DBaaS) menu. You will be moved 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 moved to the Microsoft SQL Server (DBaaS) List page.
  3. On the Microsoft SQL Server (DBaaS) List page, click the resource you want to view and modify parameters for. You will be moved to the Microsoft SQL Server (DBaaS) Details page.
  4. Click the More button and then 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. It may take some time to view.

Modifying Parameters

To modify configuration parameters, follow these steps:

  1. Click All Services > Database > Microsoft SQL Server (DBaaS) menu. You will be moved 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 moved to the Microsoft SQL Server (DBaaS) List page.
  3. On the Microsoft SQL Server (DBaaS) List page, click the resource you want to view and modify parameters for. You will be moved to the Microsoft SQL Server (DBaaS) Details page.
  4. Click the More button and then 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. It may take some time to view.
  7. If modification is necessary, click the Modify button and enter the modification details in the user-defined value field of the parameter to be modified.
  8. After entering the modification details, click the Save button.

Managing DB Users

It provides a feature to view and manage DB user information.

Viewing DB Users

To view DB users, follow these steps:

  1. Click All Services > Database > Microsoft SQL Server (DBaaS) menu. You will be moved 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 moved to the Microsoft SQL Server (DBaaS) List page.
  3. On the Microsoft SQL Server (DBaaS) List page, click the resource you want to view DB users for. You will be moved to the Microsoft SQL Server (DBaaS) Details page.
  4. Click the More button and then click the DB User Management button. You will be moved to the DB User Management page.
  5. On the DB User Management page, click the View button. It may take some time to view.

Exporting DB Logs

It supports exporting audit logs that need to be stored for a long time to Object Storage. Users can set the log type to be stored, the target bucket to export to, and the export cycle. According to the set criteria, the logs are copied and stored in the designated Object Storage.

Additionally, to efficiently manage disk space, an option to automatically delete the original log files when exporting logs to Object Storage is provided. By utilizing this option, users can effectively secure storage capacity while safely storing necessary log data for a long time.

Note
  • To use the DB Log Export feature, Object Storage creation is required. Refer to the Object Storage User Guide for Object Storage creation.
  • Please check the expiration date of the authentication key. If the authentication key expires, logs will not be stored in the bucket.
  • Please be careful not to expose authentication key information to the outside.

Setting DB Log Export Mode

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

  1. Click All Services > Database > Microsoft SQL Server (DBaaS) menu. You will be moved 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 moved to the Microsoft SQL Server (DBaaS) List page.
  3. On the Microsoft SQL Server (DBaaS) List page, click the resource you want to export DB logs from. You will be moved to the Microsoft SQL Server (DBaaS) Details page.
  4. Click the More button and then click the DB Log Export button. You will be moved to the DB Log Export page.
  5. On the DB Log Export page, click the Register button. You will be moved to the DB Log Export Registration page.
  6. On the DB Log Export Registration page, enter the required information and click the Save button.
CategoryRequired
Detailed Description
Log TypeRequiredLog type to be stored
Storage Bucket NameRequiredObject Storage bucket name to store logs
Authentication Key > Access KeyRequiredAccess key to access Object Storage
Authentication Key > Secret KeyRequiredSecret key to access Object Storage
File Creation CycleRequiredCycle to create files in Object Storage
Original Log DeletionOptionalWhether to delete original logs when exporting to Object Storage
Table. Microsoft SQL Server (DBaaS) Migration Configuration Items

Managing DB Log Export

To modify, cancel, or immediately export DB log settings, follow these steps:

  1. Click All Services > Database > Microsoft SQL Server (DBaaS) menu. You will be moved 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 moved 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 moved to the Microsoft SQL Server (DBaaS) Details page.
  4. Click the More button and then click the DB Log Export button. You will be moved to the DB Log Export page.
  5. On the DB Log Export page, click the More button for the log type you want to manage and click the Immediate Export, Modify, or Cancel button.
    • Immediate Export: Exports the selected log to the Object Storage bucket.
    • Modify: Modifies the DB log export mode setting.
    • Cancel: Cancels the DB log export mode setting.

Upgrading Microsoft SQL Server (DBaaS) Version

It provides a feature to upgrade versions due to functional improvements and security patches. Only minor version upgrades are supported within the same major version.

Caution
  • Please perform version upgrades after checking the service status through service status synchronization.
  • Please set up backups before performing version upgrades. If backups are not set up, some data may not be recoverable in case of problems during the upgrade.
  • Backed-up data will be automatically deleted after the version upgrade is complete.

To upgrade the version, follow these steps:

  1. Click All Services > Database > Microsoft SQL Server (DBaaS) menu. You will be moved 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 moved to the Microsoft SQL Server (DBaaS) List page.
  3. On the Microsoft SQL Server (DBaaS) List page, click the resource you want to upgrade the version for. You will be moved to the Microsoft SQL Server (DBaaS) Details page.
  4. Click the Modify button in the Image/Version field. The Version Upgrade popup window will open.
  5. In the Version Upgrade popup window, select the version to upgrade to and whether to set up backups, then click the Confirm button.
  6. In the Version Upgrade Notification popup window, click the Confirm button.
How-to guides
DB Backup and Recovery