Sunday, December 29, 2013

The action can’t be completed because the file is open in SQL SERVER

12 comments
Some time while moving a database (.mdf) from one location to other location on hard disk drive you encounter with the error ‘The action can’t be completed because the file is open in SQL SERVER(MSSQLSERVER) ‘ as shown in the diagram below:

The action can’t be completed because the file is open in SQL SERVER

Steps to solve error ‘The action can’t be completed because the file is open in SQL SERVER’ as shown in below:
Step 1: Click on Start Icon on the task bar . Select Microsoft SQL Server folder and then click on SQL Server Configuration Manager as shown in the picture below:

The action can’t be completed because the file is open in SQL SERVER

Step 2: SQL SERVER Configuration Manger window  will open on the left side of this window select SQL Server Services . In SQL server services  right click on the service SQL Server (MSSQLSERVER) and click on Stop as shown in the picture below:

The action can’t be completed because the file is open in SQL SERVER



Step 3: As the process will stop move the file from one location to other and then again start this process by right click on it.

12 comments:

  1. Thanks worked for me too.... :)

    ReplyDelete
  2. Thank you very much good sir - You Rock!!

    ReplyDelete
  3. thanks so much worked perfect for me
    Allan

    ReplyDelete
    Replies
    1. Worked in no time, You ae awesome guys.. Keep it up.. Thanks a lot

      Delete
  4. Happiness fills me up :) Thanks

    ReplyDelete