SQL Backup Testing

cjbaumcjbaum Posts: 9
in SQL Backup

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

· Share on Twitter

Comments

  • cjbaumcjbaum Posts: 9

    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 ?

    · Share on Twitter
  • 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
    · Share on Twitter
Sign In or Register to comment.