We have a SharePoint 2013 farm, development environment where one site collection alone is residing in a separate DB server.

Now we plan to move this site collection to production with the existing database server as production database server.

We are not planning to keep Dev environment for this site collection now .(this will be taken care later).

Can someone suggest the best suitable approach?

P.S : Publishing feature is enabled for this site collection.

1 Answer 1


I would recommend backing up the DB in DEV and restore it to your Production SQL server, then mount the DB to the webapp. Changing from one SQL server to another is more difficult because all your service application DBs etc. are already on your current Production SQL server.

  • There is no separate DEV and Prod SQL server.I just needed to make this sql server as prod sql server . So I think just mounting this database to production web application would be suffice ?
    – SP2013dev
    Sep 9, 2019 at 6:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.