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 |
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
 Posted - 2010-03-19 : 08:57:15
|
Dear mates,I want to set a database to snapshot-isolation.Before I can do this I need to deactivate the replication.Type of replication is Transactional.What is to do for this?Is it just to stop the Log Reader Agent then do my work and then again start th Log reader Agent?Thanks for your replies.Webfred
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-03-19 : 13:08:39
|
| I don't think you need to stop replication. you need to be sure there aren't a lot of current transactions though |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-03-20 : 12:51:34
|
OK - you think if there are no transactions then there is nothing to do for the replication and I can go on to make my changes to snapshot-isolation.Thank you, I will try it.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-03-20 : 14:29:37
|
| I tested it last night, had no issues |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
How to deactivate replication