Showing posts with label sp2. Show all posts
Showing posts with label sp2. Show all posts

Friday, March 30, 2012

Merge Replication: Missing rows at Subscriber with no conflicts

Hi all,

We are using a mix of SQL 2005 and 2000 servers and our "main" database server is running SQL 2005 x64 (SP2 ver. 3042).

Our system has run perfectly for months, then subsequent to an SP2 update we are seeing several instances where the data record counts are different for several tables among all the servers.

We are using Merge Replication, with no filters and published every 2 minutes.

Any ideas?

TIA,

Michael

I have seen this before with SQL 2000 replication. It not uncommon especially for very high volumn data transfer. Unfortunately I cannot tell you what the issue is or why it happens.

Although I would advise that a 2 minute sync interval is probibly not useful for you at all. You should run the merge agent continuiously with the -continuious flag if you want it to sync this often.

I would change to continuious, reconcile the data then hopefully it doesnt happen again. If you can you would be better moving to an all SQL 2005 scenario.

Martin

sql

Wednesday, March 28, 2012

merge replication, help!

Hi,

I'm setting up a merge replication between one publisher(sql server 2005 standard sp2) and a couple of subscribers(sql server 2005 express sp2). They are connected with each other through VPN tunnels(1.5M adsl connections). I'm using pull replication, every 20 minutes. The initial snapshot replication was finished properly for each subscriber, but after several hours, the subscribers keep getting such kind of error message "Another merge agent for the subscription or subscriptions is running, or the server is working on a previous request by the same agent. (Source: MSSQLServer, Error number: 21036)". it looks like the vpn tunnel is not good sometimes, and the merge agent just sits there waiting. then another request comes in, it cannot get the handler of that agent which is held by the previous request. So how can i configure the server to release the agent when a new request comes in? or setup the timeout for each request?

Any idea would be appreciated.

Thank you very much!
Maybe you can consider -QueryTimeout parameter for the merge agent?|||thanks for reply.
but would u be able to tell me how to do that?
|||oh, sorry, i found it. the current timeout is 300, just 5 minutes. but i set the merge replication every 20 minutes. then how come this happens?
|||QueryTimeout is how long the merge agent will wait on a given query before timing out. The 20 minutes you specified sounds like the scheduled intervals at which the subscription will synchronize.sql

merge replication, help!

Hi,

I'm setting up a merge replication between one publisher(sql server 2005 standard sp2) and a couple of subscribers(sql server 2005 express sp2). They are connected with each other through VPN tunnels(1.5M adsl connections). I'm using pull replication, every 20 minutes. The initial snapshot replication was finished properly for each subscriber, but after several hours, the subscribers keep getting such kind of error message "Another merge agent for the subscription or subscriptions is running, or the server is working on a previous request by the same agent. (Source: MSSQLServer, Error number: 21036)". it looks like the vpn tunnel is not good sometimes, and the merge agent just sits there waiting. then another request comes in, it cannot get the handler of that agent which is held by the previous request. So how can i configure the server to release the agent when a new request comes in? or setup the timeout for each request?

Any idea would be appreciated.

Thank you very much!
Maybe you can consider -QueryTimeout parameter for the merge agent?|||thanks for reply.
but would u be able to tell me how to do that?
|||oh, sorry, i found it. the current timeout is 300, just 5 minutes. but i set the merge replication every 20 minutes. then how come this happens?
|||QueryTimeout is how long the merge agent will wait on a given query before timing out. The 20 minutes you specified sounds like the scheduled intervals at which the subscription will synchronize.

Monday, March 19, 2012

Merge Replication on Windows XP

Hi

Is it possible to create Merge Replication between two server running on Windows XP(SP2).

Why i ask this, as i am trying to do so, but got the error

"The process could not connect to Distributor",

As i already change the login for these two services for "local system" to with Administrative permisstions, but noting seem good for me.. getting the same error.)

when i googling around this, what i find, i need the Domain Account to login to as the services (SQL SERVER & SQL AGENT) one. is it so i need the domain controler for the this ?

How can i create a domain account, without PDC (primary domain controller).

or

so help me out, is there any boby who setup the same?

if so help me.... or ..... any other solution or hint to do so

Regards,

Thanks.

Gurpreet S. Gill

yes replication does work on XP, check your firewall settings on the machines. localsystem account should work, but you may lose some secuerity functionality.|||

Greg Y--

Thanks.

i had checked the Firewall settings, on the both of the machines these are already disabled, as i dont need much security, so i can go for that.

Now the point is, to who should i set the logon for the services, i mean the user, i already set it to the Administrator but doesnt work for me, what could be the cause, as i am continue getting the same error....

The process could not connect to Distributor 'server name'

Regads,

Thanks

Gurpreet S. Gill

|||

Hi all

Finally i am able to solve the problem, now my Merge Replication works very fine.

I would like to thank all who help me.

now i want to share that what i made

1) Create a Distributor & publisher one SERVER 1

2) Create the Subscriber on the SERVER 2.

point to note

i) i am on XP(with SP2) & SQL-Server 2005

ii) Default Snapshort Folder path at SERVER 1 must be in UNC (this is where i was making mistake)

iii) at theSERVER 2, the Subscription Properties page

Security Setting as as follows(number 6 in list)

a) Agent process accont

Account name : SERVER2\Administrator

Password :*********

b) Distributor Connection : SQL Server Authentication(sa)

c) Publisher Connection : SQL Server Authentication(sa)

iv) Both Machines having same user name & password for the SQL Server as well as the Machine login(Administrator)

if somebody still have any problem, then do post in this as a reply

Thanks

Regards

Gurpreet S. Gill

Merge Replication on SQL Server Compact Edition + SQL Server 2005 SP2

I followed the tutorial found on http://msdn2.microsoft.com/en-US/library/ms171908.aspx.

I have SQL Server 2005 with SP2 installed (NOT an Express version), SQL Server Compact Edition SDK, Server Tools and all other downloads I could find for CE. I'm running it on Windows XP Pro box, with SP2 and IIS 5.1.

Entering http://localhost/SQLMobile/sqlcesa30.dll?diag results in a page titled SQL Server Compact Edition Server Agent Diagnostics,

SQL Server Compact Edition Modules Test Module Status ErrorCode Version SQLCERP30.DLL SUCCESS 0x0 3.0.5300.0 SQLCESA30.DLL SUCCESS 0x0 3.0.5300.0

Reconciler Test Reconciler Status ErrorCode 9.0 Database Reconciler SUCCESS 0x0 8.0 Database Reconciler FAILURE 0x80004005


SQL Server Module Versions Module Version sqloledb.dll 2000.85.1117.0 9.0 replrec.dll 2005.90.3033.0 9.0 replprov.dll 2005.90.3033.0 9.0 msgprox.dll 2005.90.3033.0

I managed to solve all problems except one, occuring at the ending of the tutorial: Create a new subscription. When I'm trying to subscribe on created CE database I get the following error (at the second step of creating subscription):

Internal error: HTTP header information is either corrupted or missing in the transport message. It could be a network transmission error or an IIS problem.
HRESULT 0x80072F76 (28035)

I tried to google for it but only one result, with no solution.

Anybody has an idea what's wrong? I can provide further configuration details as necessary.

Thanks in advance

Cachotterie

I'm getting the same problem. Am running off a loopback adapter. Did you ever manage tot resolve this issue?|||In my case it was just Norton Internet Security firewall somehow modifying HTTP headers. I didn't find a way to make it work - just uninstalled it and now it is fine.|||

Have you solved this problem? I’m facing the same issue.

Thanks!

Eva

|||

I have this issue too ... and when I disable 'all of' Norton Security then the issue disappears.

For me it occurs in doing the tutorial: "Remote Data Access Synchronization with SQL Server 2005 Compact Edition and Visual C#.NET" at http://msdn2.microsoft.com/en-us/library/bb259792.aspx

With Norton Security active, whenever the tutorial code executes rda.Pull(...), I get the error message:

"Internal error: HTTP header information is either corrupted or missing in the transport message. ..."

The trouble is I can't work out what I need to adjust in Norton Security so that I can leave security active.

Any help will be greately appreciated. Cheers, Henk.

|||For all those finding themselves in this predicament, we found a solution for this problem with regards to the Norton Internet Security/Firewall issue.

As with other posters, we had a problem running SQL Server Merge Replication between the SQL Server CE clients and the SQL Server 2005 servers when the firewall was enabled. Disabled, it would run fine. The solution we came up with was to place the IP address or the entire subnet in some cases for the SQL Server 2005 servers into the Trusted Zones of the client firewall(s). This was accomplished here via Group Policy, but could be done on a case by case basis jus the same.

Hopefully this remedies someone elses heartache down the road. It was certainly frustrating for me.

Good luck!

-Patrick

Merge Replication on SQL Server Compact Edition + SQL Server 2005 SP2

I followed the tutorial found on http://msdn2.microsoft.com/en-US/library/ms171908.aspx.

I have SQL Server 2005 with SP2 installed (NOT an Express version), SQL Server Compact Edition SDK, Server Tools and all other downloads I could find for CE. I'm running it on Windows XP Pro box, with SP2 and IIS 5.1.

Entering http://localhost/SQLMobile/sqlcesa30.dll?diag results in a page titled SQL Server Compact Edition Server Agent Diagnostics,

SQL Server Compact Edition Modules Test

Module

Status

ErrorCode

Version

SQLCERP30.DLL

SUCCESS

0x0

3.0.5300.0

SQLCESA30.DLL

SUCCESS

0x0

3.0.5300.0

Reconciler Test

Reconciler

Status

ErrorCode

9.0 Database Reconciler

SUCCESS

0x0

8.0 Database Reconciler

FAILURE

0x80004005

SQL Server Module Versions

Module

Version

sqloledb.dll

2000.85.1117.0

9.0 replrec.dll

2005.90.3033.0

9.0 replprov.dll

2005.90.3033.0

9.0 msgprox.dll

2005.90.3033.0

I managed to solve all problems except one, occuring at the ending of the tutorial: Create a new subscription. When I'm trying to subscribe on created CE database I get the following error (at the second step of creating subscription):

Internal error: HTTP header information is either corrupted or missing in the transport message. It could be a network transmission error or an IIS problem.
HRESULT 0x80072F76 (28035)

I tried to google for it but only one result, with no solution.

Anybody has an idea what's wrong? I can provide further configuration details as necessary.

Thanks in advance

Cachotterie

I'm getting the same problem. Am running off a loopback adapter. Did you ever manage tot resolve this issue?|||In my case it was just Norton Internet Security firewall somehow modifying HTTP headers. I didn't find a way to make it work - just uninstalled it and now it is fine.|||

Have you solved this problem? I’m facing the same issue.

Thanks!

Eva

|||

I have this issue too ... and when I disable 'all of' Norton Security then the issue disappears.

For me it occurs in doing the tutorial: "Remote Data Access Synchronization with SQL Server 2005 Compact Edition and Visual C#.NET" at http://msdn2.microsoft.com/en-us/library/bb259792.aspx

With Norton Security active, whenever the tutorial code executes rda.Pull(...), I get the error message:

"Internal error: HTTP header information is either corrupted or missing in the transport message. ..."

The trouble is I can't work out what I need to adjust in Norton Security so that I can leave security active.

Any help will be greately appreciated. Cheers, Henk.

|||For all those finding themselves in this predicament, we found a solution for this problem with regards to the Norton Internet Security/Firewall issue.

As with other posters, we had a problem running SQL Server Merge Replication between the SQL Server CE clients and the SQL Server 2005 servers when the firewall was enabled. Disabled, it would run fine. The solution we came up with was to place the IP address or the entire subnet in some cases for the SQL Server 2005 servers into the Trusted Zones of the client firewall(s). This was accomplished here via Group Policy, but could be done on a case by case basis jus the same.

Hopefully this remedies someone elses heartache down the road. It was certainly frustrating for me.

Good luck!

-Patrick

Merge Replication on SQL Server Compact Edition + SQL Server 2005 SP2

I followed the tutorial found on http://msdn2.microsoft.com/en-US/library/ms171908.aspx.

I have SQL Server 2005 with SP2 installed (NOT an Express version), SQL Server Compact Edition SDK, Server Tools and all other downloads I could find for CE. I'm running it on Windows XP Pro box, with SP2 and IIS 5.1.

Entering http://localhost/SQLMobile/sqlcesa30.dll?diag results in a page titled SQL Server Compact Edition Server Agent Diagnostics,

SQL Server Compact Edition Modules Test Module Status ErrorCode Version SQLCERP30.DLL SUCCESS 0x0 3.0.5300.0 SQLCESA30.DLL SUCCESS 0x0 3.0.5300.0

Reconciler Test Reconciler Status ErrorCode 9.0 Database Reconciler SUCCESS 0x0 8.0 Database Reconciler FAILURE 0x80004005


SQL Server Module Versions Module Version sqloledb.dll 2000.85.1117.0 9.0 replrec.dll 2005.90.3033.0 9.0 replprov.dll 2005.90.3033.0 9.0 msgprox.dll 2005.90.3033.0

I managed to solve all problems except one, occuring at the ending of the tutorial: Create a new subscription. When I'm trying to subscribe on created CE database I get the following error (at the second step of creating subscription):

Internal error: HTTP header information is either corrupted or missing in the transport message. It could be a network transmission error or an IIS problem.
HRESULT 0x80072F76 (28035)

I tried to google for it but only one result, with no solution.

Anybody has an idea what's wrong? I can provide further configuration details as necessary.

Thanks in advance

Cachotterie

I'm getting the same problem. Am running off a loopback adapter. Did you ever manage tot resolve this issue?|||In my case it was just Norton Internet Security firewall somehow modifying HTTP headers. I didn't find a way to make it work - just uninstalled it and now it is fine.|||

Have you solved this problem? I’m facing the same issue.

Thanks!

Eva

|||

I have this issue too ... and when I disable 'all of' Norton Security then the issue disappears.

For me it occurs in doing the tutorial: "Remote Data Access Synchronization with SQL Server 2005 Compact Edition and Visual C#.NET" at http://msdn2.microsoft.com/en-us/library/bb259792.aspx

With Norton Security active, whenever the tutorial code executes rda.Pull(...), I get the error message:

"Internal error: HTTP header information is either corrupted or missing in the transport message. ..."

The trouble is I can't work out what I need to adjust in Norton Security so that I can leave security active.

Any help will be greately appreciated. Cheers, Henk.

|||For all those finding themselves in this predicament, we found a solution for this problem with regards to the Norton Internet Security/Firewall issue.

As with other posters, we had a problem running SQL Server Merge Replication between the SQL Server CE clients and the SQL Server 2005 servers when the firewall was enabled. Disabled, it would run fine. The solution we came up with was to place the IP address or the entire subnet in some cases for the SQL Server 2005 servers into the Trusted Zones of the client firewall(s). This was accomplished here via Group Policy, but could be done on a case by case basis jus the same.

Hopefully this remedies someone elses heartache down the road. It was certainly frustrating for me.

Good luck!

-Patrick

Merge Replication on SQL Server Compact Edition + SQL Server 2005 SP2

I followed the tutorial found on http://msdn2.microsoft.com/en-US/library/ms171908.aspx.

I have SQL Server 2005 with SP2 installed (NOT an Express version), SQL Server Compact Edition SDK, Server Tools and all other downloads I could find for CE. I'm running it on Windows XP Pro box, with SP2 and IIS 5.1.

Entering http://localhost/SQLMobile/sqlcesa30.dll?diag results in a page titled SQL Server Compact Edition Server Agent Diagnostics,

SQL Server Compact Edition Modules Test Module Status ErrorCode Version SQLCERP30.DLL SUCCESS 0x0 3.0.5300.0 SQLCESA30.DLL SUCCESS 0x0 3.0.5300.0

Reconciler Test Reconciler Status ErrorCode 9.0 Database Reconciler SUCCESS 0x0 8.0 Database Reconciler FAILURE 0x80004005


SQL Server Module Versions Module Version sqloledb.dll 2000.85.1117.0 9.0 replrec.dll 2005.90.3033.0 9.0 replprov.dll 2005.90.3033.0 9.0 msgprox.dll 2005.90.3033.0

I managed to solve all problems except one, occuring at the ending of the tutorial: Create a new subscription. When I'm trying to subscribe on created CE database I get the following error (at the second step of creating subscription):

Internal error: HTTP header information is either corrupted or missing in the transport message. It could be a network transmission error or an IIS problem.
HRESULT 0x80072F76 (28035)

I tried to google for it but only one result, with no solution.

Anybody has an idea what's wrong? I can provide further configuration details as necessary.

Thanks in advance

Cachotterie

I'm getting the same problem. Am running off a loopback adapter. Did you ever manage tot resolve this issue?|||In my case it was just Norton Internet Security firewall somehow modifying HTTP headers. I didn't find a way to make it work - just uninstalled it and now it is fine.|||

Have you solved this problem? I’m facing the same issue.

Thanks!

Eva

|||

I have this issue too ... and when I disable 'all of' Norton Security then the issue disappears.

For me it occurs in doing the tutorial: "Remote Data Access Synchronization with SQL Server 2005 Compact Edition and Visual C#.NET" at http://msdn2.microsoft.com/en-us/library/bb259792.aspx

With Norton Security active, whenever the tutorial code executes rda.Pull(...), I get the error message:

"Internal error: HTTP header information is either corrupted or missing in the transport message. ..."

The trouble is I can't work out what I need to adjust in Norton Security so that I can leave security active.

Any help will be greately appreciated. Cheers, Henk.

|||For all those finding themselves in this predicament, we found a solution for this problem with regards to the Norton Internet Security/Firewall issue.

As with other posters, we had a problem running SQL Server Merge Replication between the SQL Server CE clients and the SQL Server 2005 servers when the firewall was enabled. Disabled, it would run fine. The solution we came up with was to place the IP address or the entire subnet in some cases for the SQL Server 2005 servers into the Trusted Zones of the client firewall(s). This was accomplished here via Group Policy, but could be done on a case by case basis jus the same.

Hopefully this remedies someone elses heartache down the road. It was certainly frustrating for me.

Good luck!

-Patrick

Merge Replication on SQL Server Compact Edition + SQL Server 2005 SP2

I followed the tutorial found on http://msdn2.microsoft.com/en-US/library/ms171908.aspx.

I have SQL Server 2005 with SP2 installed (NOT an Express version), SQL Server Compact Edition SDK, Server Tools and all other downloads I could find for CE. I'm running it on Windows XP Pro box, with SP2 and IIS 5.1.

Entering http://localhost/SQLMobile/sqlcesa30.dll?diag results in a page titled SQL Server Compact Edition Server Agent Diagnostics,

SQL Server Compact Edition Modules Test Module Status ErrorCode Version SQLCERP30.DLL SUCCESS 0x0 3.0.5300.0 SQLCESA30.DLL SUCCESS 0x0 3.0.5300.0

Reconciler Test Reconciler Status ErrorCode 9.0 Database Reconciler SUCCESS 0x0 8.0 Database Reconciler FAILURE 0x80004005


SQL Server Module Versions Module Version sqloledb.dll 2000.85.1117.0 9.0 replrec.dll 2005.90.3033.0 9.0 replprov.dll 2005.90.3033.0 9.0 msgprox.dll 2005.90.3033.0

I managed to solve all problems except one, occuring at the ending of the tutorial: Create a new subscription. When I'm trying to subscribe on created CE database I get the following error (at the second step of creating subscription):

Internal error: HTTP header information is either corrupted or missing in the transport message. It could be a network transmission error or an IIS problem.
HRESULT 0x80072F76 (28035)

I tried to google for it but only one result, with no solution.

Anybody has an idea what's wrong? I can provide further configuration details as necessary.

Thanks in advance

Cachotterie

I'm getting the same problem. Am running off a loopback adapter. Did you ever manage tot resolve this issue?|||In my case it was just Norton Internet Security firewall somehow modifying HTTP headers. I didn't find a way to make it work - just uninstalled it and now it is fine.|||

Have you solved this problem? I’m facing the same issue.

Thanks!

Eva

|||

I have this issue too ... and when I disable 'all of' Norton Security then the issue disappears.

For me it occurs in doing the tutorial: "Remote Data Access Synchronization with SQL Server 2005 Compact Edition and Visual C#.NET" at http://msdn2.microsoft.com/en-us/library/bb259792.aspx

With Norton Security active, whenever the tutorial code executes rda.Pull(...), I get the error message:

"Internal error: HTTP header information is either corrupted or missing in the transport message. ..."

The trouble is I can't work out what I need to adjust in Norton Security so that I can leave security active.

Any help will be greately appreciated. Cheers, Henk.

|||For all those finding themselves in this predicament, we found a solution for this problem with regards to the Norton Internet Security/Firewall issue.

As with other posters, we had a problem running SQL Server Merge Replication between the SQL Server CE clients and the SQL Server 2005 servers when the firewall was enabled. Disabled, it would run fine. The solution we came up with was to place the IP address or the entire subnet in some cases for the SQL Server 2005 servers into the Trusted Zones of the client firewall(s). This was accomplished here via Group Policy, but could be done on a case by case basis jus the same.

Hopefully this remedies someone elses heartache down the road. It was certainly frustrating for me.

Good luck!

-Patrick

Friday, March 9, 2012

Merge replication error on the subscriber - call sys.sp_MSmakegeneration timing out

We are running on SQL Server 2005 SP2. Merge replication is on for one publisher and one subscriber.

Merge replication is throwing following error

"The process is waiting for a response from the query '{call sys.sp_MSmakegeneration (?)}"

It is hung on there for atleast couple hour or so. I decrease uploadbatches and downloadbatches settings as recommended but no positive results.

Let us know if any insight on the above issue.

Thanks

Is it actually hung on as in waiting for a response or is this what you are seeing in Replication Monitor. Keep in mind that if you are seeing this in Replication Monitor, the title of that dialog is the LAST error message that was received. It could very well have finished many synch cycles successfully and everything is moving through, however, the last time it had an error raised, it was this particular error. If it is in fact still waiting, then you need to check the publisher and subscriber and make sure that you don't have any blocking.|||I have ran sp_lock as don't see any blocking through sp_who , out put of the sp_lock shows that it is holding key locks on tables such as MSmerge_genhistory and MSmerge_contents.|||

Now I am running the sys stored procedure

exec sp_MSmakegeneration

from SQL Management Studio to see if it gives out any different output.

|||sp_MSmakegeneration will not return any information unless it errors out. If you want to see exactly what's going on, your best bet is to run profiler to trace it.|||

That would mean that it isn't hung and that data is moving through the system. If you look at the VERY bottom of the Replication Monitor window, in the status bar at the bottom, do you see a message that says something like "Waiting 60 seconds to poll for changes" or something else indicating that it is either uploading, download, connecting, or checking for stuff?

The part of the Replication Monitor that you are looking at just shows the last error message encountered. That error message could have occured 10 days ago and everything since then is running correctly without any errors.

|||What is the status of this thread? Were you able to resolve the issue? We are currently experiencing the same problem and could use some help, thanks!

Merge replication error on the subscriber - call sys.sp_MSmakegeneration timing out

We are running on SQL Server 2005 SP2. Merge replication is on for one publisher and one subscriber.

Merge replication is throwing following error

"The process is waiting for a response from the query '{call sys.sp_MSmakegeneration (?)}"

It is hung on there for atleast couple hour or so. I decrease uploadbatches and downloadbatches settings as recommended but no positive results.

Let us know if any insight on the above issue.

Thanks

Is it actually hung on as in waiting for a response or is this what you are seeing in Replication Monitor. Keep in mind that if you are seeing this in Replication Monitor, the title of that dialog is the LAST error message that was received. It could very well have finished many synch cycles successfully and everything is moving through, however, the last time it had an error raised, it was this particular error. If it is in fact still waiting, then you need to check the publisher and subscriber and make sure that you don't have any blocking.|||I have ran sp_lock as don't see any blocking through sp_who , out put of the sp_lock shows that it is holding key locks on tables such as MSmerge_genhistory and MSmerge_contents.|||

Now I am running the sys stored procedure

exec sp_MSmakegeneration

from SQL Management Studio to see if it gives out any different output.

|||sp_MSmakegeneration will not return any information unless it errors out. If you want to see exactly what's going on, your best bet is to run profiler to trace it.|||

That would mean that it isn't hung and that data is moving through the system. If you look at the VERY bottom of the Replication Monitor window, in the status bar at the bottom, do you see a message that says something like "Waiting 60 seconds to poll for changes" or something else indicating that it is either uploading, download, connecting, or checking for stuff?

The part of the Replication Monitor that you are looking at just shows the last error message encountered. That error message could have occured 10 days ago and everything since then is running correctly without any errors.

|||What is the status of this thread? Were you able to resolve the issue? We are currently experiencing the same problem and could use some help, thanks!

Monday, February 20, 2012

Merge replication and long disconnections

We have a system that uses SQL2000 (SP2) with the main database in our main
location. We have been working on setting up replication to a secondary
location, and believe we have solved the relevant issues there. We have
just been asked (read told) to set up replication to another server that
will, by it's nature, be disconnected for extended periods of time (at least
weeks) with no possibility of getting an internet connection during that
time. Can we setup merge replication in this situation, what are the
"gotchas" that we need to design around? We must use merge replication
since some of our fields are text fields.
We are initially looking at setting up the client to be disconnected as a
pull subscription, while the secondary client is a push subscription from
the publisher at the main location. Does this make sense?
All input appreciated.
TIA
Ron L.
Ron,
the most striking thing to get right is @.retention. By default it'll be 14
days which isn't long enough in your case.
Push or Pull is your choice depending on who you want to be in control. If
you know when the remote client will be connected on a regular basis, then
push is still an option, but in your scenario I agree that pull seems more
reasonable.
Regards,
Paul Ibison
|||Paul
Thanks for the pointer. I'll take a look for @.retention.
Ron L.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:ecYZkfaFEHA.712@.tk2msftngp13.phx.gbl...
> Ron,
> the most striking thing to get right is @.retention. By default it'll be 14
> days which isn't long enough in your case.
> Push or Pull is your choice depending on who you want to be in control. If
> you know when the remote client will be connected on a regular basis, then
> push is still an option, but in your scenario I agree that pull seems more
> reasonable.
> Regards,
> Paul Ibison
>