Red Gate forums :: View topic - SQL Object Level Recovery native - Select Backup Source time
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

SQL Object Level Recovery native - Select Backup Source time

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



Joined: 04 Dec 2007
Posts: 51

PostPosted: Wed Jan 18, 2012 3:56 am    Post subject: SQL Object Level Recovery native - Select Backup Source time Reply with quote

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



Joined: 23 Aug 2004
Posts: 6668

PostPosted: Thu Jan 19, 2012 4:43 pm    Post subject: Reply with quote

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



Joined: 23 Aug 2004
Posts: 6668

PostPosted: Thu Jan 19, 2012 4:46 pm    Post subject: Reply with quote

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.
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