How can I recover an over-written ntback file from previous day?

ok, this is an insurance office.  i use ntbackup to run a disk-to-disk backup every day.  my backup is a simple over-write of the complete system.

last night, the office mgr called and said she had corrupted a backup attempt of her database.  she then restored her corrupted backup over the top of her still good copy, therefore creating two corrupt copies.

I looked at the *.bkf and said, no problem, we have a backup.

then, last night, my backup ran, thus over-writing the only good copy on yesterdays backup with the two corrupt copies on the server hard drive.

Now, my question is, can I use any sort of software or recovery process to go back to the ntbackup file of day before and recover my good file?  IF not, I lose a months worth of accounting.

Like I said, I am using the windows native backup, it's set to over-write with same file name, etc.

any help would be appreciated.

Thanks

Cliff
crp0499CEOAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DarylxCommented:
I don't suppose the database is in a shared folder on a drive with shadow copies enabled?
0
ryansotoCommented:
If you have it set to overwrite the same file then no you are out of luck.
You need to create a series of folders, one for each day and create backup jobs to run for each day.
Unless you have something like shadow copies enabled as Darlyx said then there's not much you can do.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
crp0499CEOAuthor Commented:
no shadow copy is enabled.  it is set to overwrite.
0
ryansotoCommented:
When a file is over written your done for.  If a file is deleted that can be recovered using software.
You didnt backup to tape by chance?
0
crp0499CEOAuthor Commented:
we had over written an SQL file.  we were able to use the transaction logs to rebuild the 31 days we lost.  it worked out great.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2003

From novice to tech pro — start learning today.