Memory configuration

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

Moderators: eddie davis, Colin Millerchip, fionag

Memory configuration

Postby swirl80 » Mon Sep 06, 2010 8:37 pm

is there a minimum amount you recommend for virtual restore? I'm testing with my test box which has 4gb of ram and hyperbacsrv.exe takes all the memory and doesn't release it unless you restart the service, is there a way to limit this?

I'm also getting intermittent restore errors. The messages say the DB has restored but get this when it trys to bring it online:
Processed 2 pages for database 'DatabaseHere', file 'DatabaseHere_log' on file 1.
RESTORE DATABASE successfully processed 1670450 pages in 460.264 seconds (28.354 MB/sec).
Msg 3167, Level 16, State 1, Line 6
RESTORE could not start database 'DatabaseHere'.
Msg 3013, Level 16, State 1, Line 6
RESTORE DATABASE is terminating abnormally.

any ideas? This happened on about 25% of DBs during my full rebuild of the test environment
Posts: 21
Joined: Thu Oct 23, 2008 4:26 pm

Postby swirl80 » Tue Sep 07, 2010 10:42 am

think i've sussed the memory issue. If you run it from a script its fine but in order for me to get the script i launched the gui and tried to add a file, this is what consumes all the memory and doesn't release it!!!

Almost 4GB of ram gone in about 20seconds!!! The memory still doesn't release it once the application is closed and the only way i can sort it is to restart the service
Posts: 21
Joined: Thu Oct 23, 2008 4:26 pm

Postby javen » Tue Sep 07, 2010 11:31 am


This issue has been resolved in release, a technical support rep will get in contact with you to get you setup with this
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