crp0499
asked on
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
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
I don't suppose the database is in a shared folder on a drive with shadow copies enabled?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
no shadow copy is enabled. it is set to overwrite.
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?
You didnt backup to tape by chance?
ASKER
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.