Easiest Method To Copy A Single DB From One SQL Instance To Another

Programming & Development Databases & Queries
,
1

So I am trying to copy a single DB from a SQL instance on one server and send to another one (which is our primary one).

I tried the copy database task and it fails with many errors but mostly this:

`  Event Name: OnWarning`

` Message: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED.  The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.`

So, then I tried to simply export it but it gives way too many options, so kind of stuck on which one I should choose:

image
image658×540 22.9 KB

I mean, I’ve done this before in the past but not very often. Just confused as to what it is doing right now. Never encountered these roadblocks.

Thanks!

4 Spice ups
2

Could you take a backup of the DB, import it on the other system?

6 Spice ups
3

just take a backup of the DB, copy the backup to new. And Restore the backup to the new server. May need to make a seed db to restore the copy too.

4 Spice ups
4

Trying this now. :slight_smile:

2 Spice ups
5

You could try the Microsoft Data Migration Assistant.

1 Spice up
6

Thanks for all of the tips…I believe (testing tonight) that the backup method worked for us. Will let you know.

7

So, I tried the backup / restore method and it still encounter issues:

image
image637×207 10.8 KB

Everything looks good with the backup but it doesn’t want to restore.

8

when restoring, try clicking Options and checking the top box, Overwrite Existing