| Author |
Message |
rasingh
Joined: 15 Sep 2010
Posts: 2
|
 Posted: Wed Sep 15, 2010 5:31 pm Post subject: How to verify backup set/files using Red Gate. |
 |
|
Wanted to know the Red Gate command to verify backup set/files.
Thanks.  |
|
| Back to top |
|
 |
petey
Joined: 24 Apr 2005
Posts: 2216
|
| Posted: Wed Sep 15, 2010 6:50 pm Post subject: |
|
|
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: |
| 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 |
|
| Back to top |
|
|
rasingh
Joined: 15 Sep 2010
Posts: 2
|
| Posted: Thu Sep 16, 2010 11:46 am Post subject: To vericy backup set/file using RedGate |
|
|
Thank you very much Peter, It's really worthful.
Appreciate your help.
Ram Singh
Database Administrator 2008 |
|
| Back to top |
|
|
epetro
Joined: 31 May 2011
Posts: 55
Location: Zotec Partners
|
| Posted: Wed Feb 22, 2012 8:29 pm Post subject: VERIFY ONLY for Encrypted backup |
|
|
If your backup is behind a password use syntax similar to
| Code: |
| 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. |
|
| Back to top |
|
|
|
|
All times are GMT + 1 Hour
|
| Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
