SQL Object Level Recovery native - Select Backup Source time

Recovers database objects from SQL Server backups

Moderator: RBA

SQL Object Level Recovery native - Select Backup Source time

Postby gsc_ghx » Wed Jan 18, 2012 3:56 am

I have a 300gb database that I need to recover a few tables. I have selected the Backup Source (a full and a diff). The Diff file has the green check mark next to it, but the full still has the 'clock icon'. IT has been like that now for over 8 hours. How long does it take to validate this size of a file?

When this is running - what exactly is it doing? I don't see it loading information into memory or writing to my local disk? We are just curious what the process is behind the program.

Thanks
Geri Sue Coe :?
gsc_ghx
 
Posts: 51
Joined: Tue Dec 04, 2007 10:33 pm

Postby Brian Donahue » Thu Jan 19, 2012 4:43 pm

Hi Geri,

If the backup file in question is a native backup, then the program has to seek all the way to the end of the file to find the "header" information. I realize that sounds a bit tail-about-head but MS has to do this for compatibility with tape drives.

SQL Backup files put the header at the front, so may work faster.

Either way, though, this operation should take minutes rather than hours.

I'm also aware that there is a search for the first page containing the schema, and that can be time-consuming.

I suppose the only way to work out what this software is actually doing is to debug it.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby Brian Donahue » Thu Jan 19, 2012 4:46 pm

You may also want to check for log files in %ALLUSERSPROFILE%\\Local Settings\\Application Data\\Red Gate\\Logs to see if there is anything useful in there.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Object Level Recovery Native 1

Who is online

Users browsing this forum: No registered users and 1 guest