I am trying to copy a site from PROD to TEST. (I had to remove http:// from the post so i can publish it here)
In Prod: teams.max.it/veri/desk and it's using Content_DB_42
I had DBA take a copy of the DB and move it to TEST DB
In TEST: teams.max-test.it/veri/desk and it's using Content_DB_08
I tried the following but I get database already exists error stsadm -o addcontentdb -url teams.max-test.it/veri/desk -databasename Content_DB_42 -databaseserver MAX_TEST_SQL
I tried move-spsite and i get following error
Move-SPSite teams.max-test.it/veri/desk -DestinationDatabase Content_DB_42
Move-SPSite : Site collection teams.max-test.it/veri/desk already exists in database Content_DB_42. Site collection will not be moved.
Finally, When I go to central admin for the TEST farm and I see that site still shows old database "Content_DB_08"
When I go to the test site it still has old data.