The page has been translated by Gen AI.

Backing up and restoring the DB

Users can configure backups of Microsoft SQL Server (DBaaS) through the Samsung Cloud Platform Console and restore from the backed‑up files.

Microsoft SQL Server(DBaaS) Backup

Microsoft SQL Server (DBaaS) provides a data backup feature based on its own backup commands. Additionally, it provides an optimized backup environment for data protection and management through backup history verification and backup file deletion features.

Configure Backup

For instructions on configuring backup settings for Microsoft SQL Server (DBaaS), see the Microsoft SQL Server(DBaaS) 생성하기 guide.

To modify the backup settings of the created resource, follow the steps below.

Caution

When a backup is configured, it runs at the designated time after the set schedule, and additional fees are incurred based on the backup volume.

  • If you change the backup setting to Unset, backup execution will stop immediately, and the stored backup data will be deleted and can no longer be used.
  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 you want to configure backup for. 3. Microsoft SQL Server(DBaaS) Details Go to the page.
  4. Click the Edit button of the backup item. 4. Backup Settings The popup window opens.
  5. When configuring a backup, click Use in the Backup Settings popup, select the retention period, backup start time, and Archive backup interval, then click the Confirm button.
    • If you want to stop the backup setting, uncheck Use in the Backup Settings popup window and authenticate via the logged-in user’s mobile phone.
      Once user authentication is completed, the backup setting is disabled and backup execution stops.

Perform immediate backup

If additional data protection is needed, you can quickly create a backup using the instant backup feature.

To perform an immediate backup, follow these steps.

  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 Navigate to the page.
  3. Microsoft SQL Server(DBaaS) List page, click the resource to perform an immediate backup. 3. Microsoft SQL Server(DBaaS) Details Navigate to the page.
  4. Click the Immediate Backup button of the backup item. 4. Immediate backup settings popup window opens.
  5. In the Immediate Backup Settings popup, click the Confirm button.

Check backup history

안내
To set notifications for backup success and failure, you can configure them through the Notification Manager product. For a detailed usage guide on configuring notification policies, refer to 알림 정책 생성하기.

To view the backup history, follow these steps.

  1. Click the All Services > Database > Microsoft SQL Server(DBaaS) 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. Navigate to the Microsoft SQL Server(DBaaS) List page.
  3. Microsoft SQL Server(DBaaS) List Click the resource to view the backup history on the page. 3. Microsoft SQL Server(DBaaS) Details Navigate to the page.
  4. Backup History Click the button. 4. Backup History The popup window opens.
  5. Backup History In the popup window, you can view the backup status, version, backup start time, backup completion time, and size.

Delete backup file

To delete the backup history, follow these steps.

Caution
Backup files cannot be restored after deletion. Please be sure to confirm that the data is unnecessary before deleting it.
  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. On the Microsoft SQL Server(DBaaS) List page, click the resource to view the backup history. 3. Microsoft SQL Server(DBaaS) Details Navigate to the page.
  4. Click the Backup History button. 4. Backup History The popup window opens.
  5. Backup History In the popup window, check the files you want to delete, then authenticate using the logged-in user’s mobile phone.
    • When user authentication is completed, the backup file will be deleted.

Recover Microsoft SQL Server(DBaaS)

If a failure or data loss requires restoration from a backup file, recovery can be performed based on a specific point in time using the recovery feature. When you perform a Microsoft SQL Server(DBaaS) recovery, a new server is created with the OS image from the initial provisioning point, the database is installed with the version from the backup point, and the recovery proceeds using the database’s configuration information and data.

To restore Microsoft SQL Server(DBaaS), follow these steps.

  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. Go to the Microsoft SQL Server(DBaaS) List page.
  3. Microsoft SQL Server(DBaaS) Resource On the list page, click the resource you want to recover. 3. Microsoft SQL Server(DBaaS) Details Navigate to the page.
  4. Click the Database Recovery button. 4. Database Recovery Navigate to the page.
  5. After entering the relevant information in the Database Recovery Configuration area, click the Complete button.
    Category
    required status
    		Detailed description
    Recovery typeRequiredSet the point in time the user wants to recover
    • Backup point (recommended): Recover based on the backup file. Select from the list of backup points displayed in the list
    • Custom point: Recover to a user‑desired point within the range of recoverable backup times. The recoverable period depends on the Archive backup schedule setting, allowing recovery to 1 hour/30 minutes/10 minutes/5 minutes before the current time from the initial backup start point. Select the date and time to back up
    Server name prefixRequiredRecovery DB server name
    • must start with a lowercase English letter and may include lowercase letters, numbers, and special characters (-) using 2~16 characters using 2~16 characters using 2~16 characters using 2~16 characters using 2~16 characters using 2~16 characters using 2~16 characters using 2~16 characters using 2~16 characters using 2~16 characters using 2~16 characters using 2~16 characters using 2~16 characters using 2~16 characters using 2~16 characters using 2~16 characters using 2~16 characters using 2~16 characters using 2~16 characters using 2~16 characters using 2~16 characters using 2~16 characters using 2~16 characters using 2~16 characters and between 2~16 characters between 2~16 characters between 2~16 characters 2~ Recovery DB server name
    in English English English
      Cluster nameRequiredRecovery DB cluster name
      • Enter using English letters, 3 ~ 20 characters
      • A cluster is a unit that groups multiple servers
      Service Type > Server TypeRequiredRecovery DB server type
      • Standard: standard specifications commonly used
      • High Capacity: large-capacity server of 24 vCore or more
      Service Type > Planned ComputeSelectionStatus of resources with Planned Compute set
      • In Use: Number of resources with Planned Compute that are currently in use
      • Configured: Number of resources with Planned Compute set
      • Coverage Preview: Amount applied per resource by Planned Compute
      Service Type > Block StorageRequiredBlock Storage settings used by the recovery DB
      • Basic OS: Area where the DB engine is installed
      • DATA: Data storage area
        • Applied identically with the storage type set in the original cluster
        • Enter capacity as a multiple of 8 within the range 16 to 5,120
      • Additional: Data storage area
        • Applied identically with the storage type set in the original cluster
        • In the recovery DB, only DATA and TEMP purposes can be added
        • After selecting Use, enter the storage purpose and capacity
        • To add storage, click the Add button; to delete, click the x button
        • Capacity can be entered as a multiple of 8 within the range 16 to 5,120, and up to 9 can be created
      Use ADSelectionPreconfigured AD (Active Directory) server usage setting
      • AD Server ID: AD User ID
      • AD Server Password: User Password
      Database usernameRequiredDatabase username
      • Apply the same username set in the original cluster
      Database Port numberRequiredDatabase Port number
      • Apply the same Port number as configured in the original cluster
      IP access controlSelectionService Access Policy Configuration
      • Since the access policy is set for the IP entered on the page, you do not need to configure a separate Security Group policy
      • Enter the IP in IP format (example: 192.168.10.1) or CIDR format (example: 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 IP
      Maintenance periodSelectionDB maintenance window
      • If you select Use, you can set the day of the week, start time, and duration
      • The maintenance window is a feature that allows the user to set the time slot for performing patch operations, and any patch work within that period is performed directly by the user.
      • We ask you to set a maintenance window for the stable operation of the system, and we are not responsible for any issues arising from not setting it or from failure to perform within the window.
      tagSelectionAdd Tag
      • After clicking the Add Tag button, enter or select Key, Value values
      Table. Microsoft SQL Server (DBaaS) recovery configuration items
    Managing DB Services
    Add Secondary