Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

MSSQLFUN

I, Rohit Garg, am working as Consultant in IT Company. I am having an around 5 years of experience in MSSQL server & other Microsoft technologies. I am working as DBA in Microsoft SQL Server from last 5 years in e-Commerce, Telecom, Finance domain. In this tenure, I got a chance of working as Database administrator, Developer and trainer on SQL server 2000 to SQL Server 2012. I am holding Master’s degree in Computer Science along with certification in SQL Server & .Net. I like to learn new things by hand-on experience on regular basis. This journey is so far is delightful & valuable with the addition of wonderful friends.

How to avoid windows REBOOT after any operation required restart ?

Issue :

Today, I decided to clear my desktop. I am currently running with around 10 SQL server instances with different names & versions, that I have created for different purpose & not required now.

I start uninstallation of SQL server but after one uninstallation, second uninstallation gives errors of “Restart Computer”.

It’s very difficult to restart computer again & again when you are doing several things in parallel.

Resolution :

Here, I go for shortcut. I have changed the registry value of current session manager to avoid reboot.

Go to Registry Location : HKEY_LOCAL_MACHINESYSTEMCurrentControlSetControlSessionManager & Clear the entry of string PendingFileRenameOperations.

After change, I click on rerun to check status again for uninstallation & it works.

Note :

1) Its recommended to reboot system, whenever required.

2) Please be careful, while doing any changes to registry.


Comments

Leave a comment on the original post [mssqlfun.com, opens in a new window]

Loading comments...