This is a question for someone who has had hands-on experience with this. Mainly I'm wondering whether this is a straight-forward process that can be achieved with the backup utility included with Windows 2003.
Of course, we would prefer to maximise our Recovery Point and minimise our Recovery Time.
Currently, regular full, differential and log backups are done for the SQL Server. However, we want to avoid having to a do a full software/update install and server reconfiguration in the event of disaster.
The plan is to do the full computer restore and then restore the latest full, differential and log backups for the database. i.e. the full computer backup might be a week old but because of the db backups we can still recover the data to within the last 15 minutes before disaster strikes.
It would be great to have someone with experience in this area to provide guidance. Thank you.