October 5, 2015 at 8:18 pm
Welsh Corgi (10/5/2015)
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.
No apologies needed.
But the stairway series WAS written by someone in the trenches. It IS a first hand recommendation. All of the answers you are looking for are in this series of articles. It probably takes more time to type these posts than to read the articles! 😀
At least read the article on replicaton monitor. That will get you what you need!
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 6, 2015 at 5:21 am
Michael L John (10/5/2015)
Welsh Corgi (10/5/2015)
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.
No apologies needed.
But the stairway series WAS written by someone in the trenches. It IS a first hand recommendation. All of the answers you are looking for are in this series of articles. It probably takes more time to type these posts than to read the articles! 😀
At least read the article on replicaton monitor. That will get you what you need!
Another nickel's worth of free advice is to read the article you mention in your signature and then follow the advice given there. You've been around this forum for a long time and some of the questions I've seen you ask are just downright bewildering. When you post a question, remember that we can't see what you see. We don't know the context of anything you're doing. The odds of anyone figuring out a solution to a problem you're having without context are pretty low. Please, give us some context and something to go on. In short, help us help you.
Also, let me second what Michael said. Take the time to read and learn. He's right - it's an investment in yourself and there's no substitute for knowing the material yourself. Don't get me wrong - I'm certainly not saying I know it all. In fact, far from it. However, if I'm working with something I don't know, I spend some time reading about it to learn the basics. It's time well spent.
October 6, 2015 at 6:53 am
Welsh Corgi (10/5/2015)
I have 1 Table has been refreshed since the 29th of October....
Thanks.
OK, we now know you're talking about replication. However, I'd like to point out that today is October 6. Are you saying that the subscription hasn't been refreshed since October 29, 2014 (last year) ?
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 6, 2015 at 8:40 am
ok, it was September 29th.
I have been working around the clock for two weeks 7 days week.
Sorry about that.
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 6, 2015 at 9:15 am
Welsh Corgi (10/5/2015)
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.
Actually, all you said was this:
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.
October 6, 2015 at 12:22 pm
Welsh Corgi (10/6/2015)
ok, it was September 29th.I have been working around the clock for two weeks 7 days week.
Sorry about that.
It sounds like you need to take yourself offline for a few days of mental recovery and reorganization. 😉
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 6, 2015 at 12:26 pm
Eric M Russell (10/6/2015)
Welsh Corgi (10/6/2015)
ok, it was September 29th.I have been working around the clock for two weeks 7 days week.
Sorry about that.
It sounds like you need to take yourself offline for a few days of mental recovery and reorganization. 😉
I'd suggest against a rebuild. It might get painful. 😉
October 6, 2015 at 12:41 pm
Ed Wagner (10/6/2015)
Eric M Russell (10/6/2015)
Welsh Corgi (10/6/2015)
ok, it was September 29th.I have been working around the clock for two weeks 7 days week.
Sorry about that.
It sounds like you need to take yourself offline for a few days of mental recovery and reorganization. 😉
I'd suggest against a rebuild. It might get painful. 😉
Hopefully there is a failover DBA on standby.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 6, 2015 at 5:21 pm
Please close this thread and put this puppy to rest.
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/
October 7, 2015 at 10:12 am
Welsh Corgi (10/6/2015)
Please close this thread and put this puppy to rest.Thank you.
Get used to the tangents. They happen.
Viewing 10 posts - 16 through 25 (of 25 total)
You must be logged in to reply to this topic. Login to reply