Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Replication / July 2008

Tip: Looking for answers? Try searching our database.

Merge replication created w/ DMO - starting snapshot get error

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Darin - 30 Jul 2008 16:22 GMT
i am creating my merge publication via DMO in my VB.NET program. I used
to create only 1 publication, but since i now understand there is a
limit to the number of articles available for a single publication in
merge replication, i changed my program to make a publication for each
our our applications (like AP, AR, etc), which could be up to 15
different publications, some w/ 50+ articles, some w/ 5 articles.

In my program, after the publication is created i do:

For Each objJob In objJobs
  If objJob.JobID = objMergePublication.SnapshotJobID Then
     objJob.Start()
  End If
Next

During that start, it sometimes returns:

Unable to acquire the repication merge administrative application lock
for database 'XXX'. This could be due an active snapshot running while
the schema change (DDL) or the administrative proc change was attempted.

I ASSUME that means that i can't start all of the snapshots right after
the publication is created. But, I would also assume that it means i
will receive the same error if i try to start the snapshot job after all
publications are created (correct me if i am wrong).

Does the error mean that i will have to start one snapshot agent, wait
for it to be finished, then start the second, etc? If so, what is the
easiest way to start a job in VB (either w/ a TSQL script or DMO). Also,
what signal would be returned to the program when the snapshot is
created?

Thanks
Darin
Darin - 30 Jul 2008 19:33 GMT
i got it working by just issue a exec sp_start_job for each of the jobs
it created.

Darin
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.