Red Gate forums :: View topic - Compressed vs. uncompressed sizes
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Storage Compress 5
SQL Storage Compress 5 forum

Compressed vs. uncompressed sizes

Search in SQL Storage Compress 5 forum
Post new topic   Reply to topic
Jump to:  
Author Message
lfagetti



Joined: 30 Mar 2006
Posts: 13

PostPosted: Thu Sep 16, 2010 9:49 pm    Post subject: Compressed vs. uncompressed sizes Reply with quote

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
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 940
Location: Red Gate Software

PostPosted: Wed Sep 29, 2010 3:13 pm    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
cnilsson



Joined: 16 Sep 2009
Posts: 6

PostPosted: Fri Jun 17, 2011 9:20 am    Post subject: Compressed sizes Reply with quote

You could always use xp_cmdshell and DIR from within SQL to view the sizes of the files on disk.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic 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