vldf file grows and grows?

SQL Virtual Restore: Rapidly mount live, fully functional databases direct from backups

Moderators: eddie davis, Colin Millerchip, fionag

vldf file grows and grows?

Postby nathanj » Wed Mar 16, 2011 11:03 am

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?
nathanj
 
Posts: 1
Joined: Wed Mar 16, 2011 10:46 am

Postby javen » Mon Mar 21, 2011 10:24 pm

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
javen
 
Posts: 50
Joined: Tue May 25, 2010 12:10 am


Return to SQL Virtual Restore 2

Who is online

Users browsing this forum: No registered users and 0 guests