AppSync: SQL Transaction Log Backups are not expired if an older Full/Copy Database backup exists
This article applies to
This article does not apply to
This article is not tied to any specific product.
Not all product versions are identified in this article.
Symptoms
The user had configured AppSync to make transaction log backups immediately after every SQL database backup.
The user later noticed that the log backups were not being expired from the Backup Path on the SQL server.
The AppSync User and Admin Guide states that log backups are eligible for expiration when the following conditions occur:
- The log backup is older than the service plan Minimum Retention Hours setting.
- All older database backups are expired.
Cause
There were older copies of the database present under Service Plans > Microsoft SQL server.
Resolution
The AppSync server logs show the log backup that is being targeted for expiration, and the related SQL Database backup that is connected to it.
The logs show that there is a Full Copy of the database present from 7th September. As a result, any newer log backups cannot be expired.
The user navigated to Service Plans > SQL Server and expired the older copies from there.
Regardless of where copies are listed from, ensure the "copies" drop down filter on the page is set to ALL to ensure older copies are listed.
The logs show that there is a Full Copy of the database present from 7th September. As a result, any newer log backups cannot be expired.
10-24-2019 16:13:39.793 INFO [Thread-155378 (HornetQ-client-global-threads-1076521243)] [com.emc.archway.commands.application.mssql.GetSqlServerCopiesCommandBean] [<APPSYNC SERVER>] [] 4cf73b39-51cb-4427-8746-c66c80a81717->>> Getting log backups for expiration. Service plan database backup type option is Full
10-24-2019 16:13:39.840 INFO [Thread-155378 (HornetQ-client-global-threads-1076521243)] [com.emc.archway.commands.application.mssql.GetSqlServerCopiesCommandBean] [APPSYNC SERVER>] [] 4cf73b39-51cb-4427-8746-c66c80a81717->>> Getting log backups for FULL database backups for Database\Database name
10-24-2019 16:13:39.901 INFO [Thread-155378 (HornetQ-client-global-threads-1076521243)] [com.emc.archway.commands.application.mssql.GetSqlServerCopiesCommandBean] [APPSYNC SERVER>] [] 4cf73b39-51cb-4427-8746-c66c80a81717->>> Max time for log expiration: Wed 10/23/2019 04:13:39 PM
10-24-2019 16:13:39.901 INFO [Thread-155378 (HornetQ-client-global-threads-1076521243)] [com.emc.archway.commands.application.mssql.GetSqlServerCopiesCommandBean] [APPSYNC SERVER>] [] 4cf73b39-51cb-4427-8746-c66c80a81717->>> Oldest full timestamp: Sat 09/07/2019 03:04:31 AM
10-24-2019 16:13:39.901 INFO [Thread-155378 (HornetQ-client-global-threads-1076521243)] [com.emc.archway.commands.application.mssql.GetSqlServerCopiesCommandBean] [APPSYNC SERVER>] [] 4cf73b39-51cb-4427-8746-c66c80a81717->>> Using oldest full timestamp
10-24-2019 16:13:40.867 INFO [Thread-155378 (HornetQ-client-global-threads-1076521243)] [com.emc.archway.commands.application.mssql.GetSqlServerCopiesCommandBean] [APPSYNC SERVER>] [] 4cf73b39-51cb-4427-8746-c66c80a81717->>> Expiring 0 log backups.
10-24-2019 16:13:39.840 INFO [Thread-155378 (HornetQ-client-global-threads-1076521243)] [com.emc.archway.commands.application.mssql.GetSqlServerCopiesCommandBean] [APPSYNC SERVER>] [] 4cf73b39-51cb-4427-8746-c66c80a81717->>> Getting log backups for FULL database backups for Database\Database name
10-24-2019 16:13:39.901 INFO [Thread-155378 (HornetQ-client-global-threads-1076521243)] [com.emc.archway.commands.application.mssql.GetSqlServerCopiesCommandBean] [APPSYNC SERVER>] [] 4cf73b39-51cb-4427-8746-c66c80a81717->>> Max time for log expiration: Wed 10/23/2019 04:13:39 PM
10-24-2019 16:13:39.901 INFO [Thread-155378 (HornetQ-client-global-threads-1076521243)] [com.emc.archway.commands.application.mssql.GetSqlServerCopiesCommandBean] [APPSYNC SERVER>] [] 4cf73b39-51cb-4427-8746-c66c80a81717->>> Oldest full timestamp: Sat 09/07/2019 03:04:31 AM
10-24-2019 16:13:39.901 INFO [Thread-155378 (HornetQ-client-global-threads-1076521243)] [com.emc.archway.commands.application.mssql.GetSqlServerCopiesCommandBean] [APPSYNC SERVER>] [] 4cf73b39-51cb-4427-8746-c66c80a81717->>> Using oldest full timestamp
10-24-2019 16:13:40.867 INFO [Thread-155378 (HornetQ-client-global-threads-1076521243)] [com.emc.archway.commands.application.mssql.GetSqlServerCopiesCommandBean] [APPSYNC SERVER>] [] 4cf73b39-51cb-4427-8746-c66c80a81717->>> Expiring 0 log backups.
The user navigated to Service Plans > SQL Server and expired the older copies from there.
Regardless of where copies are listed from, ensure the "copies" drop down filter on the page is set to ALL to ensure older copies are listed.
Additional Information
Refer to the AppSync User and Administration Guide for more detailed information about SQL Server transaction log backups.
Affected Products
AppSyncProducts
AppSyncArticle Properties
Article Number: 000168706
Article Type: Solution
Last Modified: 18 Sept 2025
Version: 3
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.