| Author |
Message |
lfagetti
Joined: 30 Mar 2006
Posts: 13
|
 Posted: Thu Sep 16, 2010 9:49 pm Post subject: Compressed vs. uncompressed sizes |
 |
|
Hello,
all SQL based commands are showing the uncompressed size.
Only way I see to check compressed size (real allocated disk space) with Db files open is to check the files properties on the drive.
Any other way?
Thanks! |
|
| Back to top |
|
 |
eddie davis
Joined: 14 Jun 2006
Posts: 796
Location: Red Gate Software
|
| Posted: Wed Sep 29, 2010 3:13 pm Post subject: |
|
|
Thank you for your post into the forum.
SQL Server is totally unaware of SQL Storage Compress or HyperBac processes being performed on the database files. So SQL Server will always believe that the database file sizes are the real uncompressed sizes.
The only to check the actual compressed file sizes is to look at the properties for the actual files.
Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com |
|
| Back to top |
|
|
cnilsson
Joined: 16 Sep 2009
Posts: 6
|
| Posted: Fri Jun 17, 2011 9:20 am Post subject: Compressed sizes |
|
|
| You could always use xp_cmdshell and DIR from within SQL to view the sizes of the files on disk. |
|
| Back to top |
|
|
|
|
All times are GMT + 1 Hour
|
| Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
