News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... May I ask how do I rep...

Small and medium business | Business Central, N...

Suggested answer

May I ask how do I replicate a database on to another database in SQL server management 2016?

(0) Share

Report

Report

Posted on by joshtechsolutions

4,549

Hi,

I have server A and I want to replicate another Server A for testing purpose.

How do I do this?

I have tried to do a back up of Database A
Create a new Database and call it Database B
Then try to restore Database A in Database B.

However, SQL gives me an error that said "the back up consist of contents belonging to another server"

Instead of restoring, should I be importing and exporting?

Thank you!

All responses Img

All responses (2)

Answers Img

Answers (0)

joshtechsolutions 4,549 on at

Like (0)

Report

RE: May I ask how do I replicate a database on to another database in SQL server management 2016?

I have a couple of existing Database running on the same server, if I close existing connection will that database that I back up from be shut down as well?
Suggested answer

Nitin Verma 21,273 Moderator on at

Like (0)

Report

RE: May I ask how do I replicate a database on to another database in SQL server management 2016?

Hi Josh,

can you please try TRUE to "Close Existing connection" from the option tab in the Restoring window?

Thanks

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2

Martin Dráb 231,305 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans