• Drop its subscription and article and re-run snapshot:

    exec <your_db>.dbo.sp_dropsubscription

    @publication = <publication_name>,

    @article = <article_name>,

    @subscriber = 'all',

    @destination_db = 'all'

    go

    exec <your_db>.dbo.sp_droparticle

    @publication = <publication_name>,

    @article = <article_name>,

    @force_invalidate_snapshot = 1

    go

    exec msdb.dbo.sp_start_job 'repl_snapshot_job_name'

    go