The page has been translated by Gen AI.

DB Backup and Recovery

The user can set up a backup of Microsoft SQL Server(DBaaS) through the Samsung Cloud Platform Console and restore it with the backed-up file.

Microsoft SQL Server(DBaaS) backup

Microsoft SQL Server(DBaaS) provides a data backup feature based on its own backup command, and also provides an optimized backup environment for data protection and management through backup history checking and backup file deletion functions.

Setting up backup

The method of setting up a backup for Microsoft SQL Server(DBaaS) is described in the Microsoft SQL Server(DBaaS) creation guide, please refer to it.

To modify the backup settings of the generated resource, follow these steps.

Caution

If backup is set, backup is performed at the specified time after the set time, and additional fees are incurred depending on the backup capacity.

  • If the backup setting is changed to unset, the backup operation will be stopped immediately, and the saved backup data will be deleted and can no longer be used.
  1. All services > Database > Microsoft SQL Server(DBaaS) menu, click. It moves to the Service Home page of Microsoft SQL Server(DBaaS).
  2. On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. It moves to the Microsoft SQL Server(DBaaS) list page.
  3. Click the resource to set up backup on the Microsoft SQL Server(DBaaS) list page. It moves to the Microsoft SQL Server(DBaaS) details page.
  4. Click the Edit button of the backup item. The Backup Settings popup window opens.
  5. If you set up a backup, click Use in the Backup Settings popup window, select the retention period, backup start time, and Archive backup cycle, and then click the OK button.
    • If you want to stop the backup setting, uncheck 사용 in the 백업 설정 popup window and click the 확인 button.

Check Backup History

Notice
To set up notifications for backup success and failure, you can set them up through the Notification Manager product. For a detailed usage guide on setting up notification policies, please refer to Creating a Notification Policy.

To view the backup history, follow these steps.

  1. Click All Services > Database > Microsoft SQL Server(DBaaS) menu. It moves to the Service Home page of Microsoft SQL Server(DBaaS).
  2. Service Home page, click the Microsoft SQL Server(DBaaS) menu. It moves to the Microsoft SQL Server(DBaaS) list page.
  3. Microsoft SQL Server(DBaaS) list page, click the resource to check the backup history. It moves to the Microsoft SQL Server(DBaaS) details page.
  4. Click the Backup History button. The Backup History popup window opens.
  5. Backup History popup window where you can check the backup status, version, backup start time, backup completion time, and capacity.

Deleting backup files

To delete the backup history, follow these steps.

Caution
Backup files cannot be restored after deletion. Please make sure to check if the data is unnecessary before deleting it.
  1. Click All Services > Database > Microsoft SQL Server(DBaaS) menu. It moves to the Service Home page of Microsoft SQL Server(DBaaS).
  2. Service Home page, click the Microsoft SQL Server(DBaaS) menu. It moves to the Microsoft SQL Server(DBaaS) list page.
  3. Microsoft SQL Server(DBaaS) list page, click the resource to check the backup history. It moves to the Microsoft SQL Server(DBaaS) details page.
  4. Click the Backup History button. The Backup History popup window opens.
  5. Backup History popup window, check the file you want to delete, and then click the Delete button.

Microsoft SQL Server(DBaaS) Recovery

In the event of a disability or data loss that requires restoration with a backup file, recovery is possible based on a specific point in time through the recovery function. When performing Microsoft SQL Server (DBaaS) recovery, a new server is created with the OS image at the initial provisioning time, and the DB is installed with the version at the backup point, and the recovery proceeds with the DB configuration information and data.

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

  1. Click All Services > Database > Microsoft SQL Server(DBaaS) menu. It moves to the Service Home page of Microsoft SQL Server(DBaaS).
  2. Service Home page, click the Microsoft SQL Server(DBaaS) menu. Move to the Microsoft SQL Server(DBaaS) list page.
  3. Microsoft SQL Server(DBaaS) resource list page, click the resource you want to restore. Move to the Microsoft SQL Server(DBaaS) details page.
  4. Database Recovery 버튼을 클릭하세요. Database Recovery 페이지로 이동합니다.
  5. Database Recovery Configuration area, enter the corresponding information and click the Complete button.
Classification
Necessity
Detailed Description
Recovery TypeRequiredSet the point in time to recover
  • Backup Point (Recommended): Recover based on the backup file. Select from the list of backup file timestamps displayed in the list
  • Custom Point: Recover to the desired point in time within the range where backup is possible. The recoverable period is from the initial backup start time to 1 hour/30 minutes/10 minutes/5 minutes before the current time, based on the Archive backup cycle setting value. Select the date and time you want to back up
Server name prefixRequiredRecovery DB server name
  • Start with lowercase English letters, using lowercase letters, numbers, and special characters (-) to input 3-16 characters
  • A postfix such as 001, 002 is attached based on the server name, and the actual server name is created
Cluster NameRequiredRecovery DB Cluster Name
  • Enter in English, 3-20 characters
  • A cluster is a unit that bundles multiple servers
Service Type > Server TypeRequiredRecovery DB Server Type
  • Standard: Generally used standard specification
  • High Capacity: High-capacity server with 24vCore or more
Service Type > Planned ComputeSelectionCurrent status of resources with Planned Compute set
  • In Use: Number of resources with Planned Compute set that are in use
  • Setting: Number of resources with Planned Compute set
  • Coverage Preview: Amount applied by resource-based Planned Compute
  • Create Planned Compute Service: Move to the Planned Compute service application page
Service Type > Block StorageRequiredRecovery DB uses Block Storage settings
  • Basic OS: Area where the DB engine is installed
  • DATA: Data storage area
    • The storage type set in the original cluster is applied in the same way
    • Capacity can be entered in multiples of 8 in the range of 16 to 5,120
  • Additional: Data storage area
    • The storage type set in the original cluster is applied in the same way
    • Only DATA and TEMP purposes can be added in the recovery DB
    • Select Use and enter the purpose and capacity of the storage
    • To add storage, click the + button, and to delete, click the x button
    • Capacity can be entered in multiples of 8 in the range of 16 to 5,120, and up to 9 can be created
Database usernamerequiredDatabase username
  • Applied identically to the username set in the original cluster
Database Port numberrequiredDatabase Port number
  • Apply the same port number set in the original cluster
IP Access ControlSelectSet service access policy
  • Set access policy for IP entered on the page, so Security Group policy setting is not required separately
  • Enter in IP format (e.g., 192.168.10.1) or CIDR format (e.g., 192.168.10.0/24, 192.168.10.1/32) and click the Add button
  • To delete the entered IP, click the x button next to the entered IP
Maintenance periodSelectDB maintenance period
  • Use is selected, set the day of the week, start time, and duration
  • It is recommended to set the maintenance period for stable management of the DB. Patch work is performed at the set time and service interruption occurs
  • If not used, Samsung SDS is not responsible for the problems that occur due to non-application of patches.
TagSelectAdd Tag
  • Click the Add Tag button and enter or select Key, Value
Fig. Microsoft SQL Server(DBaaS) Recovery Configuration Items
Managing DB Services
Add Secondary