[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Rowguid not created on publishing a merge publication

Posted on 2004-04-08
7
Medium Priority
?
304 Views
Last Modified: 2006-11-17
I have a problem creating new merge publication on my database. My database contains several tables that don't have keys, so when I create the publication it was prompted that a  unique rowguid column will be automatically added. But when the creation of publication completed successfully I didn't find any new column added in my tables, and the snapshot can't be created too, so it can't be replicated.
Can anybody help me to solve this problem?
0
Comment
Question by:yento
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 13

Expert Comment

by:danblake
ID: 10782082
0
 

Author Comment

by:yento
ID: 10782091
Yes, I've applied SP1.
0
 
LVL 13

Expert Comment

by:danblake
ID: 10782114
We may have to create this manually,
  add a uniqueidentifier data-type to every table as required.
  Specify that this data-type is a ROWGUIDCOL,
  and specify newid() as the default value.

I've seen somebody else where the merge replication has not added the correct column as required.


I didn't find any new column added in my tables, and the snapshot can't be created too, so it can't be replicated.
--> Did the snapshot generate an error ?
What happens when you start the snapshot agent to generate a snapshot manually ?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

Author Comment

by:yento
ID: 10804066
If I create the snapshot manually, it was done as if it has succeeded, but there was nothing created in the ReplData folder, and when I try to create a new subscription it was completed but with a message:
"Subscriptions were created successfully at the following Subscribers:
      MYSERVER
The subscription at Subscriber 'MYSERVER' cannot be initialized immediately because the snapshot for this publication is not yet available. To initialize the subscription, start the Merge Agent after the snapshot is available."

I've tried to create the rowguid manually, but the results are the same.
0
 
LVL 13

Accepted Solution

by:
danblake earned 375 total points
ID: 10804294
IF you create the rowguid manually (then it would not allow you to alter this unless replication/subscription was disabled on the tables you were looking at, so I'm presuming this has been done and then the publication/subscribers have been recreated).

The snapshot will not be created until a subscriber exists.  
(So I'm presuming here that you've now created a subscriber and havn't yet rerun the snapshot agent.  Try now rerunning the snapshot agent, and lets have a look at the logs then)

Can you also catch all the information of the agents for the moment:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;312292
This should allow us to debug what is going on.. (I am interested in the error msgs/output msgs from the snapshot agent in this instance).


Can you also let me know which version/edition of sql-server you are using.
0
 

Author Comment

by:yento
ID: 10820001
The problem is solved. When I use the replication logging, I found that the snapshot agent failed to access the ReplData folder. When I see the permission on the folder I found that the user had a read only permission. After I changed the permission to full access, the snapshot is created succesfully.
Thanks for the clue... :)
0
 
LVL 13

Expert Comment

by:danblake
ID: 10820815
No worries, glad to help.
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question