I have a production database that is fully backed up nightly and incrementally backed up hourly. On our backup machine, we have the differential backups and full backups restored ion a regular basis in a job. However, I need to only restore a backup file if the backup is valid (meaning this backup is newer than the current database backup version). Is there any way to accomplish this?
This is our current solution until we can get mirroring working.
All help is greatly appreciated!