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