January 21, 2016 at 7:00 am
I have watched multiple videos on Transaction Replication.
The 4th video 4 of 6 of the author starts getting confusion on the troubleshooting errors.
The screen is to small to read. I can't tell what is copied and pasted and the names of the columns that are being copied are not clearly defined.
It is a great series of videos but I'm having trouble with the small screens, etc. I can't tell where he is copying from and to.
The part that is hard to read starts at 49.31 seconds into the video at the following URL.
https://www.youtube.com/watch?v=zgIt5VWYG1Y
I have had problems with missing dependent objects even though I use the script to identify them:
select *
from sys.dm_sql_referenced_entities('schema.name', 'OBJECT') sre
inner join sys.objects so on sre.referenced_id = so.object_id
where (so.type = 'U' AND so.is_published = 0) or (so.type IN ('P', 'V') AND so.is_schema_published = 0)
If I replicate a view and I do not publish an underlying table article replication errors out.
How do I identify an error code and add it and add it to the ignore error property?
Does anyone know of additional videos on SQL Server Transaction replication?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 21, 2016 at 7:58 am
have you read this ....may help as additional source
http://www.sqlservercentral.com/stairway/72401/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 21, 2016 at 8:21 am
Actually the part that I have trouble following stats at 2:500 at the following URL:
https://www.youtube.com/watch?v=MxXVZ2pTsLs
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 21, 2016 at 8:53 am
J Livingston SQL (1/21/2016)
have you read this ....may help as additional source
Yes this video is moor clear and detailed. I will keep it as a reference.
I'm looking specifically at troubleshooting at this point.
Thanks.
.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 21, 2016 at 1:25 pm
J Livingston SQL (1/21/2016)
have you read this ....may help as additional source
I'm going through these articles.
I also to a quick look at the video.
Thanks.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 22, 2016 at 3:32 am
Welsh Corgi (1/21/2016)
How do I identify an error code and add it to the ignore error property?
Hi,
with this query you can select your error from replication
Please run this query on the distributor:
-- show last ERROR for all publisher
SELECT TOP 10 *
FROM [distribution].[dbo].[MSrepl_errors]
ORDER BY time DESC
If you wan't to ignore this errors, you can use the replication monitor, and configure the distribution agent. Maybe take a look at this posting:
http://geeks.ms/blogs/ozonicco/archive/2013/12/30/211283.aspx
Kind regards,
Andreas
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply