January 30, 2013 at 3:42 pm
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
February 4, 2013 at 5:40 pm
Hi All,
I have reposted this question here:
http://www.sqlservercentral.com/Forums/Topic1415539-2799-1.aspx
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply