Database name not unique

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.

data-recovery

asked 29 Mar '15, 17:46

Janand
11●1●1●1
accept rate: 0%

flat view

One Answer:

active answers oldest answers newest answers popular answers

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 Elson S...
7.3k●35●107
accept rate: 32%

flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "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

learn more about Markdown

Question tags:

data-recovery ×14

question asked: 29 Mar '15, 17:46

question was seen: 3,280 times

last updated: 30 Mar '15, 12:40

SAP SQL Anywhere

Database name not unique

Follow this question

Related questions