Red Gate forums :: View topic - Backup Source does not show 'Available backups'
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Object Level Recovery Native 1
SQL Object Level Recovery Native 1 forum

Backup Source does not show 'Available backups'

Search in SQL Object Level Recovery Native 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
BarryFS



Joined: 03 Aug 2012
Posts: 4
Location: UK

PostPosted: Thu Aug 09, 2012 10:40 am    Post subject: Backup Source does not show 'Available backups' Reply with quote

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
Back to top
View user's profile Send private message
BarryFS



Joined: 03 Aug 2012
Posts: 4
Location: UK

PostPosted: Thu Aug 09, 2012 11:01 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
BarryFS



Joined: 03 Aug 2012
Posts: 4
Location: UK

PostPosted: Thu Aug 09, 2012 2:09 pm    Post subject: Still Waiting .... Reply with quote

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
Back to top
View user's profile Send private message
Manfred.Castro



Joined: 23 Apr 2012
Posts: 205

PostPosted: Fri Aug 10, 2012 6:39 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
RajK



Joined: 02 Feb 2012
Posts: 58

PostPosted: Sat Aug 11, 2012 4:10 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
BarryFS



Joined: 03 Aug 2012
Posts: 4
Location: UK

PostPosted: Mon Aug 13, 2012 9:51 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Manfred.Castro



Joined: 23 Apr 2012
Posts: 205

PostPosted: Tue Aug 14, 2012 4:45 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group