Red Gate forums :: View topic - How to verify backup set/files using Red Gate.
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 6
SQL Backup 6 forum

How to verify backup set/files using Red Gate.

Search in SQL Backup 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
rasingh



Joined: 15 Sep 2010
Posts: 2

PostPosted: Wed Sep 15, 2010 5:31 pm    Post subject: How to verify backup set/files using Red Gate. Reply with quote

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

Thanks. Very Happy
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2306

PostPosted: Wed Sep 15, 2010 6:50 pm    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
rasingh



Joined: 15 Sep 2010
Posts: 2

PostPosted: Thu Sep 16, 2010 11:46 am    Post subject: To vericy backup set/file using RedGate Reply with quote

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

Appreciate your help.

Ram Singh
Database Administrator 2008
Back to top
View user's profile Send private message
epetro



Joined: 31 May 2011
Posts: 55
Location: Zotec Partners

PostPosted: Wed Feb 22, 2012 8:29 pm    Post subject: VERIFY ONLY for Encrypted backup Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Reply to topic 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