| Author |
Topic |
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
 Posted - 2003-09-16 : 23:58:11
|
| Hi All,If my database server, unexpectedly goes down, is there any way to shift the control automatically from database server to backup server in SQL Server?Thanx in advance.---------------------------Sandesh - The Messanger |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-09-17 : 06:57:34
|
| YesIt's called clustering.You need two copies of SQL Server 2000 Enterprise Edition, two servers and a shared drive array.Do a search on this site and on www.sql-server-performance.com for some good articles.Damian |
 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-09-17 : 14:09:27
|
| You don't just need any 2 old servers, they must be supported on the Clustering HCL.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-09-17 : 20:59:44
|
Where is your sense of adventure Chad ?  Damian |
|
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-09-17 : 23:01:56
|
| Depending on your availability needs you could also use log shipping but with the catch that you may have a interval 10 minutes where you are down and the last transaction log is still sitting on your dead server or not depending on your raid setup and severity of hardware failure. |
|
|
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
Posted - 2003-09-17 : 23:17:22
|
| I am using SQL Server 7, so cant apply Log shipping. And How feasible is SQL 7 clustering on Win2K box?Thanx in advance.---------------------------Sandesh - The Messanger |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-09-17 : 23:47:03
|
| It is possible but not fun. Do some research at Microsoft.com (hey, there's a novel idea) for some good articles on it.The problem with this configuration is that it's quite fiddly to set up. Some things have to be done in exactly the right sequence or you end up with a machine that won't even boot.If you are serious about a cluster, upgrading to 2000 will save you a lot of hassle.Damian |
|
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2003-09-18 : 10:01:24
|
quote:
Originally posted by sandesh_moghe
I am using SQL Server 7, so cant apply Log shipping.
SQL7 doesn't have a built-in logshipping mechanism, but you can VERY easily build your own. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-18 : 12:15:26
|
| We actually use clustering and log shipping. We use clustering so that we can afford a failure at our main site. We use log shipping for disaster recovery purposes, so we've got another site located in another state that we log ship our databases to.Tara |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-09-18 : 14:00:07
|
| And the 7.0 Resource Kit has tools for setting up Log Shipping for SQL 7.0.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
|
Shifting Control to Backup Server