Home | Contact | Links
spcHome
spcSQL Server Backup
spcDownload
spcPurchase
spcSupport
   spcFAQs
   spcSubmit Ticket
spcAffiliate
spcContact
spcLinks
How to restore database with a new database name?   Back

It is very easy to restore database with new name in 7.x or later version .

To restore database with new database name , please configure a restoration 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.
Copyright @2007 by Databk.com. All Rights Reserved. Home | Contact | Links