Cannot create publication after upgrading SQL2005 > SQL2008 RRS feed

  • Question

  • I upgraded a SQL2005 machine to 2008 (enterprise) and applied SP1 and now I can not create publications.


    I get this error message when I run sp_addpublication

    Msg 8145, Level 16, State 1, Procedure sp_MSadd_publication, Line 0
    @allow_initialize_from_backup is not a parameter for procedure sp_MSadd_publication.


    I have check the stored procs and that parameter exists.

    The databases on there are set to version 10 and I had replication running before the upgrade but had to drop the publication.



    Thanks in advance


    Wednesday, August 11, 2010 11:56 PM


  • Gareth,

    I think when you removed the publication, you did not remove it properly.  run exec sp_removedbreplication 'databasename' to remove any leftover traces then try to recreate the publication.

    Thursday, August 12, 2010 12:35 AM