Counter of Festivals

Ashok Blog for SQL Learners and Beginners and Experts

Friday, 27 January 2017

How to Avoid/Escape a server reboot while installing SQL Server 2008 R 2 or SQL Installation Fail situation?

Avoid a server reboot while installing SQL Server 2008 R 2?


If you are in a situation that you need not want server to be rebooted after SQL Server 2008 R 2 install,then follow the below steps
You can bypass the “Restart computer” rule when installing SQL Server 2008 r 2 and work around this by following these steps:
1. Open Registry Editor. Click Start –> Run, input “reg edit” and press Enter.
2. Go to H KEY_LOCAL_MACHINE\SYSTEM\Current Control Set\Control\Session Manager, and delete any value in “Pending File Rename Operations” key.
Scenario:
if you want to install SQL Server 2008 R 2 but it is holding more applications we can not offered any down time at all that time if your installation of any setup file fails it asks restart we can not proceed further uninstall existing file or install SQL new setup file so we need to follow above steps to avoid restart system and we can just install SQL new setup file without uninstall existing file.

Here you can see some files fails due to setup file corrupted or file missing as P F B 
(Please Find Below)

so it requires restart of system



If you are in a situation that you need not want server to be rebooted after SQL Server 2008 R2 install,then follow the below steps
You can bypass the “Restart computer” rule when installing SQL Server 2008 r 2 and work around this by following these steps:
1. Open Registry Editor. Click Start –> Run, input “reg edit” and press Enter.
2. Go to H KEY_LOCAL_MACHINE\SYSTEM\Current Control Set\Control\Session Manager, and delete any value in “Pending File Rename Operations” key.



In the above Pending File Rename operations just select all and copy it to notepad (for just reference for future use) and remove all text and save it and close the reg edit

now you can continue with new file setup to proceed further it did not ask any restart system 




That is it

Keep Blogging and Reading