Competition: What’s your favorite Redgate tool? Enter now.

SQL Backup Testing

Im new to using SQL Backup and I'm wondering how others are implementing the restore feature to be able to test there backups ? In the end i have about 50 servers to test the backups for and would imagine and i would restore to one or more servers dedicated strictly to restoring and testing.

Thanks for any feedback


  • Is there a way to point the scheduled restore to my network backup share and have it restore ALL backups and test ? Or do i have to schedule a restore for every database ?

  • peteypetey Posts: 2,358 New member

    There isn't a way to restore all backup sets. You would need to create separate restore jobs for each database.

    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.