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

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
  • Thank you very much Peter, It's really worthful.

    Appreciate your help.

    Ram Singh
    Database Administrator 2008
  • 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.
Sign In or Register to comment.