I take weekly full backups of a SQL 2000 database via vanilla Enterprise Manager.
The problem happened when I tried to restore the database. I learn that it was not up-to-date as it was pointing back to a month old data, I even double checked the other 2 weekly backups and the data was almost identical. Is there any technical explanation or known MS bug for that. Kindly note that the database server was running on a RAID5 HDD configuration and one of these hard disks was faulty. Moreover, all of the weekly backups have different sizes and of course a file datestamp.