Red Gate forums :: View topic - Why large initial vmdf/vldf-files?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Virtual Restore 2
SQL Virtual Restore 2 forum

Why large initial vmdf/vldf-files?

Search in SQL Virtual Restore 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
fgsimon



Joined: 21 May 2012
Posts: 18

PostPosted: Mon May 21, 2012 1:04 pm    Post subject: Why large initial vmdf/vldf-files? Reply with quote

Hi all,
We are getting vmdf 400GB and vldf 20GB, when makeing a Virtual Restore Database from a Hyperbac-backed Database of an 8GB compressed database backup file..

I can't help feeling that our v-files are way too large, right after restoring.. what are your thoughts?
How large are your v-files, generally?

Thank's,
Simon
Back to top
View user's profile Send private message
RajK



Joined: 02 Feb 2012
Posts: 58

PostPosted: Wed May 23, 2012 2:35 pm    Post subject: Reply with quote

I am investigating this as part of the support case raised with us.

SVR should normally have a footprint of less than 10 percent of the database backup size.

I will post an update here when the investigation is complete. Thanks for your patience and feedback in this matter.
Back to top
View user's profile Send private message
fgsimon



Joined: 21 May 2012
Posts: 18

PostPosted: Thu May 24, 2012 9:55 am    Post subject: Re: Reply with quote

RajK wrote:
I am investigating this as part of the support case raised with us.

SVR should normally have a footprint of less than 10 percent of the database backup size.

I will post an update here when the investigation is complete. Thanks for your patience and feedback in this matter.


Thank's! Apoplogies for my typo, I meant MB, not GB: vmdf 400MB and vldf 20MB. Perhaps that is what can be expected?
Back to top
View user's profile Send private message
RajK



Joined: 02 Feb 2012
Posts: 58

PostPosted: Wed May 30, 2012 12:55 pm    Post subject: Reply with quote

As mentioned in the support email thread I am just posted the response in this forum post.

In regards to the sizes you have reported:

”Another question: when making a virtual restore from a hyperbac in zip-format, the vmdf file is 435MB, is that not very big for an initial size? (The vldf is 37MB. The zip is 8GB and the original mdf/ldf are 36.5Gb/3.4Gb.)”

The ratio of comparison is actually quite good. This roughly translates to less than 10% disk space footprint.

I am not sure if we can optimise any further than that.

Thanks for your patience and feedback in this matter.
Back to top
View user's profile Send private message
fgsimon



Joined: 21 May 2012
Posts: 18

PostPosted: Wed May 30, 2012 12:56 pm    Post subject: Re: Reply with quote

OK, I was not sure what size files to expect. thank you for your response.
/Simon
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