UNSOLVED

aviraikkonen

updated

11 years ago

A

aviraikkonen

1 Rookie

22 Posts

0

942

May 5th, 2015 10:00

How to restore a sql instance overwriting another instance in the same db/server

Hello,

I am using Avamar 6.1 and taking SQL backups for one of the servers. In my backups I have 2 sql instances A and B, How can i restore A to B overwriting B so that B is a replica of A ?

The data and log files for both A and B exist under the same folder

I tried by selecting B as the target and the restore fails with "2015-05-05 17:41:55 avsql Error <15755>: The new name "B" of the database should not be specified in "Absolute Destination" or "Select SQL instance on destination client" field, the new name of the database must be specified in Advanced Options section "New database name" B (Log #1)"

I tried to restore as new DB named B but that fails with path doesnt exist.