cancel
Showing results for 
Search instead for 
Did you mean: 

is possible to restore with another data base ?

Former Member
0 Kudos

Hi,

I want to restore my DEV database with PRD database in TESTserver through SQL enterprise manager. I have backup of PRD, which is taken from DB13.

Is that possible to restore like this?

Gayathry.

Accepted Solutions (1)

Accepted Solutions (1)

markus_doehr2
Active Contributor
0 Kudos

Check

http://service.sap.com/systemcopy

how to do that. Yes, it is possible.

--

Markus

Former Member
0 Kudos

Hi Markus,

I am not getting that, how its related to system copy?

I am getting the error "Microsoft SQL-DMO(ODBC SQLState:42000)" while restoring.

I am trying to restore the database "PSD" with the backup file of "PRD"

Regards,

Gayathry.

Former Member
0 Kudos

Hi,

1. Does the database ALREADY exist on the target server?

2. If so, does the directory structure where the MDF/LDF match where the MDF/LDF reside on the live server. In this I mean if the files on the live server were located in the C:\MyDir\Data folder, do they also reside like that on the target serverr?

IF NOT ... you need to use the WITH MOVE option to place the MDF and LDF in the folder(s) that are being used on your target server. If you are using the Restore wizard, you need to change the file path on the Options tab of the wizard. Change the path in the "Move to physical file name" option to the desired location.

if this not work

try to restore database with same SID on target server i.e PRD than after you can change the dtabse from PRD to PSD using following sap note

151603

regards,

Kaushal

Former Member
0 Kudos

got it, Thank you very much Kaushal.

Gayathri.

Answers (0)