Post reply

Restore database error - The process cannot access the file because it is being used by another process.)' while attempting 'OpenFile' on 'J:\Mssql2008R2\FTData\Product_FT\MssearchCatalogDir\0001000C.ci'.

  • September 20, 2010 at 8:00 am

    #226585

    Using SQL 2008 R2 Enterprise. I've got a job that restores a database every night that fails on occasion. The restore starts fine, goes up to 100% but at the very end, fails with the following error.

    The operating system returned the error '32(The process cannot access the file because it is being used by another process.)' while attempting 'OpenFile' on 'J:\Mssql2008R2\FTData\Product_FT\MssearchCatalogDir\0001000C.ci'. RESTORE DATABASE is terminating abnormally.

    I have no idea what can be using this file. When I run the restore again, it is usually fine. I've turned off the FULL TEXT service and it still failed.

    Any ideas?

    Thanks,

    STeven

  • September 20, 2010 at 8:23 am

    #1224053

    The file may be in middle of copy and hence u got this error.

    if not, take help of windows admin guys who can find the handle to the process that is using that file using tools like process explorer and others.


    Pradeep Singh

  • September 20, 2010 at 10:40 am

    #1224196

    You may use perfmon to find out which process is accessing that file. An example here[/url]

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • September 20, 2010 at 2:37 pm

    #1224385

    My guess would be your tape backup is happening at that time.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • September 21, 2010 at 1:06 am

    #1224571

    Yes i happned to encounter a similar tape backup and also sometime the AV locking the files.

  • September 21, 2010 at 2:19 am

    #1224605

    Adiga (9/20/2010)

    You may use perfmon to find out which process is accessing that file. An example here[/url]

    Good writeup. but i guess u did a typo by writing perfmon instead of process explorer:-P


    Pradeep Singh

  • September 21, 2010 at 7:18 am

    #1224786

    Not backups, I checked that one, but Antivirus, maybe. I'll have to check that one.

    Thanks for all your suggestions.

  • December 31, 2014 at 1:23 pm

    #1767282

    I had restart mssql instance and server also and change that file also but getting solution

  • January 2, 2015 at 6:10 am

    #1767376

    Does your database use Full TEXT SEARCH?

  • January 2, 2015 at 11:34 am

    #1767456

    yes it is use full text search...

  • January 2, 2015 at 11:39 am

    #1767459

    @pradip, i am restoring backup on another serverr but still samee is comming.. can tell specific reason.

  • January 5, 2015 at 2:45 am

    #1767692

    Looks like you are trying to restore the same Full Text Search file, Change the File name in the restore options.

  • January 5, 2015 at 3:51 am

    #1767700

    i had tried with differnt file namebut it is not working

  • January 5, 2015 at 8:35 am

    #1767800

    This is an FTS issue, change the drive and folder that the FTS file for the database is going to. Try and put it on the same drive and folder as the MDF file. See if that works.

Viewing 14 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy