All,

Please help.

Whenever i am trying to add subscription

exec sp_addsubscription @publication = N'DB_NEW',
@subscriber = N'SERVER1',
@destination_db = N'DBNAME',
@subscription_type = N'Push',
@sync_type = N'initialize with backup',
@article = N'all',
@update_mode = N'read only',
@subscriber_type = 0,
@backupdevicetype = N'disk',
@backupdevicename = 'C:\DBfile.bak'

i am getting below error.

Msg 14068, Level 16, State 1, Procedure sp_MSrepl_changesubstatus, Line 1353 The subscription status of the object could not be changed.

Msg 14057, Level 16, State 1, Procedure sp_MSrepl_addsubscription_article, Line 383 The subscription could not be created.

Msg 20021, Level 16, State 1, Procedure sp_MSrepl_addpushsubscription_agent, Line 258 The subscription could not be found.

Let me how to resolve this kind of issue.

It looks like your subscription is not active. can you do a sp_helppublication and post the results back here?

Not sure if this resolved, but you try

Check admin permissions if anything changed.

Check log reader agent is running. Any error in the SQL Error logs.

In the publisher database delete the missing article from syssubscriptions and sysschemaarticles. In the distribution database from MSsubscriptions and MSArticles After doing that you should be able to drop and recreate the publication and add subscription.