Friday, February 24, 2012

Copy/Move database

I am trying to move a database from a dev machine to my server. I've tried the copy wizard but get an error saying the I cannot connect to the server after selecting it from the dropdown list in the wizard.
I have also tried doing a backup and restore, but run into the problem created by wanting to change the name of the db, if possible.
I am using Windows Auth and have access to the server.
Any suggestions would be greatly appreciated.

Thank you for your help.Hi,

- Create a backup of the database at your dev machine.

- Create a new database with the new name at the server and set the database and the log-file location to the desired path. Record the location of the datafile and the transaction log.

- Copy the backup-file to the new server in a temp-path.

- From the new database select the backup-file to restore and set the following options BEFORE you start the restore: Change the locations to the recorded values. Check Force restore over existing database.

- Start restore

Your database will now be restored at the new server.

Succes.

No comments:

Post a Comment