Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Error while running sp_addsubscription on publisher - "This database is not enabled for replication." Expand / Collapse
Posted Thursday, August 16, 2012 4:55 PM

Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, August 31, 2016 6:54 PM
Points: 595, Visits: 583
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.
Post #1346287
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse