Error while running sp_addsubscription on publisher - "This database is not enabled for replication."

• TheGreenShepherd

  SSCertifiable

  Points: 6979

  More actions

  August 16, 2012 at 4:55 pm

  #266026

  Publisher (SQLCluster3\Inst1) - SQL Server Enterprise (10.0.2531)

  Distributor (SQL23) - SQL Server Enterprise (10.0.2531)

  Subscriber (Reporting) - SQL Server Enterprise (10.0.1600)

  I've added the publication, set "Allow initializations from backups" in the publication properties, and am then trying to add the subscription with the following statement.

  exec sp_addsubscription @publication = N'[mydb]', @subscriber = N'reporting', @destination_db = N'[mydb]', @sync_type = N'initialize with backup',

  @backupdevicetype = 'disk', @backupdevicename = N'\\reporting2\backups2\[mydb].bak', @update_mode = N'read only'

  I've dropped and re-created the publication to no avail. Just end up with the same "This database is not enabled for publication" message. I'm sure I'm missing something rather dumb.

  Edit - I should also mention that yes, I am running this from the publisher.