here is my requirement.
1. both server run 2003 R2 XP. p-server runs 2005 SQL work group, backup server using SQL express.
2. we have up to 30 minutes to start the backup server if prod. srv failed, and it is ok to use bcp utility to reload the data.
looks for best practices or examples.