ABNORMAL Transactional Replication behaviour

Actually i have set up a transactional replication with one publisher
and 1 subscriber (planning, then, to add other 6 subscribers later on).
The point is that after setting everything up, the replication works
really fine for some minutes and then just stops without any warning or
error!! The system is composed by this replication and some others
applications that writes on some tables on the subscriber. This app
starts writting data... everything works fine and then, BANG!, without
any reason data is not sent to the publisher anymore! SQL server doesn't
seems to notice that!
The replication has itself some filters and some tables have numeric
counters with identity YES (also the one that is written by the
application i mentioned before) . But, when i set up the publication i
assign a range to this counters and the replication blocks itself before
reaching the 1 % of the range i assing to this field!!
Anyone has an idea of what is happening?
Please... somebody help me!!
F.P.
what does sp_browsereplcmds reveal? Run this in the distribution database to
see if commands are pooling there.
If they aren't run sp_repltrans in your publication database.
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
"newsgroup" <fabio.pliger@.siavr.it> wrote in message
news:nVn4f.10530$65.287427@.twister1.libero.it...
> Actually i have set up a transactional replication with one publisher and
> 1 subscriber (planning, then, to add other 6 subscribers later on). The
> point is that after setting everything up, the replication works really
> fine for some minutes and then just stops without any warning or error!!
> The system is composed by this replication and some others applications
> that writes on some tables on the subscriber. This app starts writting
> data... everything works fine and then, BANG!, without any reason data is
> not sent to the publisher anymore! SQL server doesn't seems to notice
> that!
> The replication has itself some filters and some tables have numeric
> counters with identity YES (also the one that is written by the
> application i mentioned before) . But, when i set up the publication i
> assign a range to this counters and the replication blocks itself before
> reaching the 1 % of the range i assing to this field!!
> Anyone has an idea of what is happening?
> Please... somebody help me!!
> F.P.
|||Thanks Hilary for the advice, but sp_browsereplcmds reveals only that
the last command was the one for the last record send from the
subscriber to the published database(no cmds for the records in the
subscriber and not replicated to the publisher). Then i tried to run
sp_repltrans on my publication db but it returns me no results... All
the agents continue "working" without any error, but no more records are
replicated (neither from pubisher to subscriber or vice-versa). Wherelse
can i search for the transactions failed? I mean...
Any other idea? The main thing that upsets me is that i'm not able to
see what's going wrong!! I'll try changing some configurations... I'm
using a push subscription... is it better to use a pull one?
I really need some help...
thanks...
Hilary Cotter ha scritto:
> what does ? Run this in the distribution database to
> see if commands are pooling there.
> If they aren't run sp_repltrans in your publication database.
>

A Question on SQL Cluster -Urgent

We are planning the following setup as part of our Business Continuity
Planning.
We have an active passive cluster in the production and we will also have
the same setup in the DR setup. But the issue is that we need to keep the
same SQL virtual name in both Production and DR. So in this scenario if we
have to do some maintenance on the DR setup for eg: to apply Service Packs
or any fine tuning, how do we do that? Is there any recommendation or best
practices?
Waiting on an immediate response.
Abhi
Consider using a DNS alias. The apps use the alias, while the virtual
servers can be whatever you want.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Abhi" <Abhi@.discussions.microsoft.com> wrote in message
news:F4A782D4-8BD3-4B46-ABFA-B6BECE82908D@.microsoft.com...
We are planning the following setup as part of our Business Continuity
Planning.
We have an active passive cluster in the production and we will also have
the same setup in the DR setup. But the issue is that we need to keep the
same SQL virtual name in both Production and DR. So in this scenario if we
have to do some maintenance on the DR setup for eg: to apply Service Packs
or any fine tuning, how do we do that? Is there any recommendation or best
practices?
Waiting on an immediate response.
Abhi
|||"Abhi" <Abhi@.discussions.microsoft.com> wrote in message
news:F4A782D4-8BD3-4B46-ABFA-B6BECE82908D@.microsoft.com...
> We are planning the following setup as part of our Business Continuity
> Planning.
> We have an active passive cluster in the production and we will also have
> the same setup in the DR setup. But the issue is that we need to keep the
> same SQL virtual name in both Production and DR. So in this scenario if we
> have to do some maintenance on the DR setup for eg: to apply Service
> Packs
> or any fine tuning, how do we do that? Is there any recommendation or best
> practices?
You might also consider using database mirroring.
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp
The next ClusterHelp classes are:
July 10-13 in Denver
July 16-19 in New York
Sep 3 - 6 in Copenhagen

a million dollar question.

As I posted before. The company I'm working for is planning to develop a new
system for our POS around the country. We want to find the best replication
model between SQL Servers.
The situation turns difficult for us since we won't have static IP's on each
POS but dynamically IP's assigned by Cable, DSL or any other ISP available.
So we may not be able to establish VPN's.
I know most of you may have plenty experience on this subject.
Actually we're doing this with Web Services and data encryption but we want
to take the best alternative.
With SQL Server CE this is easier because of replication through IIS. Is
there a similar way between SQL Servers so I can protect information with a
Certificate or something?
As you can see, I'm a newbie in this but I want to learn about it. If there's
a good course/seminar you can recommend me to take, I would really appreciate
it. If the best way to learn is trying and a good book (Paul recommended me
Hillary's one), I can take that too.
Thank you very much.
Omar Rojas.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...ation/200510/1
Having dynamic ip address doesn't prevent you to use VPN. You can have the
POS computer VPN to your network. If you set the VPN to register in the DNS
you can get to the POS my computer name.
Also, you could (and I don't think is a good idea) hardcode the IP Address
on the user (so each time they connect in the VPN server they get the same
address).
Jos.
"Omar via droptable.com" <u14595@.uwe> wrote in message
news:557d1862fce85@.uwe...
> As I posted before. The company I'm working for is planning to develop a
> new
> system for our POS around the country. We want to find the best
> replication
> model between SQL Servers.
> The situation turns difficult for us since we won't have static IP's on
> each
> POS but dynamically IP's assigned by Cable, DSL or any other ISP
> available.
> So we may not be able to establish VPN's.
> I know most of you may have plenty experience on this subject.
> Actually we're doing this with Web Services and data encryption but we
> want
> to take the best alternative.
> With SQL Server CE this is easier because of replication through IIS. Is
> there a similar way between SQL Servers so I can protect information with
> a
> Certificate or something?
> As you can see, I'm a newbie in this but I want to learn about it. If
> there's
> a good course/seminar you can recommend me to take, I would really
> appreciate
> it. If the best way to learn is trying and a good book (Paul recommended
> me
> Hillary's one), I can take that too.
> Thank you very much.
> Omar Rojas.
>
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...ation/200510/1
|||You can use web replication with SQL Server in much the same
way that you have used it with SQL CE. The differences are:
1. you must use SSL for SQL Server web replication (with
SQL CE you have the option not to)
2. the code you need to write if you are thinking of using
SQL Express as the subscribers is difficult and not well
documented. I'm referring here to implementing replication
using RMO programming. I've just been through this on a
large project and it was not fun.
Other than that, it's the same concept - an ISAPI DLL sits in
a virtual directory on IIS and brokers the replication to web-
connected subscribers.
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com
"Omar via droptable.com" <u14595@.uwe> wrote in message
news:557d1862fce85@.uwe...
> As I posted before. The company I'm working for is planning to develop a
> new
> system for our POS around the country. We want to find the best
> replication
> model between SQL Servers.
> The situation turns difficult for us since we won't have static IP's on
> each
> POS but dynamically IP's assigned by Cable, DSL or any other ISP
> available.
> So we may not be able to establish VPN's.
> I know most of you may have plenty experience on this subject.
> Actually we're doing this with Web Services and data encryption but we
> want
> to take the best alternative.
> With SQL Server CE this is easier because of replication through IIS. Is
> there a similar way between SQL Servers so I can protect information with
> a
> Certificate or something?
> As you can see, I'm a newbie in this but I want to learn about it. If
> there's
> a good course/seminar you can recommend me to take, I would really
> appreciate
> it. If the best way to learn is trying and a good book (Paul recommended
> me
> Hillary's one), I can take that too.
> Thank you very much.
> Omar Rojas.
>
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...ation/200510/1
|||replication over the web is relatively easy but somewhat involved.
Points to keep in mind.
1) your path to the snapshot subdirectory should be /ftp or /FTPVD/ftp,
where FTPVD is the name of your FTP Virtual Directory
2) your ftp server should be entered as a fully qualified domain name. This
is the option in the Snapshot location tab called FTP Server Name\
3) use anonymous authentication. If you are using not using anonymous
authentication make sure you created a local machine account with the same
name and this account has list and read access to the files and folders
underlying the ftp virtual directory.
4) Your subscribers need to find a path to your publisher across the
internet. You should register your publisher using its netbios name what you
see by issuing a master.dbo.xp_cmdshell 'echo %computername%. Use this name
as your Server alias when configuring the publisher name in Client Network
Utility on your Subscribers. Make sure the Server alias is the Server name
(i.e. Publisher), the ServerName is the Fully Qualified Domain Name to your
Publisher, i.e. Publisher.MSDN.Microsoft.com. Make sure you use the tcp/ip
network library.
Finally you will find it easy to use the replication activeX controls to
deploy subscribers, use PublisherAddress and DistributorAddress for the FQDN
for your Publisher/Distributor.
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
"Omar via droptable.com" <u14595@.uwe> wrote in message
news:557d1862fce85@.uwe...
> As I posted before. The company I'm working for is planning to develop a
> new
> system for our POS around the country. We want to find the best
> replication
> model between SQL Servers.
> The situation turns difficult for us since we won't have static IP's on
> each
> POS but dynamically IP's assigned by Cable, DSL or any other ISP
> available.
> So we may not be able to establish VPN's.
> I know most of you may have plenty experience on this subject.
> Actually we're doing this with Web Services and data encryption but we
> want
> to take the best alternative.
> With SQL Server CE this is easier because of replication through IIS. Is
> there a similar way between SQL Servers so I can protect information with
> a
> Certificate or something?
> As you can see, I'm a newbie in this but I want to learn about it. If
> there's
> a good course/seminar you can recommend me to take, I would really
> appreciate
> it. If the best way to learn is trying and a good book (Paul recommended
> me
> Hillary's one), I can take that too.
> Thank you very much.
> Omar Rojas.
>
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...ation/200510/1