What are the challenges you face when working across database platforms? Take the survey

Facing Problem regarding Verify of Backup

sugamsugam Posts: 2
edited July 1, 2008 12:40PM in SQL Backup Previous Versions
I have 20 Licence of Redgate I am facing the problem during backup from red gate .After taking the Backup it is verified and during verification it takes more time what it takes during Backup so i wish to know is there any utility/Procedure in redgate so that i can take the Backup on this server and Verify that on another one .
Thanks in advance!!!!!!


  • Options
    Hi sugam,

    Thank you for your forum post.

    The following syntax can be used to perform a verification of a SQL Backup backup file :

    EXECUTE master..sqlbackup N'-SQL "RESTORE VERIFYONLY FROM DISK = ''C:\Backup\pubs.sqb''"'

    Hope this helps.
    Matthew Flatt
    Redgate Foundry
  • Options
    We too are seeing that the verify step under V 5.2 and 5.3 is taking longer and longer to run. The verify is needed as part of the backup step so would it be possible to have some sort of verify parameters to make this step run faster?

    We are starting to use Threadcount but this affects the whole backup job. I am suggesting perhaps a way of having a verifycount for just the verify process or something similar.


    English DBA living in CANADA
  • Options
    peteypetey Posts: 2,358 New member
    The OP was mistaken when he mentioned that the verification process took longer than the backup. From the logs he sent, it was clearly not so.

    The verification may take longer over time, if the backups are also getting larger.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.