Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.
I need to delete a large 400GB .BAK file that was a database backup on WIndows 2012r2 but get error 0x80070570
A database admin came to me today trying to delete one of her .bak files. She cannot can continues to get error 0x80070570 the file or directory is corrupted or unreadable. I have googled around and this happens on desktops a lot and the fix it to run a check disk and probably reboot. This is an active SQL server and I do not have the luxury of just rebooting. Does anyone know of another way out of this? I do not think it is related but I did notice the .BAK files are set up use Notepad as their default application which I know is not the default. I do not see a simple way to change that back to what I think is no app at all. Any insight on that would help too. We are running Windows 2012r2...thanks
Asked:
Who is Participating?
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get every solution instantly with Premium.
Start your 7-day free trial.
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.
Try deleting it with Unlocker 1.9.2. Google for Unlocker and pick a good source. You may get some ads so watch for that.
Try this link: http://m.majorgeeks.com/files/details/unlocker.html
Try this link: http://m.majorgeeks.com/files/details/unlocker.html
Just going to note that I would not use third party software on a SQL Server (or Exchange Server for that matter) unless I had no other choice - a last resort if you like, and that would be after booting into a Live Linux DVD, and trying to delete it from there.
I have nothing against Unlocker - this is a general prejudice of mine :-)
Probably a simple reboot would do it anyway, but obviously that is not easy given the setup you describe.
Alan.
I have nothing against Unlocker - this is a general prejudice of mine :-)
Probably a simple reboot would do it anyway, but obviously that is not easy given the setup you describe.
Alan.
Try to see whether anyone else have already tried to open up that *.bak file using Notepad and left it open or not.
Also try to see whether any process is utilizing that file preventing it to get deleted, you can try using sysinternals process explorer to see whether any user process or antivirus or any process is placing locks on that file or not.
https://docs.microsoft.com/en-us/sysinternals/downloads/process-explorer
Also try to see whether any process is utilizing that file preventing it to get deleted, you can try using sysinternals process explorer to see whether any user process or antivirus or any process is placing locks on that file or not.
https://docs.microsoft.com/en-us/sysinternals/downloads/process-explorer
after process explorer ...
for deleting locked files, there is also the option to mark it to delete at reboot.
either enter the file name in HKLM\System\CurrentControl
or use the move file utility of SysInternals for that
https://docs.microsoft.com/en-us/sysinternals/downloads/movefile
you might not win back the space until reboot
for deleting locked files, there is also the option to mark it to delete at reboot.
either enter the file name in HKLM\System\CurrentControl
or use the move file utility of SysInternals for that
https://docs.microsoft.com/en-us/sysinternals/downloads/movefile
you might not win back the space until reboot
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
Hi Thor2923,
It would be better if you can explain what you have did to resolve the issue after we have all provided our comments..
It would be better if you can explain what you have did to resolve the issue after we have all provided our comments..
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 2012
From novice to tech pro — start learning today.
-
Windows Server 2012Certification: MCSA MCSE Microsoft Certified Solutions Associate & … 303 lessons
-
Windows Server 2012Certification: MCSA MCSE Microsoft Certified Solutions Associate & … 435 lessons
-
Windows Server 2012Certification: MCSA MCSE Microsoft Certified Solutions Associate & … 388 lessons
-
Windows Server 2012Certification: MCSA MCSE Microsoft Certified Solutions Associate & … 450 lessons
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get every solution instantly with Premium.
Start your 7-day free trial.
Have you tried deleting it from DOS (or PowerShell) ?
If you read the attributes from a shell, what do you get?
Alan.