How to verify backup set/files using Red Gate.

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

How to verify backup set/files using Red Gate.

Postby rasingh » Wed Sep 15, 2010 5:31 pm

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

Thanks. :D
rasingh
 
Posts: 2
Joined: Wed Sep 15, 2010 5:27 pm

Postby petey » Wed Sep 15, 2010 6:50 pm

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.

Code: Select all
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 7
petey
 
Posts: 2227
Joined: Sun Apr 24, 2005 12:34 pm

To vericy backup set/file using RedGate

Postby rasingh » Thu Sep 16, 2010 11:46 am

Thank you very much Peter, It's really worthful.

Appreciate your help.

Ram Singh
Database Administrator 2008
rasingh
 
Posts: 2
Joined: Wed Sep 15, 2010 5:27 pm

VERIFY ONLY for Encrypted backup

Postby epetro » Wed Feb 22, 2012 8:29 pm

If your backup is behind a password use syntax similar to
Code: Select all
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
 
Posts: 55
Joined: Tue May 31, 2011 7:55 pm
Location: Zotec Partners


Return to SQL Backup 6

Who is online

Users browsing this forum: No registered users and 0 guests