How to create a backup("failover") server?

Hi,
We have a database (SQL SERVER 7.0) and web server on the same NT4
machine(Everything runs off here). The databases started crashing when
being updated with a VB6 program. Now, it's crashing even after we
disable the VB6 program. This has never happen before and we are not
exactly database experts. We muddle through when we have to but now
it's harder.
We have a good number of web applications that uses the database and
it's a pain when it keeps crashing. We have a test server(Win2k) with
SQL Server 7.0 installed but without any of the databases on the Main
server. We would like to temporary use the test server as a
backup("failover") database server until we can figure out the problem
and was wonder how to do this?
Thanks in advance.This is a good start: http://www.microsoft.com/technet/pr...
/sqlhalp.mspx
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"T.Taylor" <taylort2@.juno.com> wrote in message
news:1129730387.457839.176740@.f14g2000cwb.googlegroups.com...
> Hi,
> We have a database (SQL SERVER 7.0) and web server on the same NT4
> machine(Everything runs off here). The databases started crashing when
> being updated with a VB6 program. Now, it's crashing even after we
> disable the VB6 program. This has never happen before and we are not
> exactly database experts. We muddle through when we have to but now
> it's harder.
> We have a good number of web applications that uses the database and
> it's a pain when it keeps crashing. We have a test server(Win2k) with
> SQL Server 7.0 installed but without any of the databases on the Main
> server. We would like to temporary use the test server as a
> backup("failover") database server until we can figure out the problem
> and was wonder how to do this?
> Thanks in advance.
>