SQL Server Errors or Failures from Error: 32004 to Error: 32023


Error: 32004, Severity: 10, Log shipping backup log job step.

Error: 32005, Severity: 10, Log shipping copy job step.
Error: 32006, Severity: 10, Log shipping restore log job step.
Error: 32007, Severity: 16, Database %s is not ONLINE.
Error: 32008, Severity: 10, Database %s is not ONLINE. The backup job will not be performed until this database is brought online.
Error: 32009, Severity: 16, A log shipping primary entry already exists for database %s.
Error: 32010, Severity: 16, Database %s does not exist as log shipping primary.
Error: 32011, Severity: 16, Primary Database %s has active log shipping secondary database(s). Drop the secondary database(s) first.
Error: 32012, Severity: 16, Secondary %s.%s already exists for primary %s.

Error: 32013, Severity: 16, A log shipping entry already exists for secondary database %s.
Error: 32014, Severity: 16, Database %s does not exist as log shipping secondary.
Error: 32015, Severity: 16, The primary database %s cannot have SIMPLE recovery for log shipping to work properly.
Error: 32016, Severity: 16, The specified agent_id %s or agent_type %d do not form a valid pair for log shipping monitoring processing.
Error: 32017, Severity: 16, Log shipping is supported on Enterprise, Developer and Standard editions of SQL Server. This instance has %s and is not supported.
Error: 32018, Severity: 16, Log shipping is not installed on this instance.

Error: 32019, Severity: 10, Log shipping alert job.
Error: 32020, Severity: 10, Log shipping alert job step.
Error: 32021, Severity: 10, Log shipping alert job schedule.
Error: 32022, Severity: 16, Cannot add a log shipping job with name %s. A job with same name already exists in the system and this job does not belong to log shipping category.
Error: 32023, Severity: 16, An entry for primary server %s, primary database %s does not exist on this secondary. Register the primary first.

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.

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 *