SQL Server by SQL

What is SQL Server?

Read more

Overview

---

How do I clean SQL Server?

SQL Server may store excess, temporary data on your computer that can take up valuable space. It may also store private data such as passwords or browsing history in the registry or on the file system. The easiest way to erase this data is by downloading AppCleaner, it is 100% free and about 1MB in size. A portable version is also available.

Clean SQL Server
with AppCleaner

If you want to clean SQL Server manually, you can follow the steps outlined below. There are four locations in the file system where SQL Server stores data that can be cleaned. Additionally, SQL Server stores private data in sixteen registry keys.

Registry

To clean the registry from data stored by SQL Server, you can use the Microsoft Registry Editor (regedit.exe) which is installed by default on all Windows operating systems. First of all, open regedit.exe by carrying out these steps:

• Hit the Windows key , usually located in the lower left of your keyboard between the Ctrl and Alt keys.
• Windows XP/Vista/7: Click Run...
• Type regedit.exe
• Hit Enter

Now use regedit.exe to delete the registry keys:

1. • Expand HKEY_CURRENT_USER from the root of the tree in the left pane.
   • Expand Software.
   • Expand Microsoft.
   • Expand Microsoft SQL Server.
   • Expand 80.
   • Expand Tools.
   • Expand Shell.
   • Right-click FileMRUList.
   • Choose Delete from the context menu.
   • Click Yes.
2. • Expand HKEY_CURRENT_USER from the root of the tree in the left pane.
   • Expand Software.
   • Expand Microsoft.
   • Expand Microsoft SQL Server.
   • Expand 80.
   • Expand Tools.
   • Expand Shell.
   • Right-click ProjectMRUList.
   • Choose Delete from the context menu.
   • Click Yes.
3. • Expand HKEY_CURRENT_USER from the root of the tree in the left pane.
   • Expand Software.
   • Expand Microsoft.
   • Expand Microsoft SQL Server.
   • Expand 90.
   • Expand Tools.
   • Expand Shell.
   • Right-click FileMRUList.
   • Choose Delete from the context menu.
   • Click Yes.
4. • Expand HKEY_CURRENT_USER from the root of the tree in the left pane.
   • Expand Software.
   • Expand Microsoft.
   • Expand Microsoft SQL Server.
   • Expand 90.
   • Expand Tools.
   • Expand Shell.
   • Right-click ProjectMRUList.
   • Choose Delete from the context menu.
   • Click Yes.
5. • Expand HKEY_CURRENT_USER from the root of the tree in the left pane.
   • Expand Software.
   • Expand Microsoft.
   • Expand Microsoft SQL Server.
   • Expand 100.
   • Expand Tools.
   • Expand Shell.
   • Right-click FileMRUList.
   • Choose Delete from the context menu.
   • Click Yes.
6. • Expand HKEY_CURRENT_USER from the root of the tree in the left pane.
   • Expand Software.
   • Expand Microsoft.
   • Expand Microsoft SQL Server.
   • Expand 100.
   • Expand Tools.
   • Expand Shell.
   • Right-click ProjectMRUList.
   • Choose Delete from the context menu.
   • Click Yes.
7. • Expand HKEY_CURRENT_USER from the root of the tree in the left pane.
   • Expand Software.
   • Expand Microsoft.
   • Expand Microsoft SQL Server.
   • Expand 110.
   • Expand Tools.
   • Expand Shell.
   • Right-click ProjectMRUList.
   • Choose Delete from the context menu.
   • Click Yes.
8. • Expand HKEY_CURRENT_USER from the root of the tree in the left pane.
   • Expand Software.
   • Expand Microsoft.
   • Expand Microsoft SQL Server.
   • Expand 110.
   • Expand Tools.
   • Expand Shell.
   • Right-click FileMRUList.
   • Choose Delete from the context menu.
   • Click Yes.
9. • Expand HKLM from the root of the tree in the left pane.
   • Expand Software.
   • Expand Microsoft.
   • Expand Microsoft SQL Server.
   • Expand 80.
   • Expand Tools.
   • Expand Shell.
   • Right-click FileMRUList.
   • Choose Delete from the context menu.
   • Click Yes.
10. • Expand HKLM from the root of the tree in the left pane.
    • Expand Software.
    • Expand Microsoft.
    • Expand Microsoft SQL Server.
    • Expand 80.
    • Expand Tools.
    • Expand Shell.
    • Right-click ProjectMRUList.
    • Choose Delete from the context menu.
    • Click Yes.
11. • Expand HKLM from the root of the tree in the left pane.
    • Expand Software.
    • Expand Microsoft.
    • Expand Microsoft SQL Server.
    • Expand 90.
    • Expand Tools.
    • Expand Shell.
    • Right-click FileMRUList.
    • Choose Delete from the context menu.
    • Click Yes.
12. • Expand HKLM from the root of the tree in the left pane.
    • Expand Software.
    • Expand Microsoft.
    • Expand Microsoft SQL Server.
    • Expand 90.
    • Expand Tools.
    • Expand Shell.
    • Right-click ProjectMRUList.
    • Choose Delete from the context menu.
    • Click Yes.
13. • Expand HKLM from the root of the tree in the left pane.
    • Expand Software.
    • Expand Microsoft.
    • Expand Microsoft SQL Server.
    • Expand 100.
    • Expand Tools.
    • Expand Shell.
    • Right-click FileMRUList.
    • Choose Delete from the context menu.
    • Click Yes.
14. • Expand HKLM from the root of the tree in the left pane.
    • Expand Software.
    • Expand Microsoft.
    • Expand Microsoft SQL Server.
    • Expand 100.
    • Expand Tools.
    • Expand Shell.
    • Right-click ProjectMRUList.
    • Choose Delete from the context menu.
    • Click Yes.
15. • Expand HKLM from the root of the tree in the left pane.
    • Expand Software.
    • Expand Microsoft.
    • Expand Microsoft SQL Server.
    • Expand 110.
    • Expand Tools.
    • Expand Shell.
    • Right-click FileMRUList.
    • Choose Delete from the context menu.
    • Click Yes.
16. • Expand HKLM from the root of the tree in the left pane.
    • Expand Software.
    • Expand Microsoft.
    • Expand Microsoft SQL Server.
    • Expand 110.
    • Expand Tools.
    • Expand Shell.
    • Right-click ProjectMRUList.
    • Choose Delete from the context menu.
    • Click Yes.

Files

To clean your file system from files stored by SQL Server and to gain free disk space, examine the following file system locations. First of all, open a command prompt window:

• Hit the Windows key , usually located in the lower left of your keyboard between the Ctrl and Alt keys.
• Windows XP/Vista/7: Click Run...
• Type cmd
• Hit Enter

Now list all the files stored by SQL Server that can be cleaned:

1. Type dir %ProgramFiles%\Microsoft SQL Server\*
   • On 64-Bit also: Type dir %ProgramFiles(x86)%\Microsoft SQL Server\*
2. For all the folders that were listed in the previous step:
   Type dir /s {folder}\Setup Bootstrap\LOG\* where {folder} is one of the folders listed in the previous step.
3. Type dir %LOCALAPPDATA%\VirtualStore\Program Files*
   • Windows XP: Type dir %USERPROFILE%\Local Settings\Application Data\VirtualStore\Program Files*
4. For all the folders that were listed in the previous step:
   Type dir {folder}\Microsoft SQL Server\* where {folder} is one of the folders listed in the previous step.
5. For all the folders that were listed in the previous step:
   Type dir /s {folder}\Setup Bootstrap\LOG\* where {folder} is one of the folders listed in the previous step.
6. Type dir %ProgramFiles%\Microsoft SQL Server\*
   • On 64-Bit also: Type dir %ProgramFiles(x86)%\Microsoft SQL Server\*
7. For all the folders that were listed in the previous step:
   Type dir /s {folder}\MSSQL\Log\*ERRORLOG* where {folder} is one of the folders listed in the previous step.
8. Type dir %ProgramFiles%\Microsoft SQL Server\*
   • On 64-Bit also: Type dir %ProgramFiles(x86)%\Microsoft SQL Server\*
9. For all the folders that were listed in the previous step:
   Type dir /s {folder}\MSSQL\Log\* where {folder} is one of the folders listed in the previous step.
10. Type dir %LOCALAPPDATA%\VirtualStore\Program Files*
    • Windows XP: Type dir %USERPROFILE%\Local Settings\Application Data\VirtualStore\Program Files*
11. For all the folders that were listed in the previous step:
    Type dir {folder}\Microsoft SQL Server\* where {folder} is one of the folders listed in the previous step.
12. For all the folders that were listed in the previous step:
    Type dir /s {folder}\MSSQL\Log\*ERRORLOG* where {folder} is one of the folders listed in the previous step.
13. Type dir %LOCALAPPDATA%\VirtualStore\Program Files*
    • Windows XP: Type dir %USERPROFILE%\Local Settings\Application Data\VirtualStore\Program Files*
14. For all the folders that were listed in the previous step:
    Type dir {folder}\Microsoft SQL Server\* where {folder} is one of the folders listed in the previous step.
15. For all the folders that were listed in the previous step:
    Type dir /s {folder}\MSSQL\Log\* where {folder} is one of the folders listed in the previous step.

Once you have identified the files stored by SQL Server that you want to clean, delete them using the del command or Windows Explorer.

0 Comments