Red Gate forums :: View topic - vldf file grows and grows?
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

vldf file grows and grows?

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



Joined: 16 Mar 2011
Posts: 1

PostPosted: Wed Mar 16, 2011 11:03 am    Post subject: vldf file grows and grows? Reply with quote

I've just installed a trial SQL Virtual Restore 2.3 on one of our test servers to see whether this would be suitable in some of our dev/test environments.

From an initial footprint and restore time perspective this is looking great!

However I've done some testing on data changes and have noticed that the behaviour of the .vldf file is inconsistent with what I see with a normal database restore.

The database is mounted using Virtual Restore from a 1GB .hbc backup (~7GB uncompressed) in SIMPLE recovery mode.

If I make a data change as part of a large transaction that affects about a million records and spawns several triggers, with a NORMAL database my transaction log grows to about 2GB.

If I make the same database change with my VIRTUAL database, my .vldf file grows by approximately 2GB PER TRANSACTION. That is, if I run the process 3 times, I now have a 6GB file.

I can see no mechanism to shrink the .vldf file (A DB shrink doesn't work), so if I run this process half a dozen times I actually end up losing space compared to a full DB restore.

Is this expected behaviour?
Back to top
View user's profile Send private message
javen



Joined: 25 May 2010
Posts: 50

PostPosted: Mon Mar 21, 2011 10:24 pm    Post subject: Reply with quote

Hi, this is not normal behavior, we will need to work with you directly to investigate why this is happening in your environment
_________________
Jeffrey Aven
Product Management - HyperBac Technologies
Red Gate Software
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