none
Warning: The process cannot access the file because it is being used by another process

    Question

  • Hi Guys,

    I am running SLQ 2008 R2 and I am getting the following warning when the Commvault tries to backup the SQL server database:

    # C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\MSDBData.mdf] The process cannot access the file because it is being used by another process.
    # [C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\MSDBLog.ldf] The process cannot access the file because it is being used by another process.
    # [C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\SunSystemsData.mdf] The process cannot access the file because it is being used by another process.
    # [C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\SunSystemsData_1.ldf] The process cannot access the file because it is being used by another process.
    # [C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\SunSystemsQA.MDF] The process cannot access the file because it is being used by another process.
    # [C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\SunSystemsQA_1.LDF] The process cannot access the file because it is being used by another process.
    # [C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\SunSystemsSecurity.mdf] The process cannot access the file because it is being used by another process.
    # [C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\SunSystemsSecurity_1.LDF] The process cannot access the file because it is being used by another process.
    # [C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf] The process cannot access the file because it is being used by another process.
    # [C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mastlog.ldf] The process cannot access the file because it is being used by another process.
    # [C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\model.mdf] The process cannot access the file because it is being used by another process.
    # [C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\modellog.ldf] The process cannot access the file because it is being used by another process.
    # [C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\tempdb.mdf] The process cannot access the file because it is being used by another process.
    # [C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\templog.ldf] The process cannot access the file because it is being used by another process.
    # [C:\Users\admin_tomgorgis\AppData\Local\Microsoft\Windows\UsrClass.dat.LOG1] The process cannot access the file because it is being used by another process.
    # [C:\Users\admin_tomgorgis\AppData\Local\Microsoft\Windows\UsrClass.dat.LOG2] The process cannot access the file because it is being used by another process.
    # [C:\Users\admin_tomgorgis\ntuser.dat.LOG1] The process cannot access the file because it is being used by another process.
    # [C:\Users\admin_tomgorgis\ntuser.dat.LOG2] The process cannot access the file because it is being used by another process.
    # [C:\Users\sunadmin\AppData\Local\Microsoft\Windows\UsrClass.dat.LOG1] The process cannot access the file because it is being used by another process.
    # [C:\Users\sunadmin\AppData\Local\Microsoft\Windows\UsrClass.dat.LOG2] The process cannot access the file because it is being used by another process.
    # [C:\Users\sunadmin\AppData\Roaming\Microsoft\CLR Security Config\v2.0.50727.312\security.config.cch.3764.1240113224] Access is denied.
    # [C:\Users\sunadmin\ntuser.dat.LOG1] The process cannot access the file because it is being used by another process.
    # [C:\Users\sunadmin\ntuser.dat.LOG2] The process cannot access the file because it is being used by another process.
    # [C:\Windows\Microsoft.NET\Framework64\v2.0.50727\CONFIG\enterprisesec.config.cch.5940.1242344460] Access is denied.
    # [C:\Windows\Microsoft.NET\Framework64\v2.0.50727\CONFIG\security.config.cch.5940.1242344460] Access is denied.
    # [C:\Windows\Microsoft.NET\Framework\v2.0.50727\CONFIG\enterprisesec.config.cch.3764.1240113224] Access is denied.
    # [C:\Windows\Microsoft.NET\Framework\v2.0.50727\CONFIG\security.config.cch.3764.1240113224] Access is denied.
    # [C:\Windows\ServiceProfiles\LocalService\AppData\Local\lastalive0.dat] The process cannot access the file because it is being used by another process.
    # [C:\Windows\ServiceProfiles\LocalService\AppData\Local\lastalive1.dat] The process cannot access the file because it is being used by another process.
    # [C:\Windows\ServiceProfiles\LocalService\NTUSER.DAT.LOG1] The process cannot access the file because it is being used by another process.
    # [C:\Windows\ServiceProfiles\LocalService\NTUSER.DAT.LOG2] The process cannot access the file because it is being used by another process.
    # [C:\Windows\ServiceProfiles\NetworkService\NTUSER.DAT.LOG1] The process cannot access the file because it is being used by another process.
    # [C:\Windows\ServiceProfiles\NetworkService\NTUSER.DAT.LOG2] The process cannot access the file because it is being used by another process.
    # [C:\Windows\System32\7B296FB0-376B-497e-B012-9C450E1B7327-5P-0.C7483456-A289-439d-8115-601632D005A0] The process cannot access the file because it is being used by another process.
    # [C:\Windows\System32\7B296FB0-376B-497e-B012-9C450E1B7327-5P-1.C7483456-A289-439d-8115-601632D005A0] The process cannot access the file because it is being used by another process.
    # [C:\Windows\System32\SMI\Store\Machine\SCHEMA.DAT.LOG1] The process cannot access the file because it is being used by another process.
    # [C:\Windows\System32\config\COMPONENTS.LOG1] The process cannot access the file because it is being used by another process.
    # [C:\Windows\System32\config\COMPONENTS.LOG2] The process cannot access the file because it is being used by another process.
    # [C:\Windows\System32\config\RegBack\DEFAULT] The process cannot access the file because it is being used by another process.
    # [C:\Windows\System32\config\RegBack\SAM] The process cannot access the file because it is being used by another process.
    # [C:\Windows\System32\config\RegBack\SECURITY] The process cannot access the file because it is being used by another process.
    # [C:\Windows\System32\config\RegBack\SOFTWARE] The process cannot access the file because it is being used by another process.
    # [C:\Windows\System32\config\RegBack\SYSTEM] The process cannot access the file because it is being used by another process.

    Thanks.

    Wednesday, February 15, 2012 11:44 PM

Answers

  • Looks like you are trying to backup database files, not the database itself.

    Backup software needs to be aware of the database, not a bunch of files. You have to work with backup solution vendor to configure it correctly.

    If you have to do "cold" backup of the files (not recommended), follow these steps:

    1. Stop SQL Server instance

    2. Run file system backup.

    3. Start SQL Server instance.

    http://www.commvault.com/solutions-microsoft-sql-server.html


    • Edited by Piotr Palka Thursday, February 16, 2012 5:02 AM
    • Proposed as answer by Eileen Zhao Friday, February 17, 2012 3:20 PM
    • Marked as answer by Eileen Zhao Thursday, February 23, 2012 7:05 AM
    Thursday, February 16, 2012 5:02 AM