Answered by:
SQL 2019, problem with Transaction Log Shipping

Question
-
Hi everyone,
we have just upgrade our SQL servers to 2019 and I'm trying to establish Transaction Log Shipping (TrLS), to our backup server in DRL location.
Until now (with oldest version SQL 2012), everything was fine, how ever now with the 2019s, the TrLS is established and all the scheduled jobs are executing, but in Transaction Log Shipping Status in field Time Since Last, is not zeroing after job is executed.
Time goes only up...
On the primary side (production), we have two server in fail-over cluster and on DRL is single server, same as before with 2012.
Please for solution.
Best regards,
Aleksandar B. MCITP/MCSA
- Edited by AleksandarB Thursday, April 9, 2020 12:54 PM
Thursday, April 9, 2020 11:58 AM
Answers
-
>>Can I upgrade directly to CU4?
Sure, go for this
It is OK....
Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/
MS SQL optimization: MS SQL Development and Optimization
MS SQL Consulting: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
SQL Server Integration Services: Business Intelligence
- Marked as answer by AleksandarB Friday, April 10, 2020 9:04 PM
Friday, April 10, 2020 9:13 AM
All replies
-
Do you have latest CU installed?
The report calls sp_help_log_shipping_monitor to get the data
What is the output of select * from msdb.dbo.log_shipping_monitor_primary and select * from msdb.dbo.log_shipping_monitor_secondary
Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/
MS SQL optimization: MS SQL Development and Optimization
MS SQL Consulting: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
SQL Server Integration Services: Business Intelligence
Friday, April 10, 2020 4:28 AM -
I have RTM version.
Can I upgrade directly to CU4?
And, I'm planing to upgrade the stand alone server on DRL site, then the passive node on primary site, and after that, to switch active to passive node, and upgrade the last one. Is it ok?
Aleksandar B. MCITP/MCSA
Friday, April 10, 2020 7:57 AM -
>>Can I upgrade directly to CU4?
Sure, go for this
It is OK....
Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/
MS SQL optimization: MS SQL Development and Optimization
MS SQL Consulting: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
SQL Server Integration Services: Business Intelligence
- Marked as answer by AleksandarB Friday, April 10, 2020 9:04 PM
Friday, April 10, 2020 9:13 AM -
Hi AleksandarB,
Please check the error log whether shows description-of-error-message-14420-and-error-message-14421-that-occur
Best Regards.
yuxi
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.comFriday, April 10, 2020 10:18 AM