DB Refresh Tier 1 to Tier 1

(1) Share

Report

Posted on by PT-09091026-0

Hi,

we have created two Tier1 environments for the below purpose

Golden Environemnt--(we have manually imported/configured the configuration data,migrataion,setup data except transactional data)
Preprod/SIT --(Once golden environement is configured as said in the first step, we would like to take the backup of goldenenvironment db and restore in this environment and would like test by doing some transactions but restore is failing)

USE [master]
RESTORE DATABASE [AxDB] FROM DISK = N'J:\MSSQL_BACKUP\backup_from_goldenenvironment\AxDB30092024.bak' WITH FILE = 1, NOUNLOAD, STATS = 5

Msg 3154, Level 16, State 4, Line 2
The backup set holds a backup of a database other than the existing 'AxDB' database.
Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.

Completion time: 2024-09-30T13:02:43.4079113+00:00

Am i doing the right steps,could you please comment on this?

Thanks

Categories:

Dynamics 365 Administration

All responses (1)

Answers (1)

Verified answer

Martin Dráb 228,366 Most Valuable Professional on at

Like (1)

Report

DB Refresh Tier 1 to Tier 1

You're missing WITH REPLACE option.

(Moved from D365 general forum.)