I have an application that has been using a right outer join that worked as I
expected until I added merge replication. On the replicated database the
result is the same as an inner join. I could be doing something odd but it's
a pretty plain use and it still works on instances of the database without
replication. I thought I'd first ask if this is a known issue before creating
small standalone files for posting.
Thanks
Kohn,
I see no reason how this could possibly be an issue. Please can you post up
your files and I'll try to repro.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Showing posts with label replication. Show all posts
Showing posts with label replication. Show all posts
Wednesday, March 28, 2012
Friday, March 23, 2012
Out of sync
Hi,
We are using SQl 2000 EE with sp3a and doing transactional replication of
300+gb db.
frequently the subscribers are out of sync .
In order to spped up the replication process we have modfied the polling
interval to '1' and commit batch size to '1000' of distribution db ,Log
reader agent polling interval to 1 and Readbatchsize to 1000.
some times the subscriptions are in sync and sometimes not.
Why the log reader agent is not able to commit more than 100 transactions to
distribution db.Please suggest some thing in order to speed up the
replication process
I have executed sp_replcommands on OLtp it has nearly 75000 transactions to
commit.
Thanks
Murali
How big is your transaction log?
When you start to get big (and I don't mean your waist size) transactional
log maintenance is a must. You should be dumping your log as frequently as
each minute. You must also try to size your transaction log as well.
To do this observer the size of your tlog. Back it up, and shrink it. Then
size it to a best guess of what it should be.
Run dbcc loginfo to get an idea of your virtual log files. After a shrink
you should have 4. You want to run with perhaps 16-64, definitely not
several hundred or thousand. This will be an iterative process, but you
might start at 10 Mg, and work up/down from there.
The reason you want to maintain your transaction log is you want to minimize
the size of the log your log reader agent has to read. Also I would bump up
the read batch size threshold to 200 or more. If you run into problems with
your log reader being unable to chew through the log (the could not execute
sp_replcmds message) you will want to drop the ReadBatchSize and the
ReadBatchSizeThreshold values, but other than that you will want to increase
it.
Also set the HistoryVerboseLevel setting to 0.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Murali" <Murali@.discussions.microsoft.com> wrote in message
news:2D4B32EA-2860-4182-B914-FADECC2C9224@.microsoft.com...
> Hi,
> We are using SQl 2000 EE with sp3a and doing transactional replication of
> 300+gb db.
> frequently the subscribers are out of sync .
> In order to spped up the replication process we have modfied the polling
> interval to '1' and commit batch size to '1000' of distribution db ,Log
> reader agent polling interval to 1 and Readbatchsize to 1000.
> some times the subscriptions are in sync and sometimes not.
> Why the log reader agent is not able to commit more than 100 transactions
to
> distribution db.Please suggest some thing in order to speed up the
> replication process
> I have executed sp_replcommands on OLtp it has nearly 75000 transactions
to
> commit.
> Thanks
> Murali
>
|||oops, make sure HistoryVerboseLevel is 1 for the Log Reader Agent and 0 for
the Distribution Agent.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Murali" <Murali@.discussions.microsoft.com> wrote in message
news:2D4B32EA-2860-4182-B914-FADECC2C9224@.microsoft.com...
> Hi,
> We are using SQl 2000 EE with sp3a and doing transactional replication of
> 300+gb db.
> frequently the subscribers are out of sync .
> In order to spped up the replication process we have modfied the polling
> interval to '1' and commit batch size to '1000' of distribution db ,Log
> reader agent polling interval to 1 and Readbatchsize to 1000.
> some times the subscriptions are in sync and sometimes not.
> Why the log reader agent is not able to commit more than 100 transactions
to
> distribution db.Please suggest some thing in order to speed up the
> replication process
> I have executed sp_replcommands on OLtp it has nearly 75000 transactions
to
> commit.
> Thanks
> Murali
>
We are using SQl 2000 EE with sp3a and doing transactional replication of
300+gb db.
frequently the subscribers are out of sync .
In order to spped up the replication process we have modfied the polling
interval to '1' and commit batch size to '1000' of distribution db ,Log
reader agent polling interval to 1 and Readbatchsize to 1000.
some times the subscriptions are in sync and sometimes not.
Why the log reader agent is not able to commit more than 100 transactions to
distribution db.Please suggest some thing in order to speed up the
replication process
I have executed sp_replcommands on OLtp it has nearly 75000 transactions to
commit.
Thanks
Murali
How big is your transaction log?
When you start to get big (and I don't mean your waist size) transactional
log maintenance is a must. You should be dumping your log as frequently as
each minute. You must also try to size your transaction log as well.
To do this observer the size of your tlog. Back it up, and shrink it. Then
size it to a best guess of what it should be.
Run dbcc loginfo to get an idea of your virtual log files. After a shrink
you should have 4. You want to run with perhaps 16-64, definitely not
several hundred or thousand. This will be an iterative process, but you
might start at 10 Mg, and work up/down from there.
The reason you want to maintain your transaction log is you want to minimize
the size of the log your log reader agent has to read. Also I would bump up
the read batch size threshold to 200 or more. If you run into problems with
your log reader being unable to chew through the log (the could not execute
sp_replcmds message) you will want to drop the ReadBatchSize and the
ReadBatchSizeThreshold values, but other than that you will want to increase
it.
Also set the HistoryVerboseLevel setting to 0.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Murali" <Murali@.discussions.microsoft.com> wrote in message
news:2D4B32EA-2860-4182-B914-FADECC2C9224@.microsoft.com...
> Hi,
> We are using SQl 2000 EE with sp3a and doing transactional replication of
> 300+gb db.
> frequently the subscribers are out of sync .
> In order to spped up the replication process we have modfied the polling
> interval to '1' and commit batch size to '1000' of distribution db ,Log
> reader agent polling interval to 1 and Readbatchsize to 1000.
> some times the subscriptions are in sync and sometimes not.
> Why the log reader agent is not able to commit more than 100 transactions
to
> distribution db.Please suggest some thing in order to speed up the
> replication process
> I have executed sp_replcommands on OLtp it has nearly 75000 transactions
to
> commit.
> Thanks
> Murali
>
|||oops, make sure HistoryVerboseLevel is 1 for the Log Reader Agent and 0 for
the Distribution Agent.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Murali" <Murali@.discussions.microsoft.com> wrote in message
news:2D4B32EA-2860-4182-B914-FADECC2C9224@.microsoft.com...
> Hi,
> We are using SQl 2000 EE with sp3a and doing transactional replication of
> 300+gb db.
> frequently the subscribers are out of sync .
> In order to spped up the replication process we have modfied the polling
> interval to '1' and commit batch size to '1000' of distribution db ,Log
> reader agent polling interval to 1 and Readbatchsize to 1000.
> some times the subscriptions are in sync and sometimes not.
> Why the log reader agent is not able to commit more than 100 transactions
to
> distribution db.Please suggest some thing in order to speed up the
> replication process
> I have executed sp_replcommands on OLtp it has nearly 75000 transactions
to
> commit.
> Thanks
> Murali
>
Out of Partition Deletions
Hi,
I have merge replication working between SQL Server 2005 and SQL Server 2005 Mobile Edition. The subscriber data partitions are determined by device serial number, which is being passed in as the HOST_NAME() parameter for filtering. Lately I've received complaints of slow synchronizations, and a quick inspection showed an unexpectedly high number of deletions.
Further investigation has revealed that subscribers are being passed deletions for data which is outside of their data partitions. I found that inserts and updates were well behaved - if a row was inserted or updated outside of the partition, nothing was replicated. However, if an out of partition deletion was performed, it was in fact replicated - to every subscriber.
So, why is it that replication knows the row doesn't belong to a data partition for inserts and updates, but not deletes? I've been unable to find either an explanation or workaround for this problem.
Any insight would be greatly appreciated!
Thanks,
Adrien.
If i had to give a rough guess i think what it is doing is realigning the partitions. Your deletes must be deleting records from the filtering hiherarchy which change a partition. So those are being sent everywhere to make sure the subscribers have the correct partition of data.
Take a look at parameter @.allow_partition_realignment
http://technet.microsoft.com/en-us/library/ms176103.aspx
Unfortunately if you are using dynamic filtering it will not allow you to turn this off.
Martin
|||That's an interesting setting, but it doesn't seem to apply. I'll explain things with an example:Users
user_id
warehouse_id
user_name
serial_number
Warehouses
warehouse_id
warehouse_name
Orders
order_id
warehouse_id
order_date
OrderDetail
detail_id
order_id
item_name
item_quantity
serial_number is being passed for HOST_NAME() dynamic filtering. A user should only see orders belonging to his assigned warehouse (and obviously only order details linked to orders belonging to that warehouse). For the purpose of this example, say we have two users, User1 and User2, and two warehouses, Warehouse1 and Warehouse2. Each warehouse has only one order, and each order has two order details.
The problem I'm having is that deleting (at the publisher) an order detail for an order belonging to Warehouse2 would cause a deletion not just for User2, but for User1 as well. I don't see how this is causing partition changes (unless moving from a partition to no partition counts as a partition change).
Hopefully this helps clarify my problem somewhat. This is still causing me no end of problems, and any advice would be greatly appreciated.
Thanks,
Adrien.
Out of Partition Deletions
Hi,
I have merge replication working between SQL Server 2005 and SQL Server 2005 Mobile Edition. The subscriber data partitions are determined by device serial number, which is being passed in as the HOST_NAME() parameter for filtering. Lately I've received complaints of slow synchronizations, and a quick inspection showed an unexpectedly high number of deletions.
Further investigation has revealed that subscribers are being passed deletions for data which is outside of their data partitions. I found that inserts and updates were well behaved - if a row was inserted or updated outside of the partition, nothing was replicated. However, if an out of partition deletion was performed, it was in fact replicated - to every subscriber.
So, why is it that replication knows the row doesn't belong to a data partition for inserts and updates, but not deletes? I've been unable to find either an explanation or workaround for this problem.
Any insight would be greatly appreciated!
Thanks,
Adrien.
If i had to give a rough guess i think what it is doing is realigning the partitions. Your deletes must be deleting records from the filtering hiherarchy which change a partition. So those are being sent everywhere to make sure the subscribers have the correct partition of data.
Take a look at parameter @.allow_partition_realignment
http://technet.microsoft.com/en-us/library/ms176103.aspx
Unfortunately if you are using dynamic filtering it will not allow you to turn this off.
Martin
|||That's an interesting setting, but it doesn't seem to apply. I'll explain things with an example:Users
user_id
warehouse_id
user_name
serial_number
Warehouses
warehouse_id
warehouse_name
Orders
order_id
warehouse_id
order_date
OrderDetail
detail_id
order_id
item_name
item_quantity
serial_number is being passed for HOST_NAME() dynamic filtering. A user should only see orders belonging to his assigned warehouse (and obviously only order details linked to orders belonging to that warehouse). For the purpose of this example, say we have two users, User1 and User2, and two warehouses, Warehouse1 and Warehouse2. Each warehouse has only one order, and each order has two order details.
The problem I'm having is that deleting (at the publisher) an order detail for an order belonging to Warehouse2 would cause a deletion not just for User2, but for User1 as well. I don't see how this is causing partition changes (unless moving from a partition to no partition counts as a partition change).
Hopefully this helps clarify my problem somewhat. This is still causing me no end of problems, and any advice would be greatly appreciated.
Thanks,
Adrien.
Out of Partition Deletions
Hi,
I have merge replication working between SQL Server 2005 and SQL Server 2005 Mobile Edition. The subscriber data partitions are determined by device serial number, which is being passed in as the HOST_NAME() parameter for filtering. Lately I've received complaints of slow synchronizations, and a quick inspection showed an unexpectedly high number of deletions.
Further investigation has revealed that subscribers are being passed deletions for data which is outside of their data partitions. I found that inserts and updates were well behaved - if a row was inserted or updated outside of the partition, nothing was replicated. However, if an out of partition deletion was performed, it was in fact replicated - to every subscriber.
So, why is it that replication knows the row doesn't belong to a data partition for inserts and updates, but not deletes? I've been unable to find either an explanation or workaround for this problem.
Any insight would be greatly appreciated!
Thanks,
Adrien.
If i had to give a rough guess i think what it is doing is realigning the partitions. Your deletes must be deleting records from the filtering hiherarchy which change a partition. So those are being sent everywhere to make sure the subscribers have the correct partition of data.
Take a look at parameter @.allow_partition_realignment
http://technet.microsoft.com/en-us/library/ms176103.aspx
Unfortunately if you are using dynamic filtering it will not allow you to turn this off.
Martin
|||That's an interesting setting, but it doesn't seem to apply. I'll explain things with an example:Users
user_id
warehouse_id
user_name
serial_number
Warehouses
warehouse_id
warehouse_name
Orders
order_id
warehouse_id
order_date
OrderDetail
detail_id
order_id
item_name
item_quantity
serial_number is being passed for HOST_NAME() dynamic filtering. A user should only see orders belonging to his assigned warehouse (and obviously only order details linked to orders belonging to that warehouse). For the purpose of this example, say we have two users, User1 and User2, and two warehouses, Warehouse1 and Warehouse2. Each warehouse has only one order, and each order has two order details.
The problem I'm having is that deleting (at the publisher) an order detail for an order belonging to Warehouse2 would cause a deletion not just for User2, but for User1 as well. I don't see how this is causing partition changes (unless moving from a partition to no partition counts as a partition change).
Hopefully this helps clarify my problem somewhat. This is still causing me no end of problems, and any advice would be greatly appreciated.
Thanks,
Adrien.
Tuesday, March 20, 2012
others tools can doing replication with sql 2000?
Hi all:
Just doing research on this topic, how many other tools can doing
replication with sql 2000?
What i mean is that i setup replication in my sql 2000 , then other
tools can download database throught by interent .
Thanks
Nick
I'm not exactly sure what you mean.
You can replicate to SQL Server or MSDE databases over the internet.
You can pull the scriptions using a t sql script, using the ActiveX
object, or using WSM - Windows Synchronization Manager.
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
Just doing research on this topic, how many other tools can doing
replication with sql 2000?
What i mean is that i setup replication in my sql 2000 , then other
tools can download database throught by interent .
Thanks
Nick
I'm not exactly sure what you mean.
You can replicate to SQL Server or MSDE databases over the internet.
You can pull the scriptions using a t sql script, using the ActiveX
object, or using WSM - Windows Synchronization Manager.
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
Other ways to replicate ?
We have an application that we need to replicate but the suppliers say that
their application does not support SQL replication. Can anyone recommend a
good third party replication tool ? Also if the application does not support
SQL replication would this mean that a 3rd party tool couldn`t be used as
well ?
Si
You could take a look at RedGate's Datacompare which won't modify the
schemas at all. As to whether it'll work, it depends on how your app is set
up as to whether it'll work - eg the tables must have PKs and the data must
be started from a consistent state.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||Press them to find out what they mean by it their application does support
replication. I find it hard to believe that an application can't use
snapshot replication. If it doesn't support transactional replication it is
very poorly designed as transactional replication requires pk's.
Consider log shipping or database mirroring.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"Simon" <Simon@.discussions.microsoft.com> wrote in message
news:FABCE84E-51AB-49A4-8E1D-3392FBB22E04@.microsoft.com...
> We have an application that we need to replicate but the suppliers say
> that
> their application does not support SQL replication. Can anyone recommend a
> good third party replication tool ? Also if the application does not
> support
> SQL replication would this mean that a 3rd party tool couldn`t be used as
> well ?
> Si
|||What in an application can stop SQL replication working ?
"Hilary Cotter" wrote:
> Press them to find out what they mean by it their application does support
> replication. I find it hard to believe that an application can't use
> snapshot replication. If it doesn't support transactional replication it is
> very poorly designed as transactional replication requires pk's.
> Consider log shipping or database mirroring.
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> 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
>
> "Simon" <Simon@.discussions.microsoft.com> wrote in message
> news:FABCE84E-51AB-49A4-8E1D-3392FBB22E04@.microsoft.com...
>
>
|||It's more likely to be the other way round. If you require updatable
subscribers, the schema will be altered to add a column, and if your app
uses select * from articlename queries, it might break. There could also be
issues with triggers and cascading referential integrity. Difficult to say
exactly what they think the problem might be.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||The main problem is that they just updated a fox database into SQL and then
expected the application to work with no problems. The amount of things they
try and do in the application that SQL does out of the box is ridiculous.
Plus they don`t do any processing on the SQL server, everything is done on
the local machine.
I love it when people with no techincal knowledge make decisions on software
for my company without any guidance !
"Paul Ibison" wrote:
> It's more likely to be the other way round. If you require updatable
> subscribers, the schema will be altered to add a column, and if your app
> uses select * from articlename queries, it might break. There could also be
> issues with triggers and cascading referential integrity. Difficult to say
> exactly what they think the problem might be.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
>
their application does not support SQL replication. Can anyone recommend a
good third party replication tool ? Also if the application does not support
SQL replication would this mean that a 3rd party tool couldn`t be used as
well ?
Si
You could take a look at RedGate's Datacompare which won't modify the
schemas at all. As to whether it'll work, it depends on how your app is set
up as to whether it'll work - eg the tables must have PKs and the data must
be started from a consistent state.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||Press them to find out what they mean by it their application does support
replication. I find it hard to believe that an application can't use
snapshot replication. If it doesn't support transactional replication it is
very poorly designed as transactional replication requires pk's.
Consider log shipping or database mirroring.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"Simon" <Simon@.discussions.microsoft.com> wrote in message
news:FABCE84E-51AB-49A4-8E1D-3392FBB22E04@.microsoft.com...
> We have an application that we need to replicate but the suppliers say
> that
> their application does not support SQL replication. Can anyone recommend a
> good third party replication tool ? Also if the application does not
> support
> SQL replication would this mean that a 3rd party tool couldn`t be used as
> well ?
> Si
|||What in an application can stop SQL replication working ?
"Hilary Cotter" wrote:
> Press them to find out what they mean by it their application does support
> replication. I find it hard to believe that an application can't use
> snapshot replication. If it doesn't support transactional replication it is
> very poorly designed as transactional replication requires pk's.
> Consider log shipping or database mirroring.
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> 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
>
> "Simon" <Simon@.discussions.microsoft.com> wrote in message
> news:FABCE84E-51AB-49A4-8E1D-3392FBB22E04@.microsoft.com...
>
>
|||It's more likely to be the other way round. If you require updatable
subscribers, the schema will be altered to add a column, and if your app
uses select * from articlename queries, it might break. There could also be
issues with triggers and cascading referential integrity. Difficult to say
exactly what they think the problem might be.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||The main problem is that they just updated a fox database into SQL and then
expected the application to work with no problems. The amount of things they
try and do in the application that SQL does out of the box is ridiculous.
Plus they don`t do any processing on the SQL server, everything is done on
the local machine.
I love it when people with no techincal knowledge make decisions on software
for my company without any guidance !
"Paul Ibison" wrote:
> It's more likely to be the other way round. If you require updatable
> subscribers, the schema will be altered to add a column, and if your app
> uses select * from articlename queries, it might break. There could also be
> issues with triggers and cascading referential integrity. Difficult to say
> exactly what they think the problem might be.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
>
Other Replication Providers
Can anyone tell me the names of some non-Microsoft Replication providers? I
have found a company called Peer Direct, but would like to see what other
alternatives exist for replication.
Thanks in advance
Ron L
What precisely are you trying to accomplish.
Sometimes people run to 3rd party products because of problems they have
with native SQL Server replication, when a support call to PSS could solve
the problem.
Last I heard the DataMirror licenses where $30k.
"Ron L" <ronl@.bogus.Address.com> wrote in message
news:#f2fIaptEHA.2596@.TK2MSFTNGP15.phx.gbl...
> Can anyone tell me the names of some non-Microsoft Replication providers?
I
> have found a company called Peer Direct, but would like to see what other
> alternatives exist for replication.
> Thanks in advance
> Ron L
>
|||Paul
Thanks for the suggestion, I will take a look at it.
Ron L
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:177d01c4b698$1d3eb6b0$a501280a@.phx.gbl...
> DataMirror is occasionally mentioned in this newsgroup
> (http://www.datamirror.com/products/tserver/) although I
> haven't implemented it myself.
> Rgds,
> Paul Ibison (SQL Server MVP)
>
|||Hilary
Thanks for the response. We have a database that is being replicated to
2 other sites currently and will probably add anywhere from 1 to 15 sites
over the next few years. As I mentioned before, some of the sites are
disconnected for extended periods of times. In setting up and maintaining
the merge replication we have in place, we have found a number of issues
with replication that concern us from the point of long-term data transfer.
One of these issues is the fact that MS seems to strongly suggest that a
snapshot be periodically created and pushed to existing subscribers.
Another is how the retention and re-initialization procedures work. We are
not always in a situation where we can have all of the subscribers connected
at the same time to re-initialize them.
Ron L
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:O%23UgeCstEHA.1452@.TK2MSFTNGP11.phx.gbl...
> What precisely are you trying to accomplish.
> Sometimes people run to 3rd party products because of problems they have
> with native SQL Server replication, when a support call to PSS could solve
> the problem.
> Last I heard the DataMirror licenses where $30k.
> "Ron L" <ronl@.bogus.Address.com> wrote in message
> news:#f2fIaptEHA.2596@.TK2MSFTNGP15.phx.gbl...
> I
>
have found a company called Peer Direct, but would like to see what other
alternatives exist for replication.
Thanks in advance
Ron L
What precisely are you trying to accomplish.
Sometimes people run to 3rd party products because of problems they have
with native SQL Server replication, when a support call to PSS could solve
the problem.
Last I heard the DataMirror licenses where $30k.
"Ron L" <ronl@.bogus.Address.com> wrote in message
news:#f2fIaptEHA.2596@.TK2MSFTNGP15.phx.gbl...
> Can anyone tell me the names of some non-Microsoft Replication providers?
I
> have found a company called Peer Direct, but would like to see what other
> alternatives exist for replication.
> Thanks in advance
> Ron L
>
|||Paul
Thanks for the suggestion, I will take a look at it.
Ron L
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:177d01c4b698$1d3eb6b0$a501280a@.phx.gbl...
> DataMirror is occasionally mentioned in this newsgroup
> (http://www.datamirror.com/products/tserver/) although I
> haven't implemented it myself.
> Rgds,
> Paul Ibison (SQL Server MVP)
>
|||Hilary
Thanks for the response. We have a database that is being replicated to
2 other sites currently and will probably add anywhere from 1 to 15 sites
over the next few years. As I mentioned before, some of the sites are
disconnected for extended periods of times. In setting up and maintaining
the merge replication we have in place, we have found a number of issues
with replication that concern us from the point of long-term data transfer.
One of these issues is the fact that MS seems to strongly suggest that a
snapshot be periodically created and pushed to existing subscribers.
Another is how the retention and re-initialization procedures work. We are
not always in a situation where we can have all of the subscribers connected
at the same time to re-initialize them.
Ron L
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:O%23UgeCstEHA.1452@.TK2MSFTNGP11.phx.gbl...
> What precisely are you trying to accomplish.
> Sometimes people run to 3rd party products because of problems they have
> with native SQL Server replication, when a support call to PSS could solve
> the problem.
> Last I heard the DataMirror licenses where $30k.
> "Ron L" <ronl@.bogus.Address.com> wrote in message
> news:#f2fIaptEHA.2596@.TK2MSFTNGP15.phx.gbl...
> I
>
Monday, March 12, 2012
OT: Proliant reboots during replication
Configuration: Proliant ML350 , Win2000 Server, SQL Server 2000
internal PCI ISDN adapter ASUS P-IN-100(W,D)
This server has number of merge replications (as publisher) and does
up to 15 replications every night. From time to time (once a week or
5-6 days, but always during replication) the machine reboots.
In Compaq Integrated Management Log Viewer we have ervery time :
-PCI Bus Error (Slot 0, Bus 0, Device 15, Function 0)
-ASR Detected by System ROM
-POST Error: A Critical Error occured prior to this power-up
and in System Log:
Event Type:Error
Event Source:cpqasm
Event Category:None
Event ID:4196
Date:25.3.2004
Time:23:05:20
User:N/A
Computer:xxxxxxxxx
Description:
The system encountered a Non-Maskable Interrupt (NMI) prior to this
boot. The NMI source was: PCI bus error, slot 0.
Computer Management reported that (Slot 0, Bus 0, Device 15, Function
0) is PCI Standard ISA Bridge.
During a day there is a lot of traffic using same ISDN adapter (lot of
FTP-s) without any problem. It seems that only replication is problem.
Although I know this is most probably ISDN Adapter/drivers problem
I'm trying in this group. Maybe somebody has some hint ?
Happy greetings,
Pagus
PS: Today we had same problem with same hardware configuration at
other location, this time Proliant + Win2003 SBS as publisher.
Same problem here... Proliant ML350 G3, reboots automatically at random times...
If we test our serial port (nothing connected) with the HP-tool CPQdiagnostics (SP27119.exe) the system crashes. When we connect a mouse to that particular serial port, we got a software-error of CPQdiagnostics.
All other hardwaretests look fine.
Here we attach some minidump-debuganalyses. Can you also test these things ? Maybe we have the same problem ?
Greetings
Dieter
Microsoft (R) Windows Debugger Version 6.2.0013.1
Copyright (c) Microsoft Corporation. All rights reserved.
Loading Dump File [C:\Program Files\Debugging Tools for Windows\Mini040704-01.dmp]
Mini Kernel Dump File: Only registers and stack trace are available
Symbol search path is: SRV*c:\websymbols*http://msdl.microsoft.com/download/symbols
Executable search path is:
Windows Server 2003 Kernel Version 3790 MP (4 procs) Free x86 compatible
Product: Server, suite: TerminalServer SingleUserTS
Built by: 3790.srv03_rtm.030324-2048
Kernel base = 0x804de000 PsLoadedModuleList = 0x8057b6a8
Debug session time: Wed Apr 07 08:32:16 2004
System Uptime: 0 days 0:02:32.265
Loading Kernel Symbols
...................................... ...................................... .........
Loading unloaded module list
...
Loading User Symbols
************************************************** *****************************
* *
* Bugcheck Analysis *
* *
************************************************** *****************************
Use !analyze -v to get detailed debugging information.
BugCheck 1000008E, {c0000005, 80527564, 8056c090, 0}
Probably caused by : ntkrnlmp.exe ( nt!KiDispatchException+19e )
Followup: MachineOwner
0: kd> !analyze -v
************************************************** *****************************
* *
* Bugcheck Analysis *
* *
************************************************** *****************************
KERNEL_MODE_EXCEPTION_NOT_HANDLED_M (1000008e)
This is a very common bugcheck. Usually the exception address pinpoints
the driver/function that caused the problem. Always note this address
as well as the link date of the driver/image that contains this address.
Some common problems are exception code 0x80000003. This means a hard
coded breakpoint or assertion was hit, but this system was booted
/NODEBUG. This is not supposed to happen as developers should never have
hardcoded breakpoints in retail code, but ...
If this happens, make sure a debugger gets connected, and the
system is booted /DEBUG. This will let us see why this breakpoint is
happening.
An exception code of 0x80000002 (STATUS_DATATYPE_MISALIGNMENT) indicates
that an unaligned data reference was encountered. The trap frame will
supply additional information.
Arguments:
Arg1: c0000005, The exception code that was not handled
Arg2: 80527564, The address that the exception occurred at
Arg3: 8056c090, Trap Frame
Arg4: 00000000
Debugging Details:
EXCEPTION_CODE: (NTSTATUS) 0xc0000005 - De instructie op 0x%08lx verwijst naar geheugen op 0x%08lx. De lees- of schrijfbewerking ("%s") op het geheugen is mislukt.
FAULTING_IP:
nt!KiDispatchException+19e
80527564 e92e65feff jmp nt!KiDispatchException+0x19e (8050da97)
TRAP_FRAME: 8056c090 -- (.trap ffffffff8056c090)
ESP EDITED! New esp=8056c3f0
ErrCode = 00000000
eax=8056c6cc ebx=8056c804 ecx=81987020 edx=00010000 esi=8056c7b0 edi=00000000
eip=80527564 esp=8056c104 ebp=8056c794 iopl=0 nv up ei ng nz na pe cy
cs=0000 ss=0010 ds=0023 es=0023 fs=0030 gs=0000 efl=00000283
nt!KiDispatchException+0x19e:
80527564 e92e65feff jmp nt!KiDispatchException+0x19e (8050da97)
Resetting default scope
DEFAULT_BUCKET_ID: DRIVER_FAULT_SERVER_MINIDUMP
BUGCHECK_STR: 0x8E
CURRENT_IRQL: 0
LAST_CONTROL_TRANSFER: from 804e087a to 80527564
STACK_TEXT:
8056c794 804e087a 8056c7b0 00000000 8056c804 nt!KiDispatchException+0x19e
8056c7fc 804e07fa 00000000 00000000 00000023 nt!CommonDispatchException+0x4a
8056c804 00000000 00000023 00000023 010cfee4 nt!KiExceptionExit+0x16a
FOLLOWUP_IP:
nt!KiDispatchException+19e
80527564 e92e65feff jmp nt!KiDispatchException+0x19e (8050da97)
FOLLOWUP_NAME: MachineOwner
SYMBOL_NAME: nt!KiDispatchException+19e
MODULE_NAME: nt
IMAGE_NAME: ntkrnlmp.exe
DEBUG_FLR_IMAGE_TIMESTAMP: 3e8015c6
STACK_COMMAND: .trap ffffffff8056c090 ; kb
BUCKET_ID: 0x8E_nt!KiDispatchException+19e
Followup: MachineOwner
another one :
Loading Dump File [C:\Program Files\Debugging Tools for Windows\Mini040604-01.dmp]
Mini Kernel Dump File: Only registers and stack trace are available
Symbol search path is: SRV*c:\websymbols*http://msdl.microsoft.com/download/symbols
Executable search path is:
Windows Server 2003 Kernel Version 3790 MP (4 procs) Free x86 compatible
Product: Server, suite: TerminalServer SingleUserTS
Built by: 3790.srv03_rtm.030324-2048
Kernel base = 0x804de000 PsLoadedModuleList = 0x8057b6a8
Debug session time: Tue Apr 06 09:33:17 2004
System Uptime: 0 days 0:07:34.015
Loading Kernel Symbols
...................................... ...................................... .......
Loading unloaded module list
...
Loading User Symbols
************************************************** *****************************
* *
* Bugcheck Analysis *
* *
************************************************** *****************************
Use !analyze -v to get detailed debugging information.
BugCheck 1000008E, {80000003, 804df1c0, f7752ba4, 0}
Probably caused by : ntkrnlmp.exe ( nt!RtlpBreakWithStatusInstruction+0 )
Followup: MachineOwner
1: kd> !analyze -v
************************************************** *****************************
* *
* Bugcheck Analysis *
* *
************************************************** *****************************
KERNEL_MODE_EXCEPTION_NOT_HANDLED_M (1000008e)
This is a very common bugcheck. Usually the exception address pinpoints
the driver/function that caused the problem. Always note this address
as well as the link date of the driver/image that contains this address.
Some common problems are exception code 0x80000003. This means a hard
coded breakpoint or assertion was hit, but this system was booted
/NODEBUG. This is not supposed to happen as developers should never have
hardcoded breakpoints in retail code, but ...
If this happens, make sure a debugger gets connected, and the
system is booted /DEBUG. This will let us see why this breakpoint is
happening.
An exception code of 0x80000002 (STATUS_DATATYPE_MISALIGNMENT) indicates
that an unaligned data reference was encountered. The trap frame will
supply additional information.
Arguments:
Arg1: 80000003, The exception code that was not handled
Arg2: 804df1c0, The address that the exception occurred at
Arg3: f7752ba4, Trap Frame
Arg4: 00000000
Debugging Details:
EXCEPTION_CODE: (HRESULT) 0x80000003 (2147483651) - Een of meer argumenten zijn ongeldig
FAULTING_IP:
nt!RtlpBreakWithStatusInstruction+0
804df1c0 cc int 3
TRAP_FRAME: f7752ba4 -- (.trap fffffffff7752ba4)
ErrCode = 00000000
eax=00000004 ebx=00000000 ecx=805429fd edx=00000000 esi=00000000 edi=80000003
eip=804df1c1 esp=f7752c18 ebp=f7752c60 iopl=0 nv up di pl zr na po nc
cs=0008 ss=0010 ds=0023 es=0023 fs=0030 gs=0000 efl=00000046
nt!RtlpBreakWithStatusInstruction+0x1:
804df1c1 c20400 ret 0x4
Resetting default scope
DEFAULT_BUCKET_ID: DRIVER_FAULT_SERVER_MINIDUMP
BUGCHECK_STR: 0x8E
CURRENT_IRQL: 0
LAST_CONTROL_TRANSFER: from 80542289 to 804df1c1
STACK_TEXT:
f7752c14 80542289 00000004 80000003 00000000 nt!RtlpBreakWithStatusInstruction+0x1
f7752c60 805434e2 00000004 00000000 f77533c0 nt!KiBugCheckDebugBreak+0x19
f7752fc8 805435b9 0000008e 80000003 804df1c0 nt!KeBugCheck2+0x882
f7752fe8 80527624 0000008e 80000003 804df1c0 nt!KeBugCheckEx+0x19
f77533a4 804e087a f77533c0 00000000 f7753414 nt!KiDispatchException+0x2f5
f775340c 804e0fe1 00000000 00000000 00000000 nt!CommonDispatchException+0x4a
f775340c 804df1c1 00000000 00000000 00000000 nt!KiTrap03+0x9d
f7753484 80542289 00000004 80000003 00000000 nt!RtlpBreakWithStatusInstruction+0x1
f77534d0 805434e2 00000004 00000000 f7753c30 nt!KiBugCheckDebugBreak+0x19
f7753838 805435b9 0000008e 80000003 804df1c0 nt!KeBugCheck2+0x882
f7753858 80527624 0000008e 80000003 804df1c0 nt!KeBugCheckEx+0x19
f7753c14 804e087a f7753c30 00000000 f7753c84 nt!KiDispatchException+0x2f5
f7753c7c 804e0fe1 00000000 00000000 00000000 nt!CommonDispatchException+0x4a
f7753c7c 804df1c1 00000000 00000000 00000000 nt!KiTrap03+0x9d
f7753cf4 80542289 00000004 80000003 00000000 nt!RtlpBreakWithStatusInstruction+0x1
f7753d40 805434e2 00000004 00000000 f77544a0 nt!KiBugCheckDebugBreak+0x19
f77540a8 805435b9 0000008e 80000003 804df1c0 nt!KeBugCheck2+0x882
f77540c8 80527624 0000008e 80000003 804df1c0 nt!KeBugCheckEx+0x19
f7754484 804e087a f77544a0 00000000 f77544f4 nt!KiDispatchException+0x2f5
f77544ec 804e0fe1 00000000 00000000 00000000 nt!CommonDispatchException+0x4a
f77544ec 804df1c1 00000000 00000000 00000000 nt!KiTrap03+0x9d
f7754564 80542289 00000004 80000003 00000000 nt!RtlpBreakWithStatusInstruction+0x1
f77545b0 805434e2 00000004 00000000 f7754d10 nt!KiBugCheckDebugBreak+0x19
f7754918 805435b9 0000008e 80000003 804df1c0 nt!KeBugCheck2+0x882
f7754938 80527624 0000008e 80000003 804df1c0 nt!KeBugCheckEx+0x19
f7754cf4 804e087a f7754d10 00000000 f7754d64 nt!KiDispatchException+0x2f5
f7754d5c 804e0fe1 00000000 00000000 00000020 nt!CommonDispatchException+0x4a
f7754d5c 804df1c1 00000000 00000000 00000020 nt!KiTrap03+0x9d
f7754dd4 80542289 00000004 00000000 00000000 nt!RtlpBreakWithStatusInstruction+0x1
f7754e20 805434e2 00000004 a2000000 84010400 nt!KiBugCheckDebugBreak+0x19
f7755188 805435b9 0000009c 00000000 f77551d0 nt!KeBugCheck2+0x882
f77551a8 8074cfab 0000009c 00000000 f77551d0 nt!KeBugCheckEx+0x19
f77552d4 8074584f f774fef0 00000000 00000000 hal!HalpMcaExceptionHandler+0xc9
FOLLOWUP_IP:
nt!RtlpBreakWithStatusInstruction+0
804df1c0 cc int 3
FOLLOWUP_NAME: MachineOwner
SYMBOL_NAME: nt!RtlpBreakWithStatusInstruction+0
MODULE_NAME: nt
IMAGE_NAME: ntkrnlmp.exe
DEBUG_FLR_IMAGE_TIMESTAMP: 3e8015c6
STACK_COMMAND: .trap fffffffff7752ba4 ; kb
BUCKET_ID: 0x8E_nt!RtlpBreakWithStatusInstruction+0
Followup: MachineOwner
internal PCI ISDN adapter ASUS P-IN-100(W,D)
This server has number of merge replications (as publisher) and does
up to 15 replications every night. From time to time (once a week or
5-6 days, but always during replication) the machine reboots.
In Compaq Integrated Management Log Viewer we have ervery time :
-PCI Bus Error (Slot 0, Bus 0, Device 15, Function 0)
-ASR Detected by System ROM
-POST Error: A Critical Error occured prior to this power-up
and in System Log:
Event Type:Error
Event Source:cpqasm
Event Category:None
Event ID:4196
Date:25.3.2004
Time:23:05:20
User:N/A
Computer:xxxxxxxxx
Description:
The system encountered a Non-Maskable Interrupt (NMI) prior to this
boot. The NMI source was: PCI bus error, slot 0.
Computer Management reported that (Slot 0, Bus 0, Device 15, Function
0) is PCI Standard ISA Bridge.
During a day there is a lot of traffic using same ISDN adapter (lot of
FTP-s) without any problem. It seems that only replication is problem.
Although I know this is most probably ISDN Adapter/drivers problem
I'm trying in this group. Maybe somebody has some hint ?
Happy greetings,
Pagus
PS: Today we had same problem with same hardware configuration at
other location, this time Proliant + Win2003 SBS as publisher.
Same problem here... Proliant ML350 G3, reboots automatically at random times...
If we test our serial port (nothing connected) with the HP-tool CPQdiagnostics (SP27119.exe) the system crashes. When we connect a mouse to that particular serial port, we got a software-error of CPQdiagnostics.
All other hardwaretests look fine.
Here we attach some minidump-debuganalyses. Can you also test these things ? Maybe we have the same problem ?
Greetings
Dieter
Microsoft (R) Windows Debugger Version 6.2.0013.1
Copyright (c) Microsoft Corporation. All rights reserved.
Loading Dump File [C:\Program Files\Debugging Tools for Windows\Mini040704-01.dmp]
Mini Kernel Dump File: Only registers and stack trace are available
Symbol search path is: SRV*c:\websymbols*http://msdl.microsoft.com/download/symbols
Executable search path is:
Windows Server 2003 Kernel Version 3790 MP (4 procs) Free x86 compatible
Product: Server, suite: TerminalServer SingleUserTS
Built by: 3790.srv03_rtm.030324-2048
Kernel base = 0x804de000 PsLoadedModuleList = 0x8057b6a8
Debug session time: Wed Apr 07 08:32:16 2004
System Uptime: 0 days 0:02:32.265
Loading Kernel Symbols
...................................... ...................................... .........
Loading unloaded module list
...
Loading User Symbols
************************************************** *****************************
* *
* Bugcheck Analysis *
* *
************************************************** *****************************
Use !analyze -v to get detailed debugging information.
BugCheck 1000008E, {c0000005, 80527564, 8056c090, 0}
Probably caused by : ntkrnlmp.exe ( nt!KiDispatchException+19e )
Followup: MachineOwner
0: kd> !analyze -v
************************************************** *****************************
* *
* Bugcheck Analysis *
* *
************************************************** *****************************
KERNEL_MODE_EXCEPTION_NOT_HANDLED_M (1000008e)
This is a very common bugcheck. Usually the exception address pinpoints
the driver/function that caused the problem. Always note this address
as well as the link date of the driver/image that contains this address.
Some common problems are exception code 0x80000003. This means a hard
coded breakpoint or assertion was hit, but this system was booted
/NODEBUG. This is not supposed to happen as developers should never have
hardcoded breakpoints in retail code, but ...
If this happens, make sure a debugger gets connected, and the
system is booted /DEBUG. This will let us see why this breakpoint is
happening.
An exception code of 0x80000002 (STATUS_DATATYPE_MISALIGNMENT) indicates
that an unaligned data reference was encountered. The trap frame will
supply additional information.
Arguments:
Arg1: c0000005, The exception code that was not handled
Arg2: 80527564, The address that the exception occurred at
Arg3: 8056c090, Trap Frame
Arg4: 00000000
Debugging Details:
EXCEPTION_CODE: (NTSTATUS) 0xc0000005 - De instructie op 0x%08lx verwijst naar geheugen op 0x%08lx. De lees- of schrijfbewerking ("%s") op het geheugen is mislukt.
FAULTING_IP:
nt!KiDispatchException+19e
80527564 e92e65feff jmp nt!KiDispatchException+0x19e (8050da97)
TRAP_FRAME: 8056c090 -- (.trap ffffffff8056c090)
ESP EDITED! New esp=8056c3f0
ErrCode = 00000000
eax=8056c6cc ebx=8056c804 ecx=81987020 edx=00010000 esi=8056c7b0 edi=00000000
eip=80527564 esp=8056c104 ebp=8056c794 iopl=0 nv up ei ng nz na pe cy
cs=0000 ss=0010 ds=0023 es=0023 fs=0030 gs=0000 efl=00000283
nt!KiDispatchException+0x19e:
80527564 e92e65feff jmp nt!KiDispatchException+0x19e (8050da97)
Resetting default scope
DEFAULT_BUCKET_ID: DRIVER_FAULT_SERVER_MINIDUMP
BUGCHECK_STR: 0x8E
CURRENT_IRQL: 0
LAST_CONTROL_TRANSFER: from 804e087a to 80527564
STACK_TEXT:
8056c794 804e087a 8056c7b0 00000000 8056c804 nt!KiDispatchException+0x19e
8056c7fc 804e07fa 00000000 00000000 00000023 nt!CommonDispatchException+0x4a
8056c804 00000000 00000023 00000023 010cfee4 nt!KiExceptionExit+0x16a
FOLLOWUP_IP:
nt!KiDispatchException+19e
80527564 e92e65feff jmp nt!KiDispatchException+0x19e (8050da97)
FOLLOWUP_NAME: MachineOwner
SYMBOL_NAME: nt!KiDispatchException+19e
MODULE_NAME: nt
IMAGE_NAME: ntkrnlmp.exe
DEBUG_FLR_IMAGE_TIMESTAMP: 3e8015c6
STACK_COMMAND: .trap ffffffff8056c090 ; kb
BUCKET_ID: 0x8E_nt!KiDispatchException+19e
Followup: MachineOwner
another one :
Loading Dump File [C:\Program Files\Debugging Tools for Windows\Mini040604-01.dmp]
Mini Kernel Dump File: Only registers and stack trace are available
Symbol search path is: SRV*c:\websymbols*http://msdl.microsoft.com/download/symbols
Executable search path is:
Windows Server 2003 Kernel Version 3790 MP (4 procs) Free x86 compatible
Product: Server, suite: TerminalServer SingleUserTS
Built by: 3790.srv03_rtm.030324-2048
Kernel base = 0x804de000 PsLoadedModuleList = 0x8057b6a8
Debug session time: Tue Apr 06 09:33:17 2004
System Uptime: 0 days 0:07:34.015
Loading Kernel Symbols
...................................... ...................................... .......
Loading unloaded module list
...
Loading User Symbols
************************************************** *****************************
* *
* Bugcheck Analysis *
* *
************************************************** *****************************
Use !analyze -v to get detailed debugging information.
BugCheck 1000008E, {80000003, 804df1c0, f7752ba4, 0}
Probably caused by : ntkrnlmp.exe ( nt!RtlpBreakWithStatusInstruction+0 )
Followup: MachineOwner
1: kd> !analyze -v
************************************************** *****************************
* *
* Bugcheck Analysis *
* *
************************************************** *****************************
KERNEL_MODE_EXCEPTION_NOT_HANDLED_M (1000008e)
This is a very common bugcheck. Usually the exception address pinpoints
the driver/function that caused the problem. Always note this address
as well as the link date of the driver/image that contains this address.
Some common problems are exception code 0x80000003. This means a hard
coded breakpoint or assertion was hit, but this system was booted
/NODEBUG. This is not supposed to happen as developers should never have
hardcoded breakpoints in retail code, but ...
If this happens, make sure a debugger gets connected, and the
system is booted /DEBUG. This will let us see why this breakpoint is
happening.
An exception code of 0x80000002 (STATUS_DATATYPE_MISALIGNMENT) indicates
that an unaligned data reference was encountered. The trap frame will
supply additional information.
Arguments:
Arg1: 80000003, The exception code that was not handled
Arg2: 804df1c0, The address that the exception occurred at
Arg3: f7752ba4, Trap Frame
Arg4: 00000000
Debugging Details:
EXCEPTION_CODE: (HRESULT) 0x80000003 (2147483651) - Een of meer argumenten zijn ongeldig
FAULTING_IP:
nt!RtlpBreakWithStatusInstruction+0
804df1c0 cc int 3
TRAP_FRAME: f7752ba4 -- (.trap fffffffff7752ba4)
ErrCode = 00000000
eax=00000004 ebx=00000000 ecx=805429fd edx=00000000 esi=00000000 edi=80000003
eip=804df1c1 esp=f7752c18 ebp=f7752c60 iopl=0 nv up di pl zr na po nc
cs=0008 ss=0010 ds=0023 es=0023 fs=0030 gs=0000 efl=00000046
nt!RtlpBreakWithStatusInstruction+0x1:
804df1c1 c20400 ret 0x4
Resetting default scope
DEFAULT_BUCKET_ID: DRIVER_FAULT_SERVER_MINIDUMP
BUGCHECK_STR: 0x8E
CURRENT_IRQL: 0
LAST_CONTROL_TRANSFER: from 80542289 to 804df1c1
STACK_TEXT:
f7752c14 80542289 00000004 80000003 00000000 nt!RtlpBreakWithStatusInstruction+0x1
f7752c60 805434e2 00000004 00000000 f77533c0 nt!KiBugCheckDebugBreak+0x19
f7752fc8 805435b9 0000008e 80000003 804df1c0 nt!KeBugCheck2+0x882
f7752fe8 80527624 0000008e 80000003 804df1c0 nt!KeBugCheckEx+0x19
f77533a4 804e087a f77533c0 00000000 f7753414 nt!KiDispatchException+0x2f5
f775340c 804e0fe1 00000000 00000000 00000000 nt!CommonDispatchException+0x4a
f775340c 804df1c1 00000000 00000000 00000000 nt!KiTrap03+0x9d
f7753484 80542289 00000004 80000003 00000000 nt!RtlpBreakWithStatusInstruction+0x1
f77534d0 805434e2 00000004 00000000 f7753c30 nt!KiBugCheckDebugBreak+0x19
f7753838 805435b9 0000008e 80000003 804df1c0 nt!KeBugCheck2+0x882
f7753858 80527624 0000008e 80000003 804df1c0 nt!KeBugCheckEx+0x19
f7753c14 804e087a f7753c30 00000000 f7753c84 nt!KiDispatchException+0x2f5
f7753c7c 804e0fe1 00000000 00000000 00000000 nt!CommonDispatchException+0x4a
f7753c7c 804df1c1 00000000 00000000 00000000 nt!KiTrap03+0x9d
f7753cf4 80542289 00000004 80000003 00000000 nt!RtlpBreakWithStatusInstruction+0x1
f7753d40 805434e2 00000004 00000000 f77544a0 nt!KiBugCheckDebugBreak+0x19
f77540a8 805435b9 0000008e 80000003 804df1c0 nt!KeBugCheck2+0x882
f77540c8 80527624 0000008e 80000003 804df1c0 nt!KeBugCheckEx+0x19
f7754484 804e087a f77544a0 00000000 f77544f4 nt!KiDispatchException+0x2f5
f77544ec 804e0fe1 00000000 00000000 00000000 nt!CommonDispatchException+0x4a
f77544ec 804df1c1 00000000 00000000 00000000 nt!KiTrap03+0x9d
f7754564 80542289 00000004 80000003 00000000 nt!RtlpBreakWithStatusInstruction+0x1
f77545b0 805434e2 00000004 00000000 f7754d10 nt!KiBugCheckDebugBreak+0x19
f7754918 805435b9 0000008e 80000003 804df1c0 nt!KeBugCheck2+0x882
f7754938 80527624 0000008e 80000003 804df1c0 nt!KeBugCheckEx+0x19
f7754cf4 804e087a f7754d10 00000000 f7754d64 nt!KiDispatchException+0x2f5
f7754d5c 804e0fe1 00000000 00000000 00000020 nt!CommonDispatchException+0x4a
f7754d5c 804df1c1 00000000 00000000 00000020 nt!KiTrap03+0x9d
f7754dd4 80542289 00000004 00000000 00000000 nt!RtlpBreakWithStatusInstruction+0x1
f7754e20 805434e2 00000004 a2000000 84010400 nt!KiBugCheckDebugBreak+0x19
f7755188 805435b9 0000009c 00000000 f77551d0 nt!KeBugCheck2+0x882
f77551a8 8074cfab 0000009c 00000000 f77551d0 nt!KeBugCheckEx+0x19
f77552d4 8074584f f774fef0 00000000 00000000 hal!HalpMcaExceptionHandler+0xc9
FOLLOWUP_IP:
nt!RtlpBreakWithStatusInstruction+0
804df1c0 cc int 3
FOLLOWUP_NAME: MachineOwner
SYMBOL_NAME: nt!RtlpBreakWithStatusInstruction+0
MODULE_NAME: nt
IMAGE_NAME: ntkrnlmp.exe
DEBUG_FLR_IMAGE_TIMESTAMP: 3e8015c6
STACK_COMMAND: .trap fffffffff7752ba4 ; kb
BUCKET_ID: 0x8E_nt!RtlpBreakWithStatusInstruction+0
Followup: MachineOwner
Monday, February 20, 2012
OS error 53 for SQL servers VPN replication?
I've got this error message when trying to create a subscriber from a
publisher through VPN in a non-trusted domain, I am using SQL server
authentication:
The schema script '\\MERCURY\G$\Program Files\Microsoft SQL
Server\MSSQL$MERCURY\ReplData\unc\MERCUR
Y$MERCURY_Northwind_NorthwindMercury
Pub1\20040221225704\snapshot.pre' could not be propagated to the subscriber.
(Source: Merge Replication Provider (Agent); Error number: -2147201001)
----
--
The process could not read file '\\MERCURY\G$\Program Files\Microsoft SQL
Server\MSSQL$MERCURY\ReplData\unc\MERCUR
Y$MERCURY_Northwind_NorthwindMercury
Pub1\20040221225704\snapshot.pre' due to OS error 53.
(Source: ECSWEB (Agent); Error number: 0)
----
--
The network path was not found.
(Source: (OS); Error number: 53)
What is OS error 53 and how can it be fixed?This error is generally caused by the fact that the SQL Server Agent
startup account on either the publisher or subscriber is not a local
administrator on one or both of the machines.
The default location for the snapshot folder is an administrative share and
as such the SQL Server Agent acount must be a local adminsitrator to access
it. From the error I am going to presume that you are creating a pull
subscription so the SQL Server Agent startup account at the subscriber must
be a local admin on the publisher. You can verify if this is the problem by
logging on to the subscriber using the SQL Server Agent startup account and
try to map a drive to the snap shot folder on the publisher:
\\MERCURY\G$\
If that fails with the same error then you have your reason for the failure.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Thanks Rand,
Yes that's right the two SQL servers are in different
non-trusted domains connected through VPN. The Distributor and Publisher SQL
Server is in the NARC domain and Agent login account as NARC\Administrator.
And the subscriber is in the HOT domain and Agent Login account is
HOT\Administrator. No trusted can be established between them. What must I
do to achieved successful pull subscription? How do I allow permissions in
the NARC domain for HOT\Administrator if there's no trusted' What about
independent SQL server logins to access shares in NARC domain(How do I set
it up if possible)?
Thanks
"Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
news:fjJVvoV$DHA.3712@.cpmsftngxa06.phx.gbl...
> This error is generally caused by the fact that the SQL Server Agent
> startup account on either the publisher or subscriber is not a local
> administrator on one or both of the machines.
> The default location for the snapshot folder is an administrative share
and
> as such the SQL Server Agent acount must be a local adminsitrator to
access
> it. From the error I am going to presume that you are creating a pull
> subscription so the SQL Server Agent startup account at the subscriber
must
> be a local admin on the publisher. You can verify if this is the problem
by
> logging on to the subscriber using the SQL Server Agent startup account
and
> try to map a drive to the snap shot folder on the publisher:
> \\MERCURY\G$\
> If that fails with the same error then you have your reason for the
failure.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>|||Joe,
I haven't got Rand's post available here, but I would advise to either use
SQL security or use pass-through authentication. Both are described in the
link in my earlier post.
Regards,
Paul Ibison
"Joe Mine" <huytuanattpgdotcomdotau> wrote in message
news:u9ThB04$DHA.2216@.TK2MSFTNGP10.phx.gbl...
> Thanks Rand,
> Yes that's right the two SQL servers are in different
> non-trusted domains connected through VPN. The Distributor and Publisher
SQL
> Server is in the NARC domain and Agent login account as
NARC\Administrator.
> And the subscriber is in the HOT domain and Agent Login account is
> HOT\Administrator. No trusted can be established between them. What must I
> do to achieved successful pull subscription? How do I allow permissions
in
> the NARC domain for HOT\Administrator if there's no trusted' What about
> independent SQL server logins to access shares in NARC domain(How do I set
> it up if possible)?
> Thanks
>
> "Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
> news:fjJVvoV$DHA.3712@.cpmsftngxa06.phx.gbl...
> and
> access
> must
> by
> and
> failure.
rights.
>|||Hi Paul,
Can you please give me the links again. I cannot locate your
previous post. The only problem I am having is I cannot from the Subcriber
SQL Server access the Snapshot Folder in the Distributor SQL Server because
this is two different non-trusted domains.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:eLNYLS8$DHA.2212@.TK2MSFTNGP10.phx.gbl...
> Joe,
> I haven't got Rand's post available here, but I would advise to either use
> SQL security or use pass-through authentication. Both are described in the
> link in my earlier post.
> Regards,
> Paul Ibison
>
> "Joe Mine" <huytuanattpgdotcomdotau> wrote in message
> news:u9ThB04$DHA.2216@.TK2MSFTNGP10.phx.gbl...
different
> SQL
> NARC\Administrator.
I
permissions
> in
about
set
share
problem
account
> rights.
>|||Try this article:
321822 HOW TO: Replicate Between Computers Running SQL Server in
Non-Trusted http://support.microsoft.com/?id=321822
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.
publisher through VPN in a non-trusted domain, I am using SQL server
authentication:
The schema script '\\MERCURY\G$\Program Files\Microsoft SQL
Server\MSSQL$MERCURY\ReplData\unc\MERCUR
Y$MERCURY_Northwind_NorthwindMercury
Pub1\20040221225704\snapshot.pre' could not be propagated to the subscriber.
(Source: Merge Replication Provider (Agent); Error number: -2147201001)
----
--
The process could not read file '\\MERCURY\G$\Program Files\Microsoft SQL
Server\MSSQL$MERCURY\ReplData\unc\MERCUR
Y$MERCURY_Northwind_NorthwindMercury
Pub1\20040221225704\snapshot.pre' due to OS error 53.
(Source: ECSWEB (Agent); Error number: 0)
----
--
The network path was not found.
(Source: (OS); Error number: 53)
What is OS error 53 and how can it be fixed?This error is generally caused by the fact that the SQL Server Agent
startup account on either the publisher or subscriber is not a local
administrator on one or both of the machines.
The default location for the snapshot folder is an administrative share and
as such the SQL Server Agent acount must be a local adminsitrator to access
it. From the error I am going to presume that you are creating a pull
subscription so the SQL Server Agent startup account at the subscriber must
be a local admin on the publisher. You can verify if this is the problem by
logging on to the subscriber using the SQL Server Agent startup account and
try to map a drive to the snap shot folder on the publisher:
\\MERCURY\G$\
If that fails with the same error then you have your reason for the failure.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Thanks Rand,
Yes that's right the two SQL servers are in different
non-trusted domains connected through VPN. The Distributor and Publisher SQL
Server is in the NARC domain and Agent login account as NARC\Administrator.
And the subscriber is in the HOT domain and Agent Login account is
HOT\Administrator. No trusted can be established between them. What must I
do to achieved successful pull subscription? How do I allow permissions in
the NARC domain for HOT\Administrator if there's no trusted' What about
independent SQL server logins to access shares in NARC domain(How do I set
it up if possible)?
Thanks
"Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
news:fjJVvoV$DHA.3712@.cpmsftngxa06.phx.gbl...
> This error is generally caused by the fact that the SQL Server Agent
> startup account on either the publisher or subscriber is not a local
> administrator on one or both of the machines.
> The default location for the snapshot folder is an administrative share
and
> as such the SQL Server Agent acount must be a local adminsitrator to
access
> it. From the error I am going to presume that you are creating a pull
> subscription so the SQL Server Agent startup account at the subscriber
must
> be a local admin on the publisher. You can verify if this is the problem
by
> logging on to the subscriber using the SQL Server Agent startup account
and
> try to map a drive to the snap shot folder on the publisher:
> \\MERCURY\G$\
> If that fails with the same error then you have your reason for the
failure.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>|||Joe,
I haven't got Rand's post available here, but I would advise to either use
SQL security or use pass-through authentication. Both are described in the
link in my earlier post.
Regards,
Paul Ibison
"Joe Mine" <huytuanattpgdotcomdotau> wrote in message
news:u9ThB04$DHA.2216@.TK2MSFTNGP10.phx.gbl...
> Thanks Rand,
> Yes that's right the two SQL servers are in different
> non-trusted domains connected through VPN. The Distributor and Publisher
SQL
> Server is in the NARC domain and Agent login account as
NARC\Administrator.
> And the subscriber is in the HOT domain and Agent Login account is
> HOT\Administrator. No trusted can be established between them. What must I
> do to achieved successful pull subscription? How do I allow permissions
in
> the NARC domain for HOT\Administrator if there's no trusted' What about
> independent SQL server logins to access shares in NARC domain(How do I set
> it up if possible)?
> Thanks
>
> "Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
> news:fjJVvoV$DHA.3712@.cpmsftngxa06.phx.gbl...
> and
> access
> must
> by
> and
> failure.
rights.
>|||Hi Paul,
Can you please give me the links again. I cannot locate your
previous post. The only problem I am having is I cannot from the Subcriber
SQL Server access the Snapshot Folder in the Distributor SQL Server because
this is two different non-trusted domains.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:eLNYLS8$DHA.2212@.TK2MSFTNGP10.phx.gbl...
> Joe,
> I haven't got Rand's post available here, but I would advise to either use
> SQL security or use pass-through authentication. Both are described in the
> link in my earlier post.
> Regards,
> Paul Ibison
>
> "Joe Mine" <huytuanattpgdotcomdotau> wrote in message
> news:u9ThB04$DHA.2216@.TK2MSFTNGP10.phx.gbl...
different
> SQL
> NARC\Administrator.
I
permissions
> in
about
set
share
problem
account
> rights.
>|||Try this article:
321822 HOW TO: Replicate Between Computers Running SQL Server in
Non-Trusted http://support.microsoft.com/?id=321822
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.
OS Error 5 during initial snapshot
I'm trying SQL Server replication for the first time. I have read a lot of posts on several forums and gone through Microsoft knowledge base articles and books online.
I have SQL Server Evaluation edition running on one Windows XP machine. (server)
I have MSDE 2000 on another Windows XP machine. (subscriber)
Both have Service Pack 3.
I have setup a publication on the server and have successfully created a pull subscripton on the subcriber.
I have a domain user account with admin privs on the server machine that is used as the SQL Server account login and SQL Server Agent login.
I have setup the ..MSSQL\REPLDATA directory as a public share and given the SQL Server Agent Account full permissions and privs - per MS KB#240688
When trying to synchronize my pull subscription I STILL get the error below.
What gives? I'm pulling out my hair now. This is obviously a permissions problem but I can't for the life of me figure out who needs what permissions and where.
Does the subscriber have to have a domain user account for anonymous subscriptions?
PARTIAL ERROR MESSAGE FROM LOG FILE:
The schema script '\\MyServer\Repldata\unc\MyServer_testdb_Lookups\2 0031210105855\PARM_LIST_1.sch' could not be propagated to the subscriber.
[12/10/2003 11:13:34 AM]E39726.test1: {call sp_reinitmergepullsubscription (N'MyServer', N'testdb', N'Lookups', 'FALSE')}
Reinitialized pull subscription to publication 'Lookups' from publisher 'MyServer:testdb'Percent Complete: 0
The subscription has been marked for reinitialization. Reinitialization will occur the next time you synchronize this subscription.
Percent Complete: 0
The schema script '\\MyServer\Repldata\unc\MyServer_testdb_Lookups\2 0031210105855\PARM_LIST_1.sch' could not be propagated to the subscriber.
Percent Complete: 0
Category:NULL
Source: Merge Replication Provider
Number: -2147201001
Message: The schema script '\\MyServer\Repldata\unc\MyServer_testdb_Lookups\2 0031210105855\PARM_LIST_1.sch' could not be propagated to the subscriber.
Percent Complete: 0
Category:AGENT
Source: E39726
Number: 0
Message: The process could not read file '\\MyServer\Repldata\unc\MyServer_testdb_Lookups\2 0031210105855\PARM_LIST_1.sch' due to OS error 5.
Percent Complete: 0
Category:OS
Source:
Number: 5
Message: Access is denied.Does your subscriber has enough previlege to access the publisher and the publication?|||Originally posted by joejcheng
Does your subscriber has enough previlege to access the publisher and the publication?
Maybe this is where I need the help. As far as I can determine my subscriber can access the publisher and the publication. As I read through the log of the sycnchronization steps I see
Connecting to subscriber
Connecting to distributor
Connecting to publisher
Retrieving publication information
Retrieving subscription information
All of these steps complete with no error I only get the error when the synch job starts to read the snapshot files
I can get to the files from the subscription PC, I can even copy them, open them, delete them. I don't know what gives.|||Originally posted by joejcheng
Does your subscriber has enough previlege to access the publisher and the publication?
Maybe this is where I need the help. As far as I can determine my subscriber can access the publisher and the publication. As I read through the log of the sycnchronization steps I see
Connecting to subscriber
Connecting to distributor
Connecting to publisher
Retrieving publication information
Retrieving subscription information
All of these steps complete with no error I only get the error when the synch job starts to read the snapshot files
I can get to the files from the subscription PC, I can even copy them, open them, delete them. I don't know what gives.
I have SQL Server Evaluation edition running on one Windows XP machine. (server)
I have MSDE 2000 on another Windows XP machine. (subscriber)
Both have Service Pack 3.
I have setup a publication on the server and have successfully created a pull subscripton on the subcriber.
I have a domain user account with admin privs on the server machine that is used as the SQL Server account login and SQL Server Agent login.
I have setup the ..MSSQL\REPLDATA directory as a public share and given the SQL Server Agent Account full permissions and privs - per MS KB#240688
When trying to synchronize my pull subscription I STILL get the error below.
What gives? I'm pulling out my hair now. This is obviously a permissions problem but I can't for the life of me figure out who needs what permissions and where.
Does the subscriber have to have a domain user account for anonymous subscriptions?
PARTIAL ERROR MESSAGE FROM LOG FILE:
The schema script '\\MyServer\Repldata\unc\MyServer_testdb_Lookups\2 0031210105855\PARM_LIST_1.sch' could not be propagated to the subscriber.
[12/10/2003 11:13:34 AM]E39726.test1: {call sp_reinitmergepullsubscription (N'MyServer', N'testdb', N'Lookups', 'FALSE')}
Reinitialized pull subscription to publication 'Lookups' from publisher 'MyServer:testdb'Percent Complete: 0
The subscription has been marked for reinitialization. Reinitialization will occur the next time you synchronize this subscription.
Percent Complete: 0
The schema script '\\MyServer\Repldata\unc\MyServer_testdb_Lookups\2 0031210105855\PARM_LIST_1.sch' could not be propagated to the subscriber.
Percent Complete: 0
Category:NULL
Source: Merge Replication Provider
Number: -2147201001
Message: The schema script '\\MyServer\Repldata\unc\MyServer_testdb_Lookups\2 0031210105855\PARM_LIST_1.sch' could not be propagated to the subscriber.
Percent Complete: 0
Category:AGENT
Source: E39726
Number: 0
Message: The process could not read file '\\MyServer\Repldata\unc\MyServer_testdb_Lookups\2 0031210105855\PARM_LIST_1.sch' due to OS error 5.
Percent Complete: 0
Category:OS
Source:
Number: 5
Message: Access is denied.Does your subscriber has enough previlege to access the publisher and the publication?|||Originally posted by joejcheng
Does your subscriber has enough previlege to access the publisher and the publication?
Maybe this is where I need the help. As far as I can determine my subscriber can access the publisher and the publication. As I read through the log of the sycnchronization steps I see
Connecting to subscriber
Connecting to distributor
Connecting to publisher
Retrieving publication information
Retrieving subscription information
All of these steps complete with no error I only get the error when the synch job starts to read the snapshot files
I can get to the files from the subscription PC, I can even copy them, open them, delete them. I don't know what gives.|||Originally posted by joejcheng
Does your subscriber has enough previlege to access the publisher and the publication?
Maybe this is where I need the help. As far as I can determine my subscriber can access the publisher and the publication. As I read through the log of the sycnchronization steps I see
Connecting to subscriber
Connecting to distributor
Connecting to publisher
Retrieving publication information
Retrieving subscription information
All of these steps complete with no error I only get the error when the synch job starts to read the snapshot files
I can get to the files from the subscription PC, I can even copy them, open them, delete them. I don't know what gives.
Subscribe to:
Posts (Atom)