.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

TransPublication.MakePullSubscriptionWellKnown bug?

Posted By:      Posted Date: October 21, 2010    Points: 0   Category :Sql Server

I'd like to initialize a pull transactional subscription with a backup (via RMO).

MSDN example tells that i should use the method TransPublication.MakePullSubscriptionWellKnown to register a subscription on a publisher.

However, if I pass a SubscriptionSyncType.InitializeWithBackup to that method, it throws exception

"The parameter @backupdevicename passed to stored procedure sp_MSextractlastlsnfrombackup cannot be NULL"

And there is no a way to pass @backupdevicename into the method MakePullSubscriptionWellKnown.

Here is a description how to do it calling stored procedures directly and it requires to pass @backupdevicename: http://msdn.microsoft.com/en-us/library/ms147834.aspx

So it looks like a design bug of RMO API.

View Complete Post

More Related Resource Links

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend