Check Files In Use

To avoid restarting Windows after you install SQL Server 2008 R2 updates, use the Check Files in Use page to identify processes that are locking files required by the SQL Server 2008 R2 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 and read the setup log files, see How to: View and Read SQL Server Setup Log Files.

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