:::: MENU ::::

Posts Categorized / Windows 7

  • Dec 06 / 2011
  • 0
dbDigger, Hardware and Platform, System Administration, Windows 7

How to uninstall an SQL Server instance out of multiple instances

While writing an article for MSSQLTips.com, i installed SQL Server 2005 Dev Edition and SQL Server 2005 Express Edition on Windows 7. Dev Edition was with default instance name while Express Edition was named as SQLExpress on machine. After completion of article as a clean up process, it was required to uninstall the express edition.

During this process i noticed that for new DBAs uninstalling an instance out of multiple instances may be confusing if not aware of process. In add/remove programs utility, SQL Server instances are embedded in their versions rather than separate entry for each instance. SQL Server 2005 instances are included under Microsoft SQL Server 2005 entry while SQL Server 2008 instances are included under Microsoft SQL Server 2008 entry.

Uninstall SQL Server 2005 Express edition

So here is how i uninstalled express edition and leaving the Dev edition only in SQL Server 2005 family.

  • Click on Microsoft SQL Server 2005 entry
  • On generated frame select SQL Server 2005 express instance to uninstall
  • Make sure to leave the common components unchecked

Uninstall SQL Server 2005 Express edition from Windows

Now click the Next button to continue with uninstall of selected instance of SQL Server 2005.

  • Dec 05 / 2011
  • 0
dbDigger, Storage, System Administration, Windows 7

Use DiskPart utility for disk operations in Windows

After running FDisk utility on my laptop. I created a primary partition for windows 7 installation with intention to configure extended partition later along with logical drives on it. After completing the Windows 7 installation, i opened disk management snapin.
It was a bit confusing when i found no option to create extended partition for unused disk space. I was only able to create simple volumes configured all in primary partition.

Solution

After some research i came to know that Windows 7 uses a command line utility ‘DiskPart’ for disk operations with full access. It has more operational capabilities than that of commonly used disk management snapin. It can format, create/delete partitions, etc. DiskPart is also available in Windows 2000 and XP. It should be considered that disk management snapin lacks some operations on disk to avoid any data loss. However DiskPart provides full access for any operation without any prevention from data loss. So while using DiskPart utility extreme care is required.

How to Open

Open cmd, write diskpart and press Enter. Else directly enter DiskPart in run box or search box of windows. DiskPart console would be opened.

Using DiskPart for disk operations

How to operate

DiskPart is a powerful tool and can be operated through few simple commands on console. First of all have a clear idea of what to do. Then get its commands by entering ? on diskpart console. Full list of commands would be available along with short description. Also consider online product help for any guide line. For operations select the target disk. Simple type select disk 0 (as in my case it was disk no 0) and press enter. Disk number may be get from disk management snapin.

Select disk in DiskPart utility

Creating extended partition through DiskPart

In my case i was only required to create logical partitions of all available disk space other than primary partition. I typed create partition extended and entered. Size parameter may be provided, here it converted all available space to a extended partition.

Going Back to Disk Management Snapin

Further operations of creating logical drives may be performed in disk management snapin. So to be on safe side i used disk management snapin for creating logical drives and my disk was ready to be used.

Consult us to explore the Databases. Contact us