Question Re: Database name not unique in Technology Q&A

Database name not unique

Former Member — Sun, 29 Mar 2015 17:46:40 GMT

Hi, I am trying to recover my production database to the DR servers. However when I run the restore, I get error database name not unique.

This is a BO install with SQL ANywhere backend. The DR server had it's own independent install and now we are trying to refresh it with data from production.

Command being used is "restore database path_of_CMS_DB from DB_archive_file_name" Please advise.

Re: Database name not unique

Former Member — Mon, 30 Mar 2015 12:40:29 GMT

One way I can reproduce this is to restore the database while connected to a database with the same name. That specific restriction is documented in the remarks section of the RESTORE DATABASE statement . Specifically it states that

You cannot be connected to the database you are restoring. You must be connected to a different database. For example, connect to the utility database. The database that you are encrypting must not be running.