Backup

Available in VPC

In Backup, you can check the backup information configured per server for safe storage of cache data for users using Cloud DB for MSSQL. Also, when the cache data is damaged due to a failure, you can perform restoration using the backup file that was in storage. In addition to servers using high availability settings, you can also use the backup and restoration features for standalone servers.

To use the backup and restoration, you should first understand the basic execution rules for the backup provided by Cloud DB for MSSQL. The basic backup execution rules are as follows:

• Backup execution methods
  • Full backup: performed daily, once a day
  • Select between automatic settings and user-defined settings
    • Automatic settings: a random time will be specified when an MSSQL server is created, and the backup will be performed at a time similar to the time of the first backup
    • User-defined settings: backups are performed within 15 minutes from the time selected by the user
  • Log backup: performed automatically at 15-minute intervals Backup time can't be specified
• Backup file
  • Retention period: can be stored up to 30 days according to the user settings
  • Storage location: a separate data storage (Storage contracts are made according to the backup file size)

Backup page

The basics of using the backup are as follows:

Check backup settings list

You can check the backup settings list per MSSQL server in operation. The following describes how to check the backup settings list.

1. From the VPC environment of NAVER Cloud Platform console, click the Services > Database > Cloud DB for MSSQL menus, in that order.
2. Click the Backup menu.
3. When the backup settings list appears, check the required information.
   
   • DB service name: DB service name specified by user
   • Backup retention period: maximum number of days for the backup file to be stored in data storage
   • FullBackup start time: time at which the backup is performed once a day
   • Backup data size in storage: total size of the completed backup file (Total number of full backup and log backup files)
   • FullBackup data size: size of the full backup file
   • Log backup data size: size of the log backup created after full backup
   • Number of log backups number of the log backup created after full backup
   • View details: details and restoration of the backup file list created per server

Check backup file list per server

The following describes how to check the backup file list created for each server after completing the backup:

1. From the VPC environment of NAVER Cloud Platform console, click the Services > Database > Cloud DB for MSSQL menus in that order.
2. Click the Backup menu.
3. Click the [Details] button from View details of the backup settings row you want to check the details for.
4. Check the details for the backup file.
   
   • DB name: backup DB name
   • FullBackup start time: the time when the backup started
   • FullBackup end time: the time when the backup ended
   • FullBackup size: size of backup files
   • Size of related log backup: size of log backup created after full backup
   • View log backups: view log backup details

Restoration

Cloud DB for MSSQL provides a service that enables you to restore lost data using backup files, and easily and quickly create an MSSQL server. You can select the backup file you want to restore from the list of backup files in storage, and restore the MSSQL server. The following describes how to restore it.

1. From the VPC environment of NAVER Cloud Platform console, click the Services > Database > Cloud DB for MSSQL menus, in that order.
2. Click the Backup menu.
3. Click the [Details] button under View details of the backup settings row you want to restore.
4. Click the [Restore] button.
5. When the DB Restore pop-up window appears, check the specifications of the server to be newly created and time available for recovery through backup.
   
6. Select a subnet to use in the DB server to be restored.
7. Select a DB server type to be restored.
8. Select a storage type for saving DB data, between SSD and HDD.
9. Enter the name of the DB service to be newly created.
   • The name must be 3-15 characters long and can only include Korean letters, English letters, numbers, and the hyphen (-)
   • A duplicated name can't be used
10. Set the date and time of recovery within the range of time available for recovery you checked from Step 5.
11. Click the [OK] button to check the information of the database to be recovered.
    • DB name: database name to be used for restoration
    • Recovery model: a database model type to be used for restoration
    • Full backup size: size of full backup files to be used for restoration (MB)
    • Log backup size: size of log backup files to be used for restoration (MB)
    • Number of log backup: number of log files to be used for restoration A log file is created every 15 minutes.
    • DB restoration point: the time when the database is restored and reverted
12. Click the [Set] button.
13. Check the status of the server being restored from the MSSQL server list on the DB server page.
    • Creating: status in which the MSSQL server is being created (restored) with the information entered by the user
    • Configuring: status in which the MSSQL server is being configured after being created (restored) with the information entered by the user
    • Running: status in which the creation (restoration) and configuration of the MSSQL server has been completed with the information entered by user, and access to the MSSQL server from the application servers is available

Delete backup file

The following describes how to delete backup files created for each MSSQL server.

1. From the VPC environment of NAVER Cloud Platform console, click the Services > Database > Cloud DB for MSSQL menus, in that order.
2. Click the Backup menu.
3. Click the [Details] button from View details of the backup settings row you want to delete backup files.
4. Select a backup file to delete. You can select multiple backup files.
5. Click the [Delete] button.
6. When the Delete MSSQL backup file pop-up window appears, check the information of the backup file to delete.
   
7. Click the [Yes] button.

Send to Object Storage

Cloud DB for MSSQL allows you to store the backup files you create in Object Storage. The following describes how to save a stored backup file to Object Storage:

1. From NAVER Cloud Platform console, click the Services > Database > Cloud DB for MSSQL menus.
2. Click the Backup menu.
3. Select the backup file and click the [Send to Object Storage] button.
   
4. When the Send to Object Storage popup window appears, click and select the bucket and folder you want to save into.
   
5. Press the [Send to Object Storage] button.
6. Click the [OK] button.