Restore SQL database to alternate server with alternate file paths
We have purchased Backup Exec 2012 product a few moths a go and we are adapting our backups according to product. We noticed that the program can not handle the restore of an sql database to an alternate server which consists of more than one data file . You can only define a path for all of the datafiles and program restores all of the datafiles to that location. But before this product we were using sql agent for backup and restore operation and while you restore a *:bak file you can simply change the path of all data files.
I think this kinf of enterprise scale product should handle this restore operation. I am surprised that program can not restore the database like this.
I will use my old solution for my sql database until this features is included in the backupexec.