Recovery of database Immediately

Hi,
We are having a database and all times users are connected to the server and
using the database.
Suddenly the Server failed( Some problem crashed).
At this point of time I want all the users to connect asusual without having
a knowledge of that the server fail.
Is any way to handle this situation in SQL Server.
Please give me a solution as soon as Possible
Thanks,
Herbert
Hi,
You need to setup a failover clustering.
SQL Server 2000 failover clustering provides high availability support.
Incase of of an operating system failure or a crash, you can configure one
failover cluster to fail over to any other node in the failover cluster
configuration. This will minimize system downtime, thus providing high
server availability.
See Failover Clustering Architecture architecture topic in books online
Thanks
Hari
SQL Server MVP
"Herbert" <Herbert@.discussions.microsoft.com> wrote in message
news:B28C91A1-9414-4462-93D2-07F8D807E291@.microsoft.com...
> Hi,
> We are having a database and all times users are connected to the server
> and
> using the database.
> Suddenly the Server failed( Some problem crashed).
> At this point of time I want all the users to connect asusual without
> having
> a knowledge of that the server fail.
> Is any way to handle this situation in SQL Server.
> Please give me a solution as soon as Possible
> Thanks,
> Herbert
|||Note that clustering is not an immediate failover. The cluster sw need to realize the one node is
down, start the services on the other node and then SQL server need to perform automatic recovery
for each database.
A more immediate failover (without even client disconnect) will be available in SLQ Server 2005 with
database mirroring.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:u7ep9ljdFHA.1684@.TK2MSFTNGP09.phx.gbl...
> Hi,
> You need to setup a failover clustering.
> SQL Server 2000 failover clustering provides high availability support. Incase of of an operating
> system failure or a crash, you can configure one failover cluster to fail over to any other node
> in the failover cluster configuration. This will minimize system downtime, thus providing high
> server availability.
> See Failover Clustering Architecture architecture topic in books online
> Thanks
> Hari
> SQL Server MVP
> "Herbert" <Herbert@.discussions.microsoft.com> wrote in message
> news:B28C91A1-9414-4462-93D2-07F8D807E291@.microsoft.com...
>
|||Hi tibor karaszi,
i s any way in SQL 2000 to Recover the database without disconnecting the
Client.
Thanks,
Herbert
"Tibor Karaszi" wrote:

> Note that clustering is not an immediate failover. The cluster sw need to realize the one node is
> down, start the services on the other node and then SQL server need to perform automatic recovery
> for each database.
> A more immediate failover (without even client disconnect) will be available in SLQ Server 2005 with
> database mirroring.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:u7ep9ljdFHA.1684@.TK2MSFTNGP09.phx.gbl...
>
|||Assuming you mean if the SQL server service or whole machine stops, then no. Not with current
version of SQL server. In a disconnected world, most make the application handle this, though.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Herbert" <Herbert@.discussions.microsoft.com> wrote in message
news:22D3E638-27D9-41AA-A45F-2B1424386DA1@.microsoft.com...[vbcol=seagreen]
> Hi tibor karaszi,
> i s any way in SQL 2000 to Recover the database without disconnecting the
> Client.
> Thanks,
> Herbert
>
> "Tibor Karaszi" wrote: