The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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

Janand
11111
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...
6.2k2890
accept rate: 30%

Your answer
toggle preview

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

Question tags:

×13

question asked: 29 Mar '15, 17:46

question was seen: 568 times

last updated: 30 Mar '15, 12:40