The forum will be down for scheduled maintenance on Saturday, March 4 beginning at 10am EST. Actual downtime is unknown but may be several hours.

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.5k2895
accept rate: 29%

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: 604 times

last updated: 30 Mar '15, 12:40