Setting up online standby Database Server

[spadhi]

Hi All,
I want to write a VB Component for taking backup and restore of MS SQL Server7.0. The scenarieo is like this. I have 2 SQL Servers running on different locations. Now i want to take backup of database from one server and put it into another server. Both servers will be running and the responsibility of my Component would be to take the backup from one server to another for every 1 hour.
Apart from this I have another requirement. That is if at all 1st(primary) server fails (or) Database fails ,then the 2 server(backup) should become active server without much interruption.
Could you give me the suggestion how i can proceed . If possible can you give me the code. Your earliest reply is appriciated.
Thanking you,
Susanth.

[Cakkie]

The first one is the easiest, this requires you to use SQL DMO, allowing you to take backups. After you created the backups, copy the backup-files to the other server, use SQLDMO again to restore the database over the other. There are some examples at MSDN (http://msdn.microsoft.com).

The second part is harder, you will need to set up some sort of load-balancing stuff to be done, which directs all the traffic to the primary server, only when that server is down, it should be redirected to the second. I'm not really on to this topic, but I know it can be done, so you should check out some websites or read some books on that matter.

Tom Cannaerts
slisse@planetinternet.be

Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the universe trying to produce bigger and better idiots. So far, the universe is winning -- Rich Cook