This recipe will cover how to recover a SQL database but change the SQL alias for the database. A scenario for this is when you recover a development database to a production environment.
In the scenario that you would like to restore a SQL database with another SQL alias, you must keep in mind that if you restore the SQL database to the same SQL instance that it originates from, you must change the location of the database file and/or the log files for the database, or you cannot perform the restore operation.
If you don't specify an alternate file location, the restore job will fail and DPM will describe it as a VSS error.