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.