Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Error when running SQL DTA "The minimum storage space require for the existing physical design structures......"

Posted on 2012-08-13
Medium Priority
Last Modified: 2012-08-20
When I run the SQL DTA against a set of queries that a report calls I get the attached message. It states that if I set the storage space to be larger than 72057594037946064 MB it will work.

DTA Error
Obviously this is completely impractical and i can't see how this is anything other than a glitch in the software. I have set it to 128MB currently.

I have seen many people have encountered this error, but this is overcome by setting the value in the Tuning defaults. Obviously given the high value this will not be possible.

Thank you in advance for your help!!
Question by:delkent
1 Comment
LVL 16

Accepted Solution

EvilPostIt earned 2000 total points
ID: 38291611
Microsoft have a kb fix for this. Please see the below link.


Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Integration Management Part 2
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question