Thursday, 30 April 2015

How to avoid reboot Physical Server during install SQL Server if required?

Hi All We have seen so many time when ever install SQL Server sometimes SQL Setup ask required reboot Physical Server else you can't go ahead with installltion becuse next button get disable. So if its a critical server or you don't want to reboot this server but SQL Server installation also very important you cant wait for long so how can you proceed.

Here is a one hack that you can use but make sure this is not suggested but sometime we use undocumented command as well in SQL server so in critical time we can go ahead .

So how we can avoid this without reboot the server see below :-

Step 1:-

Required Reboot Server





















I followed the following steps to solve this problem,
1. Run Regedit.exe on Run.
2. Go to, HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SessionManager , and Select"Session Manager, and you will see the entry called, PENDING FILE RENAME OPERATION.
3. Take backup of registry value first.
4. Then, If PENDING FILE RENAME OPERATION has any values just remove it and clear the value.

See below screen shot for more info :- 
2. Go to, HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SessionManager , 
"PENDING FILE RENAME OPERATION."

If now you can go back the same installation windows and Click  on Re-run button you will see that reboot required will gone  and you can go ahead with installation without without reboot whole server.






1 comment:

  1. Casino - Dr.MCD
    Casino. Located in 순천 출장마사지 the heart of Las Vegas, 제천 출장안마 it is considered among the best hotels 포항 출장샵 in the country by 부산광역 출장안마 travelers who want to experience a little Vegas  Rating: 경주 출장샵 3.5 · ‎3 votes

    ReplyDelete