SQL Server Errors or Failures from Error: 14413 to Error: 14441

SQLServerF1

 

Error: 14413, Severity: 16, This database is already log shipping.
Error: 14414, Severity: 16, A log shipping monitor is already defined.
Error: 14415, Severity: 16, The user name cannot be null when using SQL Server authentication.
Error: 14416, Severity: 16, This stored procedure must be run in msdb.
Error: 14417, Severity: 16, Cannot delete the monitor server while databases are

participating in log shipping.
Error: 14418, Severity: 16, The specified @backup_file_name was not created from database ‘%s’.
Error: 14419, Severity: 16, The specified @backup_file_name is not a database backup.
Error: 14420, Severity: 16, The log shipping primary database %s.%s has backup threshold of %d minutes and has not performed a backup log operation for %d minutes. Check agent

log and logshipping monitor information.
Error: 14421, Severity: 16, The log shipping secondary database %s.%s has restore threshold of %d minutes and is out of sync. No restore was performed for %d minutes. Restored latency is %d minutes. Check agent log and logshipping monitor information.
Error: 14422, Severity: 16, Supply either @plan_id or @plan_name.
Error: 14423, Severity: 16, Other databases are enlisted on this plan and must be removed before the plan can be deleted.
Error: 14424, Severity: 16, The database ‘%s’ is already involved in log shipping.
Error: 14425, Severity: 16, The database ‘%s’ does not seem to be involved in log shipping.
Error: 14426, Severity: 16, A log shipping monitor is already defined. Call sp_define_log_shipping_monitor with @delete_existing = 1.
Error: 14427, Severity: 16, A user name is necessary for SQL Server security.
Error: 14428, Severity: 16, Could not remove the monitor as there are still databases involved in log shipping.
Error: 14429, Severity: 16, There are still secondary servers attached to this primary.
Error: 14430, Severity: 16, Destination path %s is not valid. Unable to list directory contents. Specify a valid destination path.
Error: 14440, Severity: 16, Could not set single user mode.
Error: 14441, Severity: 16, Role change succeeded.

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.

 

Leave a Reply

Your email address will not be published. Required fields are marked *