Jeffrey Williams (4/24/2009)
What Gail was trying to get at is that overwriting an existing file destroys any maintenance plan you setup.
Note to self. Get to the point..., ;-)
The best you can do is restore to the latest differential.
Providing that the full backup that was the base for that diff is still available.
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass