42000 Error 14420
Contents |
One games Xbox 360 games PC error 14421 log shipping games Windows games Windows phone games Entertainment All
Error: 14421, Severity: 16, State: 1.
Entertainment Movies & TV Music Business & Education Business Students & sqlstate 42000 (error 14421) educators Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security
The Log Shipping Secondary Database Is Out Of Sync
Internet Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Band Microsoft sqlstate 42000 error 14421 the step failed Lumia All Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
secondary server but the log shipping jobs were failing. He shared the following error
Troubleshooting Log Shipping Issues
with me via email: Date 3/4/2016 8:36:00 PM Log Job History
Log Shipping Errors In Sql Server 2008
(LSAlert_KevinR) Step ID 1 Server KEVINR Job Name LSAlert_KevinR Step Name Log shipping alert job step. log shipping out of sync Duration 00:00:00 Sql Severity 16 Sql Message ID 14421 Operator Emailed Operator Net sent Operator Paged Retries Attempted 0 Message Executed as user: NT SERVICE\SQLSERVERAGENT. The https://support.microsoft.com/en-us/kb/329133 log shipping primary database KEVINR.AdventureWorksDW2008 has backup threshold of 60 minutes and has not performed a backup log operation for 898 minutes. Check agent log and logshipping monitor information. [SQLSTATE 42000] (Error 14420) The log shipping secondary database KEVINR\KEVINR2.AdventureWorksDW2008 has restore threshold of 45 minutes and is out of sync. No restore was http://www.sqlcoffee.com/Troubleshooting162.htm performed for 898 minutes. Restored latency is 0 minutes. Check agent log and logshipping monitor information. [SQLSTATE 42000] (Error 14421). The step failed. Cause. Examining the log shipping configuration, we found the SQL Server Agent on both instances configured with managed service accounts. The KB321247 Support article offers 3 choices for SQL Server service and SQL Server Agent service accounts on log shipping scenarios: a domain account (when the instances are located on an domain environment); a local network account (when network access is required by SQL Server services); the Local System account. The backup share that was configured by the student to hold the transaction log backups did not exist also. Solution. We recommended the student to use one of the 3 options fro the service account provided on the KB321247. He created the required shared folder and followed this step-by-step article on MSSQLTips.com. .Send mail to webmaster@sqlcoffee.com with questions or comments a
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've restricted the http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=195470 ability to create new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums SQL Server 2005 Forums SQL Server Administration (2005) log shipping job failing Reply to Topic Printer Friendly Author Topic raaj Posting Yak Master 129 Posts Posted-07/31/2014: 02:01:42 log shipping HI guys,I am having a LSAlert_Serv job and this job runs the system stored procedure sys.sp_check_log_shipping_monitor_alert. when this job is run I am getting the following error message: Here is the error message I am getting :The log shipping primary database SHARP has backup threshold of 60 minutes and has not performed a backup log operation for 7368 minutes. Check agent log and logshipping monitor information. [SQLSTATE out of sync 42000] (Error 14420). The step failed.The database named SHARP that is mentioned in the above error message is now moved to another server. When I looked into the stored procedure and when i ran the below query from the Stored procedure :select primary_server ,primary_database ,isnull(threshold_alert, 14420) ,backup_threshold ,cast(0 as int) from msdb.dbo.log_shipping_monitor_primary where threshold_alert_enabled = 1I can still see the database SHARP in the table msdb.dbo.log_shipping_monitor_primary. So, is it the reason for failure? If so, what to do to update the table msdb.dbo.log_shipping_monitor_primary and to fix the issue.Thanks,raaj. tkizer Almighty SQL Goddess USA 38200 Posts Posted-07/31/2014: 12:18:00 You can manually delete the rows from the log shipping* tables for that database.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ raaj Posting Yak Master 129 Posts Posted-07/31/2014: 19:48:16 Thanks tkizer.That's fixed now (just deleted that row from the table). Topic Reply to Topic Printer Friendly Jump To: Select Forum General SQL Server Forums New to SQL Server Programming New to SQL Server Administration Script Library Data Corruption Issues Database Design and Application Architecture SQL Server 2012 Forums Transact-SQL (2012) SQL Server Administration (2012) SSIS and Import/Export (2012) Analysis Server and Reporting Services (2012) Replication (2012) Availability