Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SAN disk size expansion Expand / Collapse
Author
Message
Posted Thursday, July 25, 2013 11:04 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 28, 2014 2:06 AM
Points: 42, Visits: 248
Hi,

We were trying to expand SAN disk size more than 2 TB as part our requirment. But it failed due to the limitation, NTFS can support maximum of 2 TB.
Is it so?
I am unaware such windows limitations! On the other way, how to work around and hot to expand a SAN disk more than 2 TB. Any suggesstion would be highly appreciated.

My environment is: Windows Server 2008 R2, enterprise edition
SQL Server 2008 R2, enterprise edition
6 SAN disks are configured with >1 TB to < 1.5 TB. We want to expand those SAN disks to more than 3 TB each.

Thanks!
Post #1477858
Posted Friday, July 26, 2013 12:43 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 28, 2014 2:06 AM
Points: 42, Visits: 248
Microsoft suggested solution:
-Create new 4.8TB, convert this right away to “GPT disk” during first disk initialization at Windows 2008 R2 (assign as temporal drive letter say “X”)
-Shutdown database
-Robocopy the existing L drive (1.7TB) data to new drive 4.8TB
-Dismount 1.7TB (MBR disk) from L drive
-Mount 4.8TB (GPT disk) to L drive
-Start-up database & perform application check.
I have updated the MS solution here, if anyone encounters the same situation - they can use it.

Thanks!
Post #1477873
Posted Friday, July 26, 2013 6:30 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 3:53 AM
Points: 6,196, Visits: 13,353
balasaukri (7/25/2013)
Hi,

We were trying to expand SAN disk size more than 2 TB as part our requirment. But it failed due to the limitation, NTFS can support maximum of 2 TB.
Is it so?
I am unaware such windows limitations! On the other way, how to work around and hot to expand a SAN disk more than 2 TB. Any suggesstion would be highly appreciated.

My environment is: Windows Server 2008 R2, enterprise edition
SQL Server 2008 R2, enterprise edition
6 SAN disks are configured with >1 TB to < 1.5 TB. We want to expand those SAN disks to more than 3 TB each.

Thanks!

The limitation is not down to NTFS but down to the partition type.
An MBR partition only supports up to 2TB, as already mentioned you need to set the disk up as GPT and then create your NTFS partition. See more here


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1477963
Posted Tuesday, July 30, 2013 2:41 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 28, 2014 2:06 AM
Points: 42, Visits: 248
Thank you Whittle!
Post #1478877
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse