Backup
    • PDF

    Backup

    • PDF

    Article Summary

    Available in Classic

    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 recovery using the backup file that was in storage. In addition to servers using high availability settings, you can also use the backup and recovery features for standalone servers.

    To use the backup and recovery, 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 interval. Backup time can't be specified.
    • Backup file
      • Retention period: can be stored up to 30 days according to the user settings
      • Save 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.

    clouddbformssql-backup_main_vpc_en

    FieldDescription
    ① Menu nameName of the menu currently being viewed
    ② Basic featuresCheck details for Cloud DB for MSSQL, refresh the Backup page.
    ③ Backup listConfigured backup settings per server and settings information

    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 Classic environment of the 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.
      clouddbformssql-backup_backuplistdetails_vpc_en
      • 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 a full backup is performed once a day
      • Backup data size in storage: total size of backup-completed file (sum of full backup and log backup files)
      • FullBackup data size: size of the full backup file
      • Log backup data size: size of log backup which is created after the full backup
      • Number of log backups: number of log backups created after the full backup
      • View details: details and recovery 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 Classic environment of the 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.
      clouddbformssql-backup_backupdetails_vpc_en
      • DB name: name of the backed-up DB
      • FullBackup start time: the time when the backup started
      • FullBackup end time: the time when the backup was completed
      • FullBackup size: size of the backup file
      • Related log backup size: size of log backups created after the full backup
      • Number of related log backups: number of log backups created after the full backup

    Recovery

    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.

    Note
    • The backup file stores the data from the time of backup completion. Thus, when you restore it, it is restored to the data from the time of backup completion.
    • When you restore it, it is restored to the server specifications that was stored in the backup file. If you want to upgrade the server specifications after recovery, then use the Change DB specifications feature from the DB server menu.
    1. From the Classic environment of the 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.
      clouddbformssql-backup-restore_en
    6. Enter the name of the DB service to be created.
      • Enter between 3 and 15 characters using Korean letters, English letters, numbers, and hyphens (-).
      • A duplicated name can't be used.
    7. Set the date and time of recovery within the range of time available for recovery you checked from Step 5.
    8. Click the [OK] button to check information of the database to be recovered.
      • DB name: database name to be used for recovery
      • Recovery model: database model type to be used for recovery
      • Full backup size: size of the full backup file to be used for recovery (MB)
      • Log backup size: size of the log backup file to be used for recovery (MB)
      • Number of log backups: Number of log files to be used for recovery. A log file is created every 15 minutes.
      • DB recovery point: point to which the database will recover to
    9. Click the [Set] button.
    10. Check the status of the server being recovered from the MSSQL server list in 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 (recovery) 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
    Caution

    The completion of the server recovery may take a certain amount of time (minutes).

    Delete backup file

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

    Caution
    • Deleting backup files may impact recovery so that recovery to a certain point may not be available.
    • Backup files can't be recovered once deleted.
    1. From the Classic environment of the 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.
      clouddbformssql-backup_backupdelete_vpc_en
    7. Click the [Yes] button.

    Was this article helpful?

    What's Next
    Changing your password will log you out immediately. Use the new password to log back in.
    First name must have atleast 2 characters. Numbers and special characters are not allowed.
    Last name must have atleast 1 characters. Numbers and special characters are not allowed.
    Enter a valid email
    Enter a valid password
    Your profile has been successfully updated.