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
Last activity: Jun 13, 2025, 05:02 PM