Help with a(n) MSSQL error

Log SQL Server (Current - 2/5/2007 2:00:00 AM)

Source spid90

Message
Replication-Replication Merge Subsystem: agent 0042007B-0032-0042-3700-390038004400 failed. The reconciler process was stopped because the Subscriber that initiated the synchronization is no longer connected. If this failure continues, restart the Merge Agent with higher value for -InternetTimeout.

Any help would be appreciated!

This is a replication error, as I'm sure you can tell from the message. It sounds like the partner in replication couldn't be reached, so that's where you should start.

There are a few places you can check on this error, starting with Books Online and "Troubleshooting Replication".

Also, edit the merge agent job step and add these parameters:

-OutputVerboseLevel 2 -Output EnterYourFileName

Then run the merge agent job again and look the error details in the output file. You'll find more detail there.

Help with a large delete

I have a table that is part a merge publication that I need to delete 3
million rows from which will leave about a million in the table. I plan to
just insert a list of the id's to go in a temporary table and then just do
delete where id in table X.
Another way that has been suggested to me is to place a copy of the records
that I want to keep into another table and then truncate the main table and
then put the ones I want back in. Would this method work due to the table
being part of a merge publication, as I presume that the truncate would not
happen on the server that is subscribed to this publication.
I'd do the truncate and reinsert as your transaction log will likely grow
absolutely huge the other way. Not to say it won't grow huge the first way.
keep in mind that in order to do the truncate you will need to drop the
subscriptions and publications.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Russell" <Russell@.discussions.microsoft.com> wrote in message
news:F3DE3D1A-A230-4E87-B23D-79CA1B2F8460@.microsoft.com...
> I have a table that is part a merge publication that I need to delete 3
> million rows from which will leave about a million in the table. I plan to
> just insert a list of the id's to go in a temporary table and then just do
> delete where id in table X.
> Another way that has been suggested to me is to place a copy of the
records
> that I want to keep into another table and then truncate the main table
and
> then put the ones I want back in. Would this method work due to the table
> being part of a merge publication, as I presume that the truncate would
not
> happen on the server that is subscribed to this publication.
|||Will it only grow huge on the server that I do the delete on or will it grow
huge on both servers?
"Hilary Cotter" wrote:

> I'd do the truncate and reinsert as your transaction log will likely grow
> absolutely huge the other way. Not to say it won't grow huge the first way.
> keep in mind that in order to do the truncate you will need to drop the
> subscriptions and publications.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Russell" <Russell@.discussions.microsoft.com> wrote in message
> news:F3DE3D1A-A230-4E87-B23D-79CA1B2F8460@.microsoft.com...
> records
> and
> not
>
>

Help w/SQL Mobile to SQL Compact Edition

Hello

We currently use SQL Mobile and SQL Server 2005. We depend heavily on merge replication for data to the field handheld devices.

We are going to be starting some new projects and I was wondering about moving to SQL Compact Edition as the first step to migrating all of our applications.

I am concerned, however, about the server side and replication. If we simply deploy SQL Compact Edition will there need to be any changes to the server for replication?

Thanks,

- will

Yes, that should be the case. SQL CE is basiclay just a newer version of SQL Mobile.

|||

Are you saying that there isn't anything on the server that I need to do...or that I will need to install and test the newer versions of the server tools?

|||The server tools have been update slightly, so you should use these. Download from: http://www.microsoft.com/downloads/details.aspx?FamilyID=4e45f676-e69a-4f7f-a016-c1585acf4310&displaylang=en

Help w/SQL Mobile to SQL Compact Edition

Hello

We currently use SQL Mobile and SQL Server 2005. We depend heavily on merge replication for data to the field handheld devices.

We are going to be starting some new projects and I was wondering about moving to SQL Compact Edition as the first step to migrating all of our applications.

I am concerned, however, about the server side and replication. If we simply deploy SQL Compact Edition will there need to be any changes to the server for replication?

Thanks,

- will

Yes, that should be the case. SQL CE is basiclay just a newer version of SQL Mobile.

|||

Are you saying that there isn't anything on the server that I need to do...or that I will need to install and test the newer versions of the server tools?

|||The server tools have been update slightly, so you should use these. Download from: http://www.microsoft.com/downloads/details.aspx?FamilyID=4e45f676-e69a-4f7f-a016-c1585acf4310&displaylang=en

Help setting up replication on remote IIS

Hello,

I am trying to setup merge replication for a sqlmobile database. I was able to set it up on a test environment which the sql instance and the iis were on the same box. I am trying now to go live. Our sql instance is on another box than the iis. I am now getting a 404 error when trying to test in the url https://www.domain.com/sqlmobile/sqlcesa30.dll?diag Is there a walk through for iis running on a different box, or does someone know of a solution?

HTTP Error 404 - File or directory not found.
Internet Information Services (IIS)

Hi John
questions:
-what do you understand under a "box"?
-can you open the https://www.domain.com/sqlmobile/sqlcesa30.dll?diag site on the server where you are running the IIS? with the ipAdress of the server instead of the www.domain.com
-if so, can you access it from another computer in the network?
you can't synchronize until you can find this dialog from your mobile browser.
-have you updatet the Client Agent (sqlcesa30.dll) with the WebSynchronisation Wizard accordning to the new configuration?

- as you probably know, you are connecting with the anonymous user IUSR_servername of the SQL Server from the mobile device to the webserver, so on the IIS-Server you have to know this user an give him the needed accessrights

It seems to me that there is a problem with the configuration or the access rights

Greets Florian
|||

there are only two big "gotchas" with setting up replication with a separate IIS and SQL Server machine.

1. the account you plan to use that will provide credentials between the ISAPI dll (sqcesa30.dll) and the distributor must be known to both machines. If you were using the IIS Anonymous user's credentials (IUSR_{your machine name}), this will no longer work, because the distributor has no knowledge of this account when running on a separate machine. if both machines are on a domain, instead of IUSR_, use a domain account that it known to both IIS and SQL Server machines and grant it permissions on the IIS Virtual Directory, the publication, and the published articles themselves.

2. you must install the SQL Mobile server tools on both the IIS and SQL Server machine. use the SQL Server 2005 setup disc on the IIS machine, do a custom install, and select only the server tools for SQL Mobile.

Darren

Help Req: how to upgrade from MSDE to Standard Edition

I have Merge Publication with SQL Standard Edition publisher
and MSDE subscribers. Due to database size (1,8 GB) I'm preparing
to upgrade SQL Server subscribers from MSDE SP3a to Standard Edition.
Can I do this without breaking the subscription (i.e. simple upgrade),
or I have to unsubscribe , upgrade to SQL Standard Edition SP3a
and re-subscribe to publication.
What is the best practice ?
Any advice or link is appreciated.
Pagus
..
The best approach would be to backup the databases, upgrade, restore them,
and then do no sync (the subscriber already has the schema and data)
subscriptions.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Pagus" <pagus@.writeme.com> wrote in message
news:85dfm05hhog0h9h42v54vu2c81f95nn5pq@.4ax.com...
> I have Merge Publication with SQL Standard Edition publisher
> and MSDE subscribers. Due to database size (1,8 GB) I'm preparing
> to upgrade SQL Server subscribers from MSDE SP3a to Standard Edition.
> Can I do this without breaking the subscription (i.e. simple upgrade),
> or I have to unsubscribe , upgrade to SQL Standard Edition SP3a
> and re-subscribe to publication.
> What is the best practice ?
> Any advice or link is appreciated.
> Pagus
> .
|||I did it and it works fine.
Thank you Hilary !
On Sat, 9 Oct 2004 22:33:42 -0400, "Hilary Cotter"
<hilary.cotter@.gmail.com> wrote:

>The best approach would be to backup the databases, upgrade, restore them,
>and then do no sync (the subscriber already has the schema and data)
>subscriptions.