patternsqlModerate
SSMS Disk usage reports reports no data file for online database
Viewed 0 times
reportsfilessmsdiskonlinedatabaseusagefordata
Problem
We have a rather large database running on SQL Server 2012. The data file is now 2 118 256 MB. For a couple of weeks now, whenever I run the SSMS report Disk Usage, it says at the very bottom that "There is no data file for MyDatabase database."
Anyone seen this before? The database is up and running. Is there a size constraint on what this report will show?
Anyone seen this before? The database is up and running. Is there a size constraint on what this report will show?
Solution
Yes, this report fails when the database is over 2 TB.
See this connect item: SQL Server Management Studio Standard Reports - Disk Usage
Create a new 2 TB database and run the Disk Usage report to display
results.
For Disk Space Used by Data Files, rather than displaying the Filegroup Name, Logical File Name, Physical File Name, Space Reserved,
Space Used, I get a message of "There is no data file for
database."
See this connect item: SQL Server Management Studio Standard Reports - Disk Usage
Create a new 2 TB database and run the Disk Usage report to display
results.
For Disk Space Used by Data Files, rather than displaying the Filegroup Name, Logical File Name, Physical File Name, Space Reserved,
Space Used, I get a message of "There is no data file for
database."
Context
StackExchange Database Administrators Q#183609, answer score: 11
Revisions (0)
No revisions yet.