Failed to get LSN data from server
When this happens, the insert into msdb..backupmediafamily does not happen and we end up with incorrect information regarding the physical file name. This in turn is causing our custom built log shipping to fail on restore at the standby.
There is nothing corresponding with this in the VDI.log file
Has anyone else experienced this or know if it is fixed in a later version?
Attempting to make a backup of database PMPOcean [SQLSTATE 01000]
Database PMPOcean status: ONLINE [SQLSTATE 01000]
Backup type to create: tlog [SQLSTATE 01000]
Destination folder: \MSSQL\BACKUP\Translogs [SQLSTATE 01000]
Creating tlog backup of datatabase PMPOcean to \MSSQL\BACKUP\Translogs\tlog_PMPOcean_200610111430.bak [SQLSTATE 01000]
Backup command: -SQL "BACKUP LOG [PMPOcean] TO DISK = 'D:\MSSQL\BACKUP\Translogs\tlog_PMPOcean_200610111430.TRN' WITH NO_TRUNCATE, COMPRESSION = 1" -E' [SQLSTATE 01000]
SQL Backup (DLL v22.214.171.1241)
Backing up PMPOcean (transaction log) to:
Backup data size : 1.125 MB
Compressed data size: 66.000 KB
Compression rate : 94.27%
Processed 48 pages for database 'PMPOcean', file 'PMPOcean_log' on file 1.
BACKUP LOG successfully processed 48 pages in 0.006 seconds (65.280 MB/sec).
Error 742: Failed to get LSN data from server (0 rows returned). ()
SQL Backup exit code: 742
Error performing LOG backup of database PMPOcean [SQLSTATE 01000]
PMP Limited (Australia)