Check Files In Use
To avoid restarting Windows after you install SQL Server updates, use the Check Files in Use page to identify processes that are locking files required by the SQL Server 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 SQL Server Data Tools (SSDT).
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.
The following information is included in the log file:
Name of the process
Name of the SQL Server feature
Account under which the process is running
Name of the file that is locked
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.
Displays the process ID.