Backup Source does not show 'Available backups'

Recovers database objects from SQL Server backups

Moderator: RBA

Backup Source does not show 'Available backups'

Postby BarryFS » Thu Aug 09, 2012 10:40 am

Hi,

This is my first time trying Object Level Recovery Native.
I have a compressed SQL Server backup, which I want to restore 1 table from.
The original database size is 90 GB, and the compressed backup file is 20 GB.
(The table I am restoring is tiny - less than 10 MB).
I selected the file in the Backup Source window, which took a very long time to validate, but eventually the 'tick' did appear in the OK column.
However, the 'Available Backups' section at the bottom of the same window does not show anything, and the 'OK' button is greyed-out.

Is this normal behaviour?

Should I expect a long delay between validating the backup file, and showing results in the Available Backups section?

Best Regards
Barry
BarryFS
 
Posts: 4
Joined: Fri Aug 03, 2012 10:23 am
Location: UK

Postby BarryFS » Thu Aug 09, 2012 11:01 am

Just a quick update, it has now completed the Available Backups section - maybe I was just being impatient.

However, it is worth pointing out, as others have done in posts that I have seen, this tool seems very slow at reading / checking a backup file, prior to performing the restore operation.
BarryFS
 
Posts: 4
Joined: Fri Aug 03, 2012 10:23 am
Location: UK

Still Waiting ....

Postby BarryFS » Thu Aug 09, 2012 2:09 pm

The GUI says that it is Parsing the selected backup, and has been at 50% for at least 2 hours now.
This whole process has been running for over 4 hours now, and I still haven't been a list of available objects in the database, to enable me to select the table I want the tool to restore.
I had high hopes for this tool, as the option of restoring database objects is very appealing, but at this rate it would have been quicker for me to restore the whole database, copy-out the table I want, then drop the database again.

Are there plans to speed up access to the backup file(s) in future releases?
Is this process any quicker in 'SQL Object Level Recovery Pro'?

Best Regards
Barry
BarryFS
 
Posts: 4
Joined: Fri Aug 03, 2012 10:23 am
Location: UK

Postby Manfred.Castro » Fri Aug 10, 2012 6:39 pm

Unfortunately SQL Object Level Recovery is not very robust in that it begins to struggle with larger databases.

We have another product that would be better suited for larger databases when trying to recover objects from a database.

http://www.red-gate.com/products/dba/sql-virtual-restore/
Manfred Castro
Product Support
Red Gate Software
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm

Postby RajK » Sat Aug 11, 2012 4:10 am

Please note that the backup reader for OLR is sequential so for very large databases and object recovery this has performance impacts. We normally suggest using one of our other products (SQL virtual restore) to do this sort of object level recovery as mentioned by my colleague. Another advantage of using SVR is all the database objects are accessible after doing a virtual restore (mounting the database directly from a backup file to provide access). So you don't have to do any more recovery for additional access.

OLR should work better with smaller database backups.
RajK
 
Posts: 58
Joined: Thu Feb 02, 2012 8:21 am

Postby BarryFS » Mon Aug 13, 2012 9:51 am

Thanks to both of you for responding.

I eventually cancelled the restore after approximately 7 hours, as it was still parsing the selected backup.
This means that the tool is, in effect, useless to me, as most of my live databases are 40 GB or more (which I don't think would be regarded as a 'large' database to many DBAs).

Unfortunately, I do not envisage my company purchasing Virtual Restore.
For information, what would you recommend as a maximum size database that could be handled by OLR Native??

Is the restore time etc any quicker with OLR Pro (which I believe is part of the Backup Prod tool)?

Best Regards
Barry
BarryFS
 
Posts: 4
Joined: Fri Aug 03, 2012 10:23 am
Location: UK

Postby Manfred.Castro » Tue Aug 14, 2012 4:45 pm

I dont believe the restore time will be that much quicker with OLR Pro as the only difference between OLR Pro and OLR native is that native handles native backups and Pro handles SQL Backups sqb files.
Manfred Castro
Product Support
Red Gate Software
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm

Postby michelerice » Thu Jul 10, 2014 7:29 am

Try SQL database recovery software that is specially designed for this purposes. You can trial version and they apparently show you the retrieved database.

*Supported SQL Server Versions

*MS SQL Server 2000, 2005, 2008, 2008 r2 and 2012

Download:- http://www.filesrecoverytool.com/sql-da ... epair.html
michelerice
 
Posts: 1
Joined: Thu Jul 10, 2014 7:15 am


Return to SQL Object Level Recovery Native 1

Who is online

Users browsing this forum: No registered users and 1 guest