SQL Server Errors or Failures from Error: 14051 to Error: 14070

SQLServerF1

 

Error: 14051, Severity: 16, The parameter value must be ‘sync_type’ or ‘dest_db’.
Error: 14052, Severity: 16, The @sync_type parameter value must be “automatic”, “none”, “replication support only”, “initialize with backup”, or “initialize from lsn”.
Error: 14053, Severity: 16, The subscription could not be updated at this time.
Error: 14054, Severity: 10, The subscription was updated successfully.
Error: 14055, Severity: 10, The subscription does not exist.

Error: 14056, Severity: 16, The subscription could not be dropped at this time.
Error: 14057, Severity: 16, The subscription could not be created.
Error: 14058, Severity: 16, Cannot create the subscription because the subscription already exists in the subscription database. Only one subscription to the same publication is allowed in each subscription database. Drop the subscription and add it again if necessary. If the proble
Error: 14059, Severity: 16, Materialized view articles cannot be created for publications with the properties allow_sync_tran, allow_queued_tran, or allow_dts.

Error: 14060, Severity: 16, Subscriber parameters specifying provider properties must be NULL for SQL Server subscribers.
Error: 14061, Severity: 16, The @pre_creation_cmd parameter value must be ‘none’, ‘drop’, ‘delete’, or ‘truncate’.
Error: 14062, Severity: 10, The Subscriber was dropped.
Error: 14063, Severity: 11, The remote server does not exist or has not been designated as a valid Subscriber.
Error: 14064, Severity: 10, Found generation stuck at genstatus 4.
Error: 14065, Severity: 16, The @status parameter value must be ‘initiated’, ‘active’, ‘inactive’, or ‘subscribed’.
Error: 14066, Severity: 16, The previous status must be ‘active’, ‘inactive’, or ‘subscribed’.
Error: 14067, Severity: 16, The status value is the same as the previous status value.
Error: 14068, Severity: 16, The subscription status of the object could not be changed.
Error: 14069, Severity: 16, Could not update sysarticles. The subscription status could not be changed.
Error: 14070, Severity: 16, Could not update the distribution database subscription table. The subscription status could not be changed.

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 *