Red Gate forums :: View topic - VERIFY delay...
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 7
SQL Backup 7 forum

VERIFY delay...

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
SQL_ME_RICH



Joined: 08 May 2012
Posts: 64

PostPosted: Fri Jul 20, 2012 6:06 pm    Post subject: VERIFY delay... Reply with quote

Hello -

Is there a switch to add for the VERIFY option, so that it doesn't wait 90+ minutes before starting the verification of the .sqb file? Or is the delay in part due to the CHECKSUM that I also have listed as an option for when my Fulls and Diffs kick off?

The database in question is about 265gb in size, and is being compressed. It will show in the activity log that the backup processed successfully, but then it take as long as 90 minutes before starting the VERIFY process. I am guessing that the size of the database is the issue, because I do not see this issue with my smaller databases.

Any insight would be appreciated.

SQL_ME_RICH
Back to top
View user's profile Send private message
ChrisAVWood



Joined: 18 Dec 2007
Posts: 308
Location: Edmonton, Alberta, CANADA

PostPosted: Fri Jul 20, 2012 7:27 pm    Post subject: Reply with quote

You can include the VERIFYINTERVAL = number in seconds parameter as it was introduced in 6.5.2.9 but this would further delay the time your backup takes. I would expect that the CHECKSUM happens as part of the backup not the verify stage. Red Gate people will confirm this.

If you have Page Verify set to CHECKSUM as a database option I would think the CHECKSUM in the backup could be redundant. True you would need to read every page in the database with Page Verify as CHECKSUM first to know that you had a good database before you run backups without CHECKSUM as all the newly writen pages are CHECKED because of the Page Verify setting.

We have a DB that is about 170Gb of data that we compress with a setting of 2 to 2 files. The backup takes 45 minutes and the verify messages come out 30 minutes later as they only appear at the end of that process.

If I remember correctly you try and compress this database with a level of 4 and haven't been able to complete a backup for at least a week unless that was fixed.

Chris
_________________
English DBA living in CANADA
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2306

PostPosted: Sat Jul 21, 2012 4:58 am    Post subject: Reply with quote

Could you please post the contents of the SQL Backup log file for that backup? . The default folder where the logs are stored is C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\<instance name> on Windows 2003 and older, and C:\ProgramData\Red Gate\SQL Backup\Log\<instance name> on Windows Vista and newer.

Thank you.
_________________
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
Back to top
View user's profile Send private message Send e-mail
toad2898



Joined: 14 Sep 2009
Posts: 26

PostPosted: Fri Aug 03, 2012 11:10 am    Post subject: Reply with quote

Could I just ask if a workaround/fix/resolution, call it what you like, was given for this as I think i'm having the same issues since upgrading to 7.

The reason I think this is because there are big delays between the time the backup is taken and the time it is copied to a network location.
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2306

PostPosted: Fri Aug 03, 2012 12:03 pm    Post subject: Reply with quote

Pls see my earlier reply - could you please post the contents of the SQL Backup log for the backup that had the verify process running long after the backup completed?

Thanks.
_________________
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
Back to top
View user's profile Send private message Send e-mail
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