Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
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: Yesterday @ 9:40 AM
Points: 570, Visits: 479
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