Twitter
Google
RSSHow to restore database with a new database name
To restore database with new database name , please configure a restore job with following settings:
(Suppose the original name is db1 and the target database name is dbx)
1 . Select the restoration target Backup Agent and Instance ,then just enter new database name in "Restore As" field .(we enter the "dbx"), see following :
2 . If the target database has been existed , the "Force replace existing ... ..." option should be seleted either.
3 . An very important thing is that : If original database and the target database are on the same server , you must change the restoration database files directories , or the restoration job will try to overwrite the original database files , that cause restoration job fails. By selecting "Move ... ..." option and clicking the "Edit Location" button ,you can define new database directories , see following :
4 . In most case , Backup Agent can create target directories if they dosen't exist.
5 . Do other required configuration ,then save and run the restoration job.
