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 Stand Alone Server.

To use the backup and restoration, it is recommended to 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 for 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 interface

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. To view the backup settings list:

1. In the VPC environment of the NAVER Cloud Platform console, navigate to Menu > Services > Database > Cloud DB for MSSQL.
2. Click the Backup menu.
3. When the backup settings list appears, check the required information.
   
   • DB service name: The DB service name you specify
   • 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

To view the backup file list created for each server after completing the backup:

1. In the VPC environment of the NAVER Cloud Platform console, navigate to Menu > Services > Database > Cloud DB for MSSQL.
2. Click the Backup menu.
3. Click [Details] 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. To restore:

1. In the VPC environment of the NAVER Cloud Platform console, navigate to Menu > Services > Database > Cloud DB for MSSQL.
2. Click the Backup menu.
3. Click [Details] under View details of the backup settings row you want to restore.
4. Click [Restore].
5. When the DB Restore popup 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.
9. Enter the name of the DB service to be newly created.
   • Enter between 3 and 15 characters using Korean letters, English letters, numbers, and hyphens (-).
   • Duplicate names are not allowed.
10. Set the date and time of recovery within the range of time available for recovery you checked from Step 5.
11. Click [OK] 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 recovery point: The time when the database is restored and reverted
12. Click [v Recovery].
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

To delete backup files created for each MSSQL server:

1. In the VPC environment of the NAVER Cloud Platform console, navigate to Menu > Services > Database > Cloud DB for MSSQL.
2. Click the Backup menu.
3. Click [Details] 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 [Delete].
6. When the Delete MSSQL backup file popup window appears, check the information of the backup file to delete.
   
7. Click [Yes].

Send to Object Storage

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

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