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.