I need to find a program to replace my current method of doing backups at client offices. I currently use xxcopy with a simple batch script. It works OK but doesn't do exactly what I need. If anyone has any recommendations I would like any help offered. Here is what I need to do...
User rotates external drives, clicks an icon and it will backup folders on a Windows 2003 Server to an external drive and a Backup Server. I don't want it to be put in a single zipped or other big backup file. It needs to "almost" clone a folder to another server and an external drive. I say "almost" because it only needs to be synchronized twice a day. I also need it to be able to email the results automatically.
So basically, there is a "Data" folder on the Server that all workstations are mapped to. This folder needs to be cloned, or synchronized, at lunch and at the end of the day. The destination of the backup will be a Backup Server "Data" folder and an external USB drive. The results of the backup will be checked by the staff and e-mailed to me. In the event the primary server goes down, the workstations can be re-mapped to the backup server, which would be updated twice per day.
The ability to backup an SQL database would be a real bonus, although not mandatory because the office software has a method to do it, although it is not very user friendly.
Off-Site backup services do not seem feasible due to the size of the data (200-500GB) and the time required to do a Restore over the Internet.
Any suggestions or recommendations would be really appreciated.