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 - 2003-03-26 : 07:34:20
|
| Skip writes "Scenario:I am using Transactional Replication to complete push subscriptions to SQL 2000 databases from a SQL 6.5 publishing server and distribution server. I currently have this setup and working in production. My delima is occasionally I need to refresh our Model Office environment with my replicated data after I have restored my production database into model office.I would take down replication and repoint it to my Model Office database, but I have hundreds of tables to deal with.Question:What is the optimal way to accomplish pushing my subscriptions to my Model Office Environment? Note: We have an EMC SAN which restores my Model Office Environment completely (bit-by-bit). Therefore, all of my system tables have data from production." |
|
|
|
|
|
SQL Server 6.5 Transaction Replication