Backup

Available in Classic

In Backup, you can view the backup information configured per server to safely store cached data for users using Cloud DB for MSSQL. If an incident occurs and cached data is lost, you can restore the data using the stored backup files. Both servers using high availability settings and stand-alone servers can use backup and restore features.

Before using backup and restore, it is recommended that you understand the basic backup execution rules provided by Cloud DB for MSSQL. The basic backup execution rules are:

• Backup execution method
  • Full backup: Performed once per day
  • Select between automatic settings and custom settings
    • Automatic settings: A random time is assigned when the MSSQL server is created, and backups are performed at a similar time to the first backup thereafter.
    • User-defined settings: Backup starts within 15 minutes after the user-selected time.
  • Log backup: Performed automatically at 15-minute intervals. The time cannot be configured.
• Backup files
  • Retention period: Can be retained for up to 30 days based on user settings.
  • Storage location: Stored in separate data storage (storage contracts depend on backup file size).

Backup interface

The following describes the basic components for using Backup:

View the backup settings list.

You can view the list of backup settings for each running MSSQL server. To view the backup settings list:

1. In the Classic environment of the NAVER Cloud Platform console, navigate to > Services > Database > Cloud DB for MSSQL.
2. Click the Backup menu.
3. When the backup settings list appears, review the required information.
   
   • DB service name: DB service name specified by the user
   • Backup retention days: Maximum number of days that backup files are stored in data storage
   • Full backup start time: Time when the full backup runs once per day
   • Stored backup data size: Total size of completed backup files (sum of full and log backups)
   • Full backup data size: Size of the full backup file
   • Log backup data size: Size of log backups created after the full backup
   • Log backup count: Number of log backups created after the full backup
   • View details: View detailed information about backup files created per server and restore them.

View the backup file list by server.

To view the list of backup files created per server after backups are completed:

1. In the Classic environment of the NAVER Cloud Platform console, navigate to > Services > Database > Cloud DB for MSSQL.
2. Click the Backup menu.
3. In View details for the backup settings row to view details, click [Details].
4. Review the backup file details.
   
   • DB name: Name of the backed-up database
   • Full backup start time: Time when the backup started
   • Full backup end time: Time when the backup completed
   • Full backup size: Size of the backup file
   • Associated log backup size:: Size of log backups created after the full backup
   • Associated log backup count: Number of log backups created after the full backup

Recovery

Cloud DB for MSSQL provides a service that lets you restore lost data using backup files and quickly create an MSSQL server. You can recover an MSSQL server by selecting a desired backup file from the stored backup list. To restore:

1. In the Classic environment of the NAVER Cloud Platform console, navigate to > Services > Database > Cloud DB for MSSQL.
2. Click the Backup menu.
3. In View details for the backup settings row to restore, click [Details].
4. Click [Recover].
5. When the DB Restore popup appears, review the specifications of the new server and the recoverable time based on the backup.
   
6. Enter the name of the new DB service to be created.
   • Enter 3-15 characters using Korean, English letters, numbers, and hyphens (-)
   • Duplicate names are not allowed
7. Set the date and time to restore within the recoverable time range confirmed in step 5.
8. Click [Confirm] to review the information of the database to be restored.
   • DB name: Database name used for restoration
   • Recovery model: Database model type used for restoration
   • Full backup size: Size of the full backup file used for restoration (MB)
   • Log backup size: Size of the log backup files used for restoration (MB)
   • Log backup count: Number of log files used for restoration One file is created every 15 minutes.
   • DB restore point: Point in time to which the database is restored
9. Click [Configure].
10. Check the status of the server being restored in the MSSQL server list on the DB server interface.
    • Creating: The MSSQL server is being created (restored) based on the entered information.
    • Configuring: The MSSQL server is being created (restored) and configured based on the entered information.
    • Running: The MSSQL server has been created (restored) and configured, and application servers can connect to it.

Delete backup files

To delete backup files created per MSSQL server:

1. In the Classic environment of the NAVER Cloud Platform console, navigate to > Services > Database > Cloud DB for MSSQL.
2. Click the Backup menu.
3. In View details for the backup settings row, click [Details].
4. Select the backup files to delete. Multiple selection is supported.
5. Click [Delete].
6. When the MSSQL Backup file deletion popup appears, review the information of the backup files to be deleted.
   
7. Click [Yes].