I have an OLA problem
I have an AG running on MSSQL 2017 Standard with a single Secondary
The database is 2008 version
When i fallover the database i would expect to see the backup change from LOG to FULL with the ChangeBackupType option set.
When the database fall's over and the transaction log job runs i get a transaction log backup without a full backup on the new server.
@databases = 'AVAILABILITY_GROUP_DATABASES',
@Directory = N'F:\MSSQLBackup\SQLBackups',
@BackupType = 'LOG',
@verify = 'Y',
@CleanupTime = 48,
@checksum = 'Y',
@LogToTable = 'Y',
@compress = 'Y',
resulting backup command
BACKUP LOG [xxDATABASE] TO DISK = N'F:\MSSQLBackup\SQLBackups\AWS-SQLCLUS-01$AWS-xxDATABASE\xxDATABASE\LOG\AWS-SQLCLUS-01$AWS-xxDATABASE_xxDATABASE_LOG_20200331_100802.trn' WITH CHECKSUM, COMPRESSION