How to verify backup set/files using Red Gate.

rasinghrasingh Posts: 3
edited February 22, 2012 2:29PM in SQL Backup Previous Versions
Wanted to know the Red Gate command to verify backup set/files.

Thanks. :D
· Share on Twitter

Comments

  • peteypetey Posts: 2,358 New member
    It's similar to the standard RESTORE VERIFYONLY command, except that it's contained in the call to the sqlbackup extended stored procedure e.g.
    EXEC master..sqlbackup '-sql "RESTORE VERIFYONLY FROM DISK = [g:\backups\AdventureWorks_a.sqb], DISK = [g:\backups\AdventureWorks_b.sqb] " '
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
  • rasinghrasingh Posts: 3
    Thank you very much Peter, It's really worthful.

    Appreciate your help.

    Ram Singh
    Database Administrator 2008
    · Share on Twitter
  • epetroepetro Posts: 69
    If your backup is behind a password use syntax similar to 
    EXEC master..sqlbackup '-sql "RESTORE VERIFYONLY FROM DISK = [g:\backups\AdventureWorks_a.sqb] WITH PASSWORD=''mypass''" '
    Be sure your password is between dual single quotes.
    · Share on Twitter
Sign In or Register to comment.