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 |
|
cowboisql
Starting Member
3 Posts |
 Posted - 2007-01-26 : 11:52:14
|
| HiI am currently using a basic backup stragedy of full DB backup each morning and several transaction log backup during the course of the day. Data or txn logs backup are transfered to remote DR server after each backup.Is replication better than this approach?Secondly the app that updates this database has its own key generator. Also some autonumber keys exist in the DB. I have read that for autonumber you need to specify a clause to indicate not to generate when in replication mode. Is there a utility to convert autonumber fields to be replication supportive? Also, I do not think the application key generator will have an impact?ThanksAndy |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-01-26 : 12:28:57
|
| "Is replication better than this approach?"IMHO Not unless you want people local to the DR server to be accessing it (to reduce bandwidth or whatever). Log Shipping would be my preferred method of DR for a warm-ish standby server.Kristen |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-01-26 : 14:33:41
|
| Replication is not a disaster recovery solution.For SQL Server 2000, we use log shipping.For SQL Server 2005, we use database mirroring. Tara Kizer |
|
|
|
cowboisql
Starting Member
3 Posts |
Posted - 2007-01-30 : 15:06:07
|
| Thanks guys. Logically just as I have thought I needed the assurance. |
|
|
|
|
|
|
Replication vs backup and ship logs..