Backup Server SQL

[zas1]

Hello, I have a server SQL 2K (W2K Server). I want to have another server SQL for recovery in case of disaster.
Which is the best solution?
Thanks!

 

[RobertT687]

Take a look in BOL at Log Shipping. The backup server can be kept up to date with the primary server. You control how often the data changes are applied to the backup. It's probably the most cost-effective way to have a 'warm' backup at the ready.

 

[mrdenny]

You can either use SQL Servers built in Log Shipping, or you can write your own. I recommend writting your own code to do it. I've found that it's much easier and more reliable then using the built in log shipping. The end result is the same.

Denny

--Anything is possible. All it takes is a little research. (Me)