March 5, 2009 at 12:54 am
peace2007 (3/4/2009)
Thanks Gail. That might be the problem, I'm sure developers take backups in between I have to ask them to do that with my coordination.
Why do developers have backup rights on a production server?
By the way, then why I get an error in restoring those differentials?
Because you're restoring the diff on top of the wrong base.
A differential backup is based on the latest full backup at the time of the diff. So, if your developers take a backup 3 days after you do, all your differential backups after that point are based off the full backup that the developers took. If they then delete that, all your differential backups after that point are useless as you don't have the right base to restore them against
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing post 16 (of 15 total)
You must be logged in to reply to this topic. Login to reply