tencent cloud

Feedback

Viewing Backup List

Last updated: 2022-07-04 15:58:48

    TencentDB for SQL Server automatically backs up data based on the default backup settings. You can modify the automatic or manual backup settings in the console. You can also view the backup files and relevant information in the backup list.
    This document describes how to view backup files in the console.

    Directions

    1. Log in to the TencentDB for SQL Server console.
    2. Select the region at the top, find the target instance, and click the target instance ID or Manage in the Operation column to enter the instance management page.
    3. On the Backup Management tab, view backup tasks in the data or log backup list.
      • The data backup list displays the backup start/end times, name, policy, file format, and size, database, status, and operations (download, restore, delete).
      • The log backup list displays the file name, log data start/end times, backup size, and operation (download).
      • You can filter backup files by time (today, yesterday, past 7 or 30 days, or custom time period).
      • You can search for backup files in the search box on the right by backup name, database name, backup policy, backup mode, or backup file format.

    FAQs

    1. Can I download or restore backup files that exceed the retention period?

    Expired backup sets will be automatically deleted and cannot be downloaded or restored.

    • We recommend you configure a reasonable backup retention period based on your business needs or download the backup files in the TencentDB for SQL Server console.
    • You can also manually back up the instance data in the console, and manual backup files will be retained permanently.
      Note:

      Manual backups will also take up the backup space. We recommend you plan the usage of the backup space appropriately to reduce costs.

    2. Can I delete backups manually?

    • Automatic backups cannot be deleted manually. You can set the retention period for automatic backups, and they will be deleted automatically when they expire.
    • Manual backups can be manually deleted from the backup list in the TencentDB for SQL Server console. They can be retained permanently as long as they are not deleted.

    3. Can I disable data and log backups?

    No. However, you can lower the backup frequency and delete manual backup files no longer used in the TencentDB for SQL Server console to reduce the backup space usage.

    4. How can I reduce the backup space costs?

    • Delete manual backups that are no longer used (on the Instance Management > Backup Management page in the TencentDB for SQL Server console).
    • Reduce the frequency of automatic data backup for non-core businesses (you can adjust the backup cycle and backup file retention period in the console, which should be at least twice a week).
      Note:

      The rollback feature relies on the backup cycle and retention days of data backups and log backups. Rollback will be affected if you reduce the automatic backup frequency and retention period. You can select the parameters as needed.

    • Shorten the retention period of data and log backups for non-core businesses (a retention period of seven days can meet the needs in most cases).
    Business Scenario Recommended Backup Retention Period
    Core businesses 7–1,830 days
    Non-core, non-data businesses Seven days
    Archival businesses Seven days. We recommend you manually back up data based on your actual business needs and delete the backups promptly after use
    Testing businesses Seven days. We recommend you manually back up data based on your actual business needs and delete the backups promptly after use

    5. Can I download the backup files of an isolated instance?

    Yes.

    • A pay-as-you-go instance will be isolated into the recycle bin 24 hours after expiration. At this time, rollback and manual backup will be prohibited, but automatic backup can still be downloaded by clicking More in the Operation column of the instance. Excessive backup space of the instance will continue to be billed until the instance is eliminated.
    Contact Us

    Contact our sales team or business advisors to help your business.

    Technical Support

    Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

    7x24 Phone Support