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
LVL 1
Thor2923Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

AlanConsultantCommented:
Hi,

Have you tried deleting it from DOS (or PowerShell) ?

If you read the attributes from a shell, what do you get?


Alan.
0
JohnBusiness Consultant (Owner)Commented:
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
0
AlanConsultantCommented:
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.
0
10 Tips to Protect Your Business from Ransomware

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.

JohnBusiness Consultant (Owner)Commented:
Unlocker works fine and will not require a reboot, so that is why I suggested it.
0
Robert LemMrCommented:
Try to move the files into to an empty folder. Then delete the folder. See if that works.
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
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
0
Geert GOracle dbaCommented:
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\CurrentControlSet\Control\Session Manager\PendingFileRenameOperations

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
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
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
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..
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 2012

From novice to tech pro — start learning today.