Sample Header Ad - 728x90

SQL Server 2019 Logship Restore getting failed for transactional data

0 votes
1 answer
235 views
I am trying to create a log shipping setup. The log shipping process restores the full backup to secondary, but the restore step is failing for transactional data. When I check the job history I see the following error message:
2023-12-12 18:12:01.96	*** Error: Failed to convert parameter value from a SqlGuid to a String.(System.Data) ***
2023-12-12 18:12:01.96	*** Error: Object must implement IConvertible.(mscorlib) ***
2023-12-12 18:12:01.98	Found first log backup file to restore. Secondary DB: 'BusDatabase', File: 'C:\copy\BusDatabase_20231212165000.trn'
2023-12-12 18:12:01.98	*** Error: Could not log history/error message.(Microsoft.SqlServer.Management.LogShipping) ***
2023-12-12 18:12:01.98	*** Error: Failed to convert parameter value from a SqlGuid to a String.(System.Data) ***
2023-12-12 18:12:01.98	*** Error: Object must implement IConvertible.(mscorlib) ***

-----------------------------------------------------------------------------------------

Message
2023-12-12 19:00:05.42	The restore operation was successful. Secondary Database: 'BusDatabase', Number of log backup files restored: 1
2023-12-12 19:00:05.42	*** Error: Could not log history/error message.(Microsoft.SqlServer.Management.LogShipping) ***
2023-12-12 19:00:05.42	*** Error: Failed to convert parameter value from a SqlGuid to a String.(System.Data) ***
2023-12-12 19:00:05.42	*** Error: Object must implement IConvertible.(mscorlib) ***
2023-12-12 19:00:05.42	Deleting old log backup files. Primary Database: 'BusDatabase'
2023-12-12 19:00:05.42	*** Error: Could not log history/error message.(Microsoft.SqlServer.Management.LogShipping) ***
2023-12-12 19:00:05.42	*** Error: Failed to convert parameter value from a SqlGuid to a String.(System.Data) ***
2023-12-12 19:00:05.42	*** Error: Object must implement IConvertible.(mscorlib) ***
2023-12-12 19:00:05.42	Deleting log backup file. File: 'C:\copy\BusDatabase_20231209184000.trn', Last Write Time (UTC): '12/9/2023 6:40:00 PM'
2023-12-12 19:00:05.42	*** Error: Could not log history/error message.(Microsoft.SqlServer.Management.LogShipping) ***
2023-12-12 19:00:05.42	*** Error: Failed to convert parameter value from a SqlGuid to a String.(System.Data) ***
2023-12-12 19:00:05.42	*** Error: Object must implement IConvertible.(mscorlib) ***
2023-12-12 19:00:05.43	Deleting log backup file. File: 'C:\copy\BusDatabase_20231209185000.trn', Last Write Time (UTC): '12/9/2023 6:50:00 PM'
2023-12-12 19:00:05.43	*** Error: Could not log history/error message.(Microsoft.SqlServer.Management.LogShipping) ***
2023-12-12 19:00:05.43	*** Error: Failed to convert parameter value from a SqlGuid to a String.(System.Data) ***
2023-12-12 19:00:05.43	*** Error: Object must implement IConvertible.(mscorlib) ***
2023-12-12 19:00:05.43	The restore operation was successful. Secondary ID: 'eb60caf8-e53f-49a4-823d-e98d18c3120a'
2023-12-12 19:00:05.43	*** Error: Could not log history/error message.(Microsoft.SqlServer.Management.LogShipping) ***
2023-12-12 19:00:05.43	*** Error: Failed to convert parameter value from a SqlGuid to a String.(System.Data) ***
2023-12-12 19:00:05.43	*** Error: Object must implement IConvertible.(mscorlib) ***
2023-12-12 19:00:05.43	----- END OF TRANSACTION LOG RESTORE     -----
If I restart me secondary server the latest data will get restored, but fails again if I add an new records. Below is my configuration for log shipping - backup job occurs every 10 mins - copy job occurs every 11 mins - restore job occurs every 12 mins Can anyone please tell me how to resolve this issue?
Asked by suhas dsouza
Dec 12, 2023, 06:36 PM
Last activity: Jun 13, 2025, 05:02 PM