Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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.

asked 29 Mar '15, 17:46

Janand's gravatar image

accept rate: 0%

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.

permanent link

answered 30 Mar '15, 12:40

Nick%20Elson%20SAP%20SQL%20Anywhere's gravatar image

Nick Elson S...
accept rate: 32%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 29 Mar '15, 17:46

question was seen: 3,589 times

last updated: 30 Mar '15, 12:40