Use the stored procedure sp_dropdistributor, or use the Disable Publishing and Distribution Wizard. Check agent log and logshipping monitor information.
The log shipping secondary database %s.%s has restore threshold of %d minutes and is out of sync. The Service Broker conversation to Database Mail ended without a response from Database Mail.
If the problem persists, replication metadata might be incorrect; consult Books The @property parameter value must be either ‘description’, ‘sync_object’, ‘type’, ‘ins_cmd’, ‘del_cmd’, ‘upd_cmd’, ‘filter’, ‘dest_table’, ‘dest_object’, ‘creation_script’, ‘pre_creation_cmd’, ‘status’, ‘schema_option’, or ‘destination_owner’.
Cannot create the subscription because the subscription already exists in the subscription database.
If the proble The parameter must be ‘description’, ‘taskid’, ‘sync_method’, ‘status’, ‘repl_freq’, ‘restricted’, ‘retention’, ‘immediate_sync’, ‘enabled_for_internet’, ‘allow_push’, ‘allow_pull’, ‘allow_anonymous’, or ‘retention’.
The value for the @sync_method parameter is not valid.
The FORCE option can be used to ignore this error and continue the operation, but data that cannot be decrypted by the old master key will become unavailable. If this is a database master key, you should attempt to open it in the session before performing this operation.
The FORCE option can be used to ignore this error and continue the operation but the data encrypte Caution: sys.sql_dependencies shows that other objects (views, procedures and so on) are referencing this object by its old name.
Only one subscription to the same publication is allowed in each subscription database.
Drop the subscription and add it again if necessary.
Could not subscribe to publication ‘%s’ because non-SQL Server Subscriber ‘%s’ only supports values of ‘character’, ‘bcp character’, ‘concurrent_c’, and ‘database snapshot character’ for the @sync_me The server ‘%s’ is already defined as a Distributor.
To reconfigure the server as a Distributor, you must first uninstall the exisiting Distributor.
LEARN SQL SERVER ONLINE | SQL SERVER TIPS AND TRICKS | SQL SERVER EXAMPLES TSQL | MSSQL | SQL Server 2012 | SQL SERVER 2008 R2 | SQL SERVER 2005 | SQL SERVER 2000 | SQL Server Personal Blog By Devi Prasad Cannot drop the publication because at least one subscription exists for this publication.