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 |
|
fredong
Yak Posting Veteran
80 Posts |
 Posted - 2005-09-08 : 11:25:27
|
| I have two identical SQL2000 servers configurations A and B and I need suggestion how to get A server databases fully sync to the B server databases every 15 mins. What will be the best suggestion log shipping or replication or other better ideas? Please adivse. If replication what method should I use. Thanks.k |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-09-08 : 13:05:35
|
| If this is for disaster recovery, then log shipping is the way to go. Replication is not a disaster recovery method, it's more for copying data like for a reporting database.Tara |
 |
|
|
ryanston
Microsoft SQL Server Product Team
89 Posts |
Posted - 2005-09-08 : 13:20:28
|
| The key question in my mind is whether you need the database on server B available for read operations, for read and write operations, or not at all. If you only need it for read, then transactional replication makes sense; if you need it for read and write, then look at merge replication; if you only need it for DR (like Tara mentions), then log shipping is likely what you need.Thanks,----------------------Ryan StonecipherDeveloper, Microsoft SQL Server Storage Engine, DBCC(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-09-08 : 13:24:50
|
| You can still use log shipping if you need it for read only, although you'll get disconnected each time the tlog restores.Tara |
|
|
|
fredong
Yak Posting Veteran
80 Posts |
Posted - 2005-09-08 : 15:13:25
|
| it is basically for a redundancy server for my Datawarehouse server in case the DW server crash. So what would be the best idea.Thanks.k |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-09-08 : 17:39:16
|
| You didn't answer Ryan's questions. Do you need to access the second server while the first server is in use? If you don't, then log shipping is the way to go.Tara |
|
|
|
|
|
|
|
|
SQL 2000 server 2000 synchronization suggestion