Video Screencast Help

Testing SQL backups on a different machine

Created: 19 Mar 2012 • Updated: 20 Mar 2012 | 3 comments
This issue has been solved. See solution.


I am looking to test one of our database backups. I don't want to affect the live system, so I've installed SQL server on a different machine. What i would like to know is how can i get the file from backup exec 2010 that i need to restore in sql server.  

We would like to test this becase we have some server issues, that made us wodner if we our backups will work properly restored to a different machine. So i've installed a new instance of SQL server on a different machine and I would like to see if i can restore the database.  I plan to restore the database from a file, but when i tried to do it in backup exec with the restore wizard, it wanted to restore to the same place, but a custom place i can choose.

Can someone please provide info or steps that will allow me to do this please?


Comments 3 CommentsJump to latest comment

Ken Putnam's picture

When setting up the restore job, select the "redirected restore" and point it at your test server

If this response answers your concern, please mark it as a "solution"

pkh's picture

To restore SQL on your test machine, you would also have to install RAWS on the test machine.  I am not sure whether you can just use the SQL agent on this test machine.  You might need to buy another SQL licence for your test machine.