Red Gate forums :: View topic - VirtualDiskSize parameter does not work to prevent Msg 3257
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

VirtualDiskSize parameter does not work to prevent Msg 3257

Search in SQL Storage Compress 5 forum
Post new topic   Reply to topic
Jump to:  
Author Message
timh@ucn.net



Joined: 18 Jul 2006
Posts: 3

PostPosted: Thu Sep 16, 2010 1:33 am    Post subject: VirtualDiskSize parameter does not work to prevent Msg 3257 Reply with quote

I followed the steps by adding the line in the Hyperbac.conf file and restarted the service. The log showed that it read the parameter but the new amount of 1500GB was not reported to SQL Server (2000 SP4). I changed the value to 100, restarted the service and the actual amount available was still reported.
Back to top
View user's profile Send private message
eddie davis



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

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

Thank you for your post into the forum and sorry for the delay in replying.

I little confused by your post.

I suspect one of two things may have occurred, regarding the VirtualDiskSize parameter:

1. The value given to the VirtualDiskSize parameter is too small so a bigger value needs to be set.

OR

2. Even when you set the VirtualDiskSize parameter, the actual amount of free disk space available is still insufficient to create the database compressed files.

Another possibilty is that when you view the properties of the database, SQL still reports the files sizes as the orignal size.

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
timh@ucn.net



Joined: 18 Jul 2006
Posts: 3

PostPosted: Tue Oct 19, 2010 4:18 pm    Post subject: Reply with quote

We received a patched version and the parameter now works as stated in the documentation. The patch also took care of an issue where SQL Storage Compress was licensed but not the underlying Hyberbac which expired after two weeks.
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