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 |
|
uberman
Posting Yak Master
159 Posts |
 Posted - 2003-02-19 : 10:29:41
|
| I need advice!Sql Server 2000 Standard Edition (so log shipping is not an option)Main site in physical location A.Back up site in different physical location X.Only connectivity between the two is internet (tcp/ip)I want to create a hot (well, warm) backup server at location X that I can configure to take over from server A when some thing really horrible happens to server A (machine/hammer interface error, fire, total connectivity drop etc etc)....So I need to keep the server at location X relatively up to date (15-30mins acceptable, 1min ideal!) with the data from the server at location A.I am looking at replication but have read that it is not really recommended for this type of application [url]http://www.microsoft.com/technet/treeview/default.asp?url=/technet/itcommunity/chats/trans/sql/sql0322.asp[/url]Any pointers/suggestions as to where I should be looking, what I should be doing gratefully accepted |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-02-19 : 10:57:25
|
| On source serverbackup tr log preiodically (every 15 mins?).On destination servercopy the tr log from source serverapply tr log==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
royv
Constraint Violating Yak Guru
455 Posts |
Posted - 2003-02-19 : 12:18:34
|
| http://www.sql-server-performance.com/sql_server_log_shipping.asp***************************************Death must absolutely come to enemies of the code! |
|
|
|
|
|
|
Warm backup with Standard Edition