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 |
|
matt_calhoon
Posting Yak Master
235 Posts |
 Posted - 2006-05-16 : 19:29:54
|
| Hi there,Im just after some advice on how everyone has their SQL Server set up for redudancy if you dont use SQL Clustering? i.e. a warm standby that you need to "Restore from backup" all the databases from the live server if it goes down? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-05-16 : 19:41:33
|
| Log shipping is perfect for a warm standby. We use clustering and log shipping. We have a 3 node cluster (active/active/active) at the main site. We also have an idential cluster at our disaster recovery site that we log ship to. We have a 5 9s requirement, so we're redundant everything.Tara Kizeraka tduggan |
 |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2006-05-17 : 10:15:23
|
quote:
We have a 5 9s requirement, so we're redundant everything.
I find it a bit hard to believe they have a redundant tkizer laying about. ;-) |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-05-17 : 10:23:57
|
Step 1 was the name change from TDuggan to TKizerStep 2 is cloning ....  Kristen |
|
|
|
|
|
|
SQL Redundancy