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 |
|
CompiledMonkey
Starting Member
3 Posts |
 Posted - 2004-06-01 : 15:07:41
|
| I'm trying to get fully automated replication between 2 SQL Server 2000 instances. I've been able to do this with a single database and specific tables, but I haven't found an option to do this with all of the databases and all of their tables. What I found required me to choose specific tables to be replicated. Which leads me to believe when a new table is created I’ll have to go in and add it to the list. This doesn’t seem very helpful if I have to do that manually.Does anyone know if there is a way where I can have full replication from one machine to another? I’d like for it to encompass all of the databases and all of their tables. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-01 : 15:10:25
|
| Are you using this for disaster recovery? If so, log shipping is what you need.Replication does not have the option of "full replication" as you called it or replicating new tables without adding them in first.Tara |
 |
|
|
CompiledMonkey
Starting Member
3 Posts |
Posted - 2004-06-01 : 15:19:04
|
| Exactly, this is the "just in case" situation. I'll look up log shipping and see what I can find. Thank you. |
|
|
|
|
|
|
Full replication between 2 machines