Redundancy Question

Dear All
We have a server running Windows 2000 Server with SQL 2000. This is our web
server, and what I would like to do is implement some form of redundancy
server within this environment. Ideally, what I would like to achieve is a
scenario where is if there is a failure on one of the servers another one
would start up ad take on the exact same role with the exact same access and
sql database and applications.
Does anyone have any idea how this would be achieved, and point in the right
direction.
Thanks
NeilHi,
You can go for below options:-
1. Transactional Replication
2. Logshipping every 5 minutes.
In the above cases you have to change your IP Address of new server with old
server when there is a requirement
Thanks
Hari
MCDBA
"Neil Shirley" <neils@.nospam.complete-it.co.uk> wrote in message
news:epDILRYPEHA.1612@.TK2MSFTNGP11.phx.gbl...
> Dear All
> We have a server running Windows 2000 Server with SQL 2000. This is our
web
> server, and what I would like to do is implement some form of redundancy
> server within this environment. Ideally, what I would like to achieve is
a
> scenario where is if there is a failure on one of the servers another one
> would start up ad take on the exact same role with the exact same access
and
> sql database and applications.
> Does anyone have any idea how this would be achieved, and point in the
right
> direction.
> Thanks
> Neil
>|||Have a look at
http://www.microsoft.com/sql/techin...vailability.asp
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Neil Shirley" <neils@.nospam.complete-it.co.uk> wrote in message
news:epDILRYPEHA.1612@.TK2MSFTNGP11.phx.gbl...
> Dear All
> We have a server running Windows 2000 Server with SQL 2000. This is our
web
> server, and what I would like to do is implement some form of redundancy
> server within this environment. Ideally, what I would like to achieve is
a
> scenario where is if there is a failure on one of the servers another one
> would start up ad take on the exact same role with the exact same access
and
> sql database and applications.
> Does anyone have any idea how this would be achieved, and point in the
right
> direction.
> Thanks
> Neil
>