How can we help you today? How can we help you today?

How to verify backup set/files using Red Gate.

Wanted to know the Red Gate command to verify backup set/files.

Thanks. :D
rasingh
0

Comments

3 comments

Sort by
  • petey
    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] " '
    petey
    0
  • rasingh
    Thank you very much Peter, It's really worthful.

    Appreciate your help.

    Ram Singh
    Database Administrator 2008
    rasingh
    0
  • epetro
    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.
    epetro
    0

Add comment

Please sign in to leave a comment.