SQL Stuff

Adding Drive Space – Extending Disks From OS ( Spanned Volume ) on SQL Server Datacenter Server in AWS.

We used this method after the space was added via AWS. Once a drive was added to the OS, we first Initialized the Disk, and while the disk was still ‘unallocated’; go to the drive you want to expand, and right-click and select ‘Extend Volume’. We did this on the SQL Server Database Server Configured with AlwaysOn Failover Cluster within AWS. Server Version: Server 2008 R2 Datacenter – Windows 6.1.7601 Service Pack 1 Build 7601. Drives were added, and expanded on both nodes (INTE-SQLA-01 & INTE-SQLA-02) This was a safe no-risk operation, and did not cause any downtime for Services, or Databases. Below are the steps performed during this process. The drive we wish to extend is the SQL Log Drive ( Drive L: ). First thing you do is right-click the left pane of the new disk and select ‘Initialize Drive’. The following steps show this process. Go to Start à Run, and type in ‘diskmgmt.msc’. Once the new disk has been added, simply right-click and select ‘Initialize’.

On the following prompt keep the default settings, and Click ‘OK’.

Once it’s completed it will simply display as ‘Online’, and remain in an ‘Unallocated’ state.

Go back to the original Drive you wish to extend ( Drive L: ) and right-click. Select ‘Extend Volume’.

Click ‘Next’ on the following prompt.

Select the disk on the left, and click ‘Add’, then ‘Next’.

Click ‘Finish’ and you’re done.

The new disks are now ‘Spanned Volumes’ and will be represented in Purple under Disk Management.  When viewed from Windows Explorer; you will see the drive as 250GB.

Advertisements

Categories: SQL Stuff

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s