Help with creating daily backups in Windows Server 2003 Standard
Posted on 2010-11-25
The organisation I work for have a website. This runs off two servers.
1) Application Server
2) Database Server
Here are the rough specs:-
Dell Single Dual Core Xeon
Windows 2003 Server Standard Edition 32 Bit Edition
2 GB RAM
2 x 250 GB RAID 1 SATA Disks
Dell Single Quad Core Xeon
Windows 2003 Server Standard Edition 32 Bit
Windows 2003 Server Standard Edition 64 Bit Edition
SQL Server Standard 2005 Edition 1 Proc License*
4 GB RAM
2 x 500 GB RAID 1 SATA Disks
The DB server has SQL server installed I have been able to create a scheduled backup routine at Midnight every day which works fine.
However, on the APP server all I am currently using is the standard windows backup which works fine but overwrites every day so unless I log in and take a manual backup and move it to a differerent folder the backup file just keeps getting overwritten. Then if we did have a problem which was not noticed and effectively the backup kicks in and takes a backup of bad data over a healthy backup we end up with nothing.
Can anyone advise me of a good backup solution that will create a fresh daily backup that just doesnt simply overwrite.
I need to create the backup to the server itself in the c:/backup/ directory then our hosting provider takes a scheduled backup of that directory every night for us.