View SQL Server backup set metadata for snapshots

This topic describes how to use the command-line interface to view the backup set metadata for a SQL Server snapshot.

Procedure

1. Enter the following commands in the Delphix Engine command-line interface:

   snapshot;  
   ls; 
    select <snapshot name>;  
   ls; 
   The runtime section of the output will contain the backupSet object with the backup metadata: 
   runtime: 
           type: MSSqlSnapshotRuntime 
           backupSet: 
               type: MSSqlBackupSet 
               backupSetUUID: 9225DDE3-A6DD-4989-B799-58D9C4A833FA 
               backupType: DATABASE_DIFFERENTIAL 
               copyOnly: false 
               endTime: 2026-03-09T03:54:47.000Z 
               firstLsn: 35000000013200073 
               firstRecoveryForkGuid: 56FE7E6E-E424-4BDF-B2C4-0F5F9C5ED8D4 
               lastLsn: 35000000064000001 
               recoveryForkGuid: 56FE7E6E-E424-4BDF-B2C4-0F5F9C5ED8D4 
               recoveryModel: FULL 
               reference: MSSQL_BACKUP_SET-4 
               startTime: 2026-03-09T03:54:47.000Z 
           provisionable: true 

2. The following fields are available under the backupSet property:

   Field	Description
   backupType	Type of SQL Server backup. Options available are DATABASE_FULL, DATABASE_DIFFERENTIAL, or TRANSACTION_LOG.
   firstLsn	Log Sequence Number (LSN) at the start of the backup.
   lastLsn	LSN at the end of the backup.
   startTime	Time the backup started.
   endTime	Time the backup completed.
   recoveryModel	SQL Server recovery model at the time of backup. Options available are FULL, BULK_LOGGED, or SIMPLE.
   recoveryForkGuid	GUID of the recovery fork at the end of the backup.
   firstRecoveryForkGuid	GUID of the recovery fork at the start of the backup.
   copyOnly	Indicates whether the backup was a copy-only backup (true or false).
   backupSetUUID	Unique identifier of the backup set.

   Backup set metadata is only available for SQL Server dSource snapshots. The backupSet field will not be present for snapshots of other database types.