October 5, 2015 at 2:55 pm
I have 1 Table has been refreshed since the 29th of October.
I checked other tables and they are being refreshed.
How can I identify and correct the problem?
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/
October 5, 2015 at 3:03 pm
Welsh Corgi (10/5/2015)
I have 1 Table has been refreshed since the 29th of October.I checked other tables and they are being refreshed.
How can I identify and correct the problem?
Thanks.
excuse me, but seriously?
you are a well experienced participant on this forum.
please re read your post and repost with the necessary details that will enable us to help.
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 5, 2015 at 3:08 pm
Welsh Corgi (10/5/2015)
I have 1 Table has been refreshed since the 29th of October.I checked other tables and they are being refreshed.
How can I identify and correct the problem?
Thanks.
So, what does it mean to "refresh" a table: updating statistics, replication, etc.?
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 5, 2015 at 3:31 pm
Welsh Corgi (10/5/2015)
I have 1 Table has been refreshed since the 29th of October.I checked other tables and they are being refreshed.
How can I identify and correct the problem?
Considering that however the tables are 'refreshed' must be some custom process that is implemented on your servers, how the hell are we supposed to know?
Work through whatever process is 'refreshing' the tables and debug it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 5, 2015 at 3:33 pm
Assuming this is a data warehouse load, start checking the logs for the ETL process. If there is a problem hopefully the process logs the errors.
October 5, 2015 at 3:59 pm
Someone removed the article.
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/
October 5, 2015 at 4:11 pm
Welsh Corgi (10/5/2015)
Someone removed the article.
What article?
October 5, 2015 at 5:00 pm
Lynn Pettis (10/5/2015)
Welsh Corgi (10/5/2015)
Someone removed the article.What article?
You mean you didn't see the article? 😉
I don't know what it means to 'refresh a table" either. I'd say to check whatever "refreshes the table" and figure out what's wrong with it. If you don't understand what it's doing, ask the author.
October 5, 2015 at 5:12 pm
Welsh Corgi (10/5/2015)
Someone removed the article.
Replication?
October 5, 2015 at 5:38 pm
Alexander Suprun (10/5/2015)
Welsh Corgi (10/5/2015)
Someone removed the article.Replication?
I was looking for the syspublications table in the wrong table.
I added the article without incident.
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/
October 5, 2015 at 5:47 pm
Welsh Corgi (10/5/2015)
Alexander Suprun (10/5/2015)
Welsh Corgi (10/5/2015)
Someone removed the article.Replication?
I was looking for the syspublications table in the wrong table.
I added the article without incident.
And we would have figured this out how by what you originally posted?
October 5, 2015 at 6:15 pm
Lynn Pettis (10/5/2015)
Welsh Corgi (10/5/2015)
Alexander Suprun (10/5/2015)
Welsh Corgi (10/5/2015)
Someone removed the article.Replication?
I was looking for the syspublications table in the wrong table.
I added the article without incident.
And we would have figured this out how by what you originally posted?
Well I noted what databases that I checked.
Thanks Lynn.
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/
October 5, 2015 at 6:19 pm
How can you get an Alter that replication is not refreshing the subscriber?
Is there a 3rd party tool to do this?
I created an alter in SSMS but it did not seem to cover replication failure that bring it to it's needs?
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/
October 5, 2015 at 7:28 pm
Do yourself a favor. Invest in yourself.
Look at this site:
http://www.sqlservercentral.com/stairway/72401/
Read this series. Almost all of your questions are answered in this series.
There are numerous articles on monitoring replication. Google that.
Open "Replication Monitor". Poke around in there. You can see the status of everything in there. It's covered in the Stairway series.
Google "Hillary Cotter" He's a replication guru. Go to "ReplicationAnswers.com" This is a little dated, but it's still relevant.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
October 5, 2015 at 7:53 pm
Michael L John (10/5/2015)
Do yourself a favor. Invest in yourself.Look at this site:
http://www.sqlservercentral.com/stairway/72401/
Read this series. Almost all of your questions are answered in this series.
There are numerous articles on monitoring replication. Google that.
Open "Replication Monitor". Poke around in there. You can see the status of everything in there. It's covered in the Stairway series.
Google "Hillary Cotter" He's a replication guru. Go to "ReplicationAnswers.com" This is a little dated, but it's still relevant.
ok, sorry. No excuse but I have a lot going on.
It would be nice have a first hand recommendation with someone that has used these tolls
Thank you.
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/
Viewing 15 posts - 1 through 15 (of 24 total)
You must be logged in to reply to this topic. Login to reply