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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-05-26 : 06:57:01
|
| atul writes "A tricky situation where SQL 2k server is replicated in 10 locations across the country, when publisher database is changed ( ie add a table / alter table ) huge snapshot is generated, which in turn the subscribers have to get, which is not possible over the WAN in place, so copy of the snapshot needs to be sent across on media. This takes time and so the applications which update fast accessing the subscribers fail. IS THERE ANY WAY SO THAT THE SNAPSHOT IS MINIMIZED ? OR ANY WAY USING WHICH ONLY THE CHANGES IN THE DB ARE GIVEN TO THE SUBSCRIBERS ?" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-26 : 13:02:54
|
| I've only recently started using replication, but I don't think that you can alter tables that are being replicated. You have to drop replication, then alter it, then recreate it. So how are you doing this? Are you sure you aren't talking about log shipping? What kind of replication is this? I've only used transactional replication.Tara |
 |
|
|
|
|
|
SQL 2000 SERVER replication