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

250GB Drive size limit question Expand / Collapse
Author
Message
Posted Wednesday, January 30, 2013 3:42 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 5:54 AM
Points: 40, Visits: 259
Hi all,

We provide database support for a client who are planning an AX deployment to a cloud provider. The issue I see is the expected size of the databse will reach 1 terrabyte (anticipated in first 12-24 months). Currently the cloud provider has a max presentable disk size of 250GB. I see 2 strategies:
1. Multiple datafiles of 250GB.
2. Using a windows dynamic drive to make multiple 250GB drives appear as a much larger drive(theoretically capable of housing fils larger than 250GB).

The question is how does SQL treat such a dynamic drive. Can it create files of larger than 250GB if that is the maximum underlying presented disk size. The cloud provider says yes, 250GB plus files can be created - but what is actually happening under the hood? My suspicion is that capping data file size at 250GB is the safer route. Does anyone have any input on this?

Ta,

Rob
Post #1413786
Posted Monday, February 04, 2013 5:40 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 5:54 AM
Points: 40, Visits: 259
Hi All,

I have reposted this question here:

http://www.sqlservercentral.com/Forums/Topic1415539-2799-1.aspx
Post #1415540
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse