Facing Problem regarding Verify of Backup

sugamsugam Posts: 2
edited July 1, 2008 12:40PM in SQL Backup Previous Versions
Hi,
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!!!!!!
sugam
· Share on Twitter

Comments

  • Matthew FlattMatthew Flatt Posts: 255 Bronze 5
    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
    · Share on Twitter
  • ChrisAVWoodChrisAVWood Posts: 361
    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.

    Thanks

    Chris
    English DBA living in CANADA
    · Share on Twitter
  • 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
    · Share on Twitter
Sign In or Register to comment.