由于操作系统错误32而导致备份db文件（进程无法访问该文件，因为该文件正由另一个进程使用。） [英] Backup db file due to Operating system error 32(The process cannot access the file because it is being used by another process.)

问题描述

大家好：

 我有一个执行简单数据库备份的备份作业：使用init备份数据库xyz到disk ='F：\DailyBackup \ xyz.bak'。我把它包装成一个 

  I have a backup job that does simple db backup: backup database xyz to disk ='F:\DailyBackup\xyz.bak' with init . I've wrapped it into a 

计划工作，并在晚上每天运行。然而，从上个月早些时候开始，这项工作偶尔失败了，

schedule job and have it run on a daily basis in the evening. However, starting earlier last month , this job failed sporadically, 

有时，它成功了一天，但第二天失败了。错误消息如下：

sometimes, it succeeded one day but the next day failed. Error msg is below:

无法打开备份设备'F：\DailyBackup\xyz.bak'。操作系统错误32（该进程无法访问该文件，因为它正由另一个进程使用。）。 

Cannot open backup device 'F:\DailyBackup\xyz.bak'. Operating system error 32(The process cannot access the file because it is being used by another process.). 

我用Google搜索有人建议这将是msft后卫杀毒软件。与安全部门确认，他们每周只运行一次防御者。

I've googled and someone suggested it would be msft defender antivirus . confirmed with security dept and they only run defender once per week.

无论如何都要确保在备份db命令之前已经切断了这个xyz.bak上的所有进程？ 

Is there anyway to make sure all process on this xyz.bak have been cut prior to the backup db command? 

谢谢

Hui

- 目前正在使用Reporting Service 2000; Visual Studio .NET 2003; Visual Source Safe SSIS 2008 SSAS 2008，SVN -

--Currently using Reporting Service 2000; Visual Studio .NET 2003; Visual Source Safe SSIS 2008 SSAS 2008, SVN --

推荐答案

Hi Hui，



请尝试按照以下步骤确定备份作业失败时访问备份文件的过程。

Hi Hui,

Please try to follow below steps to identify the process that is accessing the backup file when the backup job failed.

1.从
Microsoft网站并在您拥有备份作业的计算机上运行它。

2.然后按Ctrl + F或使用菜单选项"查找"> "查找句柄或DLL"左
3.在句柄或DLL子字符串框中，键入完整备份路径和文件名，然后单击"搜索"。 

4.Process Explorer显示当前正在访问该文件的应用程序。停止应用程序访问该文件，或在应用程序未访问该文件时运行备份。 
$


祝你好运，¥ b $ b Cathy Ji

1.Download Process Explorer from the Microsoft website and run it on the computer that you have the backup job.
2.Then press Ctrl+F or use Menu option "Find" > "Find Handle or DLL"
3.In the Handle or DLL substring box, type the full backup path and file name, then click Search. 
4.Process Explorer displays the applications that are currently accessing the file. Stop the application from accessing the file, or run the backup at a time when the application is not accessing the file. 

Best regards,
Cathy Ji

这篇关于由于操作系统错误32而导致备份db文件（进程无法访问该文件，因为该文件正由另一个进程使用。）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！