• thats a big subject and the best answer depends on what the backup server will be used for and what latency you require.

    You need to research clustering, database mirroring, logshipping and replication, possibly even SAN replication.

    Database mirroring is dependant on this in fact not being SQL2000.

    Post more details on your requirements and SQL version and we can steer you in the right direction.

    ---------------------------------------------------------------------