restore time VERY slow (compared to native SQL restore)

Comments

• brosato Posts: 89 Bronze 2

  August 11, 2010 8:13AM

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

  0 · Share on Twitter
• petey Redgate › Posts: 2,358 New member

  August 11, 2010 8:23AM

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

  Peter Yeoh
  SQL Backup Consultant Developer
  Associate, Yohz Software
  Beyond compression - SQL Backup goodies under the hood, updated for version 8

  0 · Share on Twitter
• brosato Posts: 89 Bronze 2

  August 11, 2010 9:00AM

  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.

  0 · Share on Twitter
• petey Redgate › Posts: 2,358 New member

  August 11, 2010 9:39AM

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

  Peter Yeoh
  SQL Backup Consultant Developer
  Associate, Yohz Software
  Beyond compression - SQL Backup goodies under the hood, updated for version 8

  0 · Share on Twitter
• brosato Posts: 89 Bronze 2

  August 11, 2010 12:31PM

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

  0 · Share on Twitter
• brosato Posts: 89 Bronze 2

  August 11, 2010 1:39PM

  Everything seems to be working ok now.

  0 · Share on Twitter
• mgjernes Posts: 23

  August 11, 2010 6:31PM

  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.

  0 · Share on Twitter
• petey Redgate › Posts: 2,358 New member

  August 11, 2010 11:35PM

  Thank you very much for your efforts in testing this patch release.

  Peter Yeoh
  SQL Backup Consultant Developer
  Associate, Yohz Software
  Beyond compression - SQL Backup goodies under the hood, updated for version 8

  0 · Share on Twitter
• brosato Posts: 89 Bronze 2

  August 12, 2010 8:55AM

  All my test restores went off without a hitch last night. Thanks Pete.

  0 · Share on Twitter