clone a site collection from prod to test

Question

Here is the scenario (both TEST and Prod SP is 2013 farm)

1. I had DBA take a fresh copy of the PROD site collection DB and restore it TEST DB
2. Then I used following to provision the site in TEST.

stsadm -o addcontentdb -url https://inside.colage.com/sites/OPS -databasename SP2013_CD_OPS -databaseserver EXTSPSQL

3. The ran successfully
4. I waited a while and it gives me following error

https://inside.colage.com/sites/OPS

Server error: http://go.microsoft.com/fwlink?LinkID=177673

Answer 1

you dont need to specify the Site collection url rather you need to provide the web application url.

stsadm -o addcontentdb -url https://inside.colage.com -databasename SP2013_CD_OPS -databaseserver EXTSPSQL

It will add the database into the Web application, after sucesffuly attaching it then go to the browser and browse the url.

Or you can use the SharePoint Powershell to attache it:

Mount-SPContentDatabase "SP2013_CD_OPS" -DatabaseServer "EXTSPSQL" -WebApplication https://inside.colage.com