Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

Thank you.

share|improve this question
    
Are you backing up each week appending to the same backup file or to a separate physical file each time. –  Chris W Aug 20 '09 at 8:58
    
I overwrite the old backup file..I take tape backups of the existing backup. backup of the backup –  SZayat Aug 20 '09 at 11:23

1 Answer 1

Something had to have gone wrong with the backup, or the wrong file was restored. Perhaps you had more than one backup within the backup file?

It isn't possible for SQL Server to backup a database and have the database in the backup be older than the current set of data.

The only exception would be if you had a transaction open for months, and then the database is backed up, then when restored the transaction would then be rolled back.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.