Check Files In Use

To avoid restarting Windows after you install SQL Server 2008 updates, use the Check Files in Use page to identify processes that are locking files required by the SQL Server 2008 update Setup program.

Stop all applications and services that make connections to the instances of SQL Server that are being updated. This includes stopping SQL Server Management Studio and Business Intelligence Development Studio.

If Setup determines that files are locked during installation, you might have to restart your computer after installation is completed. If necessary, Setup prompts you to restart your computer. If the Setup program must stop a service during installation, it will restart the service after installation is completed.

To eliminate the requirement to restart your computer after installation, Setup displays a list of processes that are locking files. Stop or end the processes and applications in the list. Then click Refresh check to rerun the check. Click Stop check to end a check that is running. If locked files are not found, the table is empty. When all locked processes have been closed or stopped, click Next to continue.

Setup logs the information in the log files. For more information about how to view the log files, see How to: View SQL Server Setup Log Files and How to: Read a SQL Server Setup Log File.

The following information is included in the log file:

  • Name of the process
  • Name of the SQL Server feature
  • Process type
  • Account under which the process is running
  • Process ID
  • Name of the file that is locked
Name Description


Displays the full name of the process that is using the files to be updated.


Displays the type of process.


Displays the account under which the process is running.

Process ID

Displays the process ID.