New 6.5 Restore Problem, Large DB restores hang

• 
  What is the size of the data file(s) and transaction log file(s) for the restored databases?
  
  Thanks.

  petey May 22, 2011 23:48

  - 0 +
• 
  I have observed this issue with data files as small as 7GB and others as large as 200GB.
  
  I suspect some sort of VDI timeout is occurring with the larger files. Also note that the files I am restoring were created with 3 threads.

  DonFerguson May 23, 2011 12:06

  - 0 +
• 
  We've also experienced this problem with a relatively large (126Gb) database. Donman's solution allows the restore to complete, but so far we've been able to repeat the problem with every restore of this particular system.
  We've upgraded to the latest version, and there's plenty of disk space etc.
  Any ideas?

  blane May 24, 2011 07:42

  - 0 +
• 
  Could you please create an entry in the registry on the SQL Server box, in
  
  HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\<InstanceName>
  
  named VDICommandTimeout (DWORD type), and enter a value of FFFFFFFF (hex)?
  
  Now try restoring the database and see if the error still occurs.
  
  Thanks.

  petey May 24, 2011 11:43

  - 0 +
• 
  Adding the VDICommandTimout Registry Key and setting it to FFFFFFFF resolves the issue. Thanks petey!

  DonFerguson May 24, 2011 13:23

  - 0 +
• 
  We are just about to upgrade from 6.4 to 6.5.0.75. Do I need to add this reg key manually to make sure that this doesn't happen or do you have a fix?
  
  Thanks
  
  Chris

  ChrisAVWood May 25, 2011 10:52

  - 0 +
• 
  We're refreshing the dataset in our test environments this weekend, so I'll have a chance to test it then.

  blane May 25, 2011 21:33

  - 0 +
• 
  I would suggest waiting for the next minor release, which addresses this issue, so that you do not need the registry workaround. It should be available soon.

  petey May 25, 2011 21:49

  - 0 +
• 
  Thanks for the update.
  
  Will the new version be broadcast on the forum as an announcement or just in this post?
  
  Chris

  ChrisAVWood May 26, 2011 10:43

  - 0 +
• 
  Hi Chris/All,
  
  If you run check for updates now you should receive SQL Backup 6.5.1.9 which contains this fix.
  
  There won't be an announcement on the forum as far as I'm aware.
  
  Thanks,

  Matthew Flatt May 26, 2011 11:45

  - 0 +
• 
  I've downloaded it now.
  
  Thanks
  
  Chris

  ChrisAVWood May 26, 2011 11:58

  - 0 +

Add comment

Please sign in to leave a comment.