Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mikebird
Aged Yak Warrior
529 Posts |
 Posted - 2008-04-02 : 08:41:43
|
| I wanted to get just 3 tables updating from Production to my Test database to keep things up to date, so started to set up a publication, but noticed it was deathly slow and the boss did not like the shared hand icon appearing by the database! Everything slowed down. This is a 21Gb DB.I've cancelled everything now. There is no publication. It took hours. The shared hand icon remains and there are agents with red crosses everywhere! How do I clear it all up back to normal?Thanks |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-04-02 : 09:03:44
|
| dupe with http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=100123 |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-02 : 09:29:32
|
| How big are those tables? It must be big enough.Disabling publisher and distributor will solve it.But be sure before you do that. |
|
|
|
mikebird
Aged Yak Warrior
529 Posts |
Posted - 2008-04-02 : 09:58:49
|
| I see a new small database called distribution and I don't want that there.Can I delete it and clean all the rest up and keep the main Production monster intact...? |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-04-02 : 10:14:33
|
| Please ask all questions in the other thread. |
|
|
|
|
|
|
Replication Overhead