Testing SQL backups on a different machine
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?