Skip to main content
NetApp Knowledge Base

Why are there only 2 Snapshot copies for SCSQL log backup?

  1. Last updated
    Apr 28, 2025
  2. Save as PDF
Views:
15
Visibility:
Public
Votes:
0
Category:
snapcenter
Specialty:
snapx
Last Updated:
4/28/2025, 5:53:08 AM

Applies to

SnapCenter Plug-in for Microsoft SQL Server (SCSQL)

Answer

It is because any number of backup files (TRB files) for SCSQL log backups are retained with just 2 Snapshot copies.

Example:

  1. Suppose there are 4 generations of backup files (TRB files), A, B, C, and D, on a volume.
    When a Snapshot (snapshot1) is created by SCSQL in this state, snapshot1 will include the log backup for 4 generations.
  2. Next, if a log backup E is taken and a log backup A is deleted, the volume will contain the 4 generations B, C, D, and E.
    When another Snapshot (snapshot2) is created by SCSQL in this state, snapshot2 will also include the log backups for these 4 generations.

In summary:

  • snapshot1 contains the backup files for A, B, C, and D.
  • snapshot2 contains the backup files for B, C, D, and E.

This means that just 2 Snapshot copies can retain log backups for a total of 5 generations.

Additional Information

 

NetApp provides no representations or warranties regarding the accuracy or reliability or serviceability of any information or recommendations provided in this publication or with respect to any results that may be obtained by the use of the information or observance of any recommendations provided herein. The information in this document is distributed AS IS and the use of this information or the implementation of any recommendations or techniques herein is a customer's responsibility and depends on the customer's ability to evaluate and integrate them into the customer's operational environment. This document and the information contained herein may be used solely in connection with the NetApp products discussed in this document.