restore time VERY slow (compared to native SQL restore)

• 
  Restore never starts at all with 6.4.0.1015. Process is waiting on PREEMPTIVE_OS_GETPROCADDRESS.

  brosato August 11, 2010 08:13

  - 0 +
• 
  Can you back up using 6.4.0.1015? Can you back up a small database and restore it?
  
  Thanks.

  petey August 11, 2010 08:23

  - 0 +
• 

  petey wrote:

  Can you back up using 6.4.0.1015? Can you back up a small database and restore it?
  
  Thanks.

  
  
  Here's what happening. If I specify the filename of a full backup, [\\Recovery\SQLBackups\Nasdaq\CustomerViews\FULL_CustomerViews_20100811_083903.sqb], it will restore. If I use [\\Recovery\SQLBackups\Nasdaq\CustomerViews\*.sqb] LATEST_FULL the restore never starts.

  brosato August 11, 2010 09:00

  - 0 +
• 
  Could you please download 6.4.0.1015 again? I've fixed the hanging issue with the LATEST_ALL option.
  
  Thanks.

  petey August 11, 2010 09:39

  - 0 +
• 
  I think that took care of it. I'm going to try something a bit larger with more files.

  brosato August 11, 2010 12:31

  - 0 +
• 
  Everything seems to be working ok now.

  brosato August 11, 2010 13:39

  - 0 +
• 
  Yes, 6.4.0.1015 has done it all so far. I have been able to restore that 30GB database using the Latest_All option from a network backup source with many backup files present. The full restore component completed in just over 44 minutes, just like 6.4.0.56. It has also worked with several smaller databases, too.
  
  Fantastic!!
  
  Thanks for all your efforts, Pete.

  mgjernes August 11, 2010 18:31

  - 0 +
• 
  Thank you very much for your efforts in testing this patch release.

  petey August 11, 2010 23:35

  - 0 +
• 
  All my test restores went off without a hitch last night. Thanks Pete.

  brosato August 12, 2010 08:55

  - 0 +

Add comment

Please sign in to leave a comment.