I am trying to figure out the specifics of Managed Metadata Web Service on our Production server to reproduce the same settings in our development server.

I was wondering if there might be an easy way to do this.


To move/copy Managed Metadata Service from one farm to another, you should do the following:

  • First, it's recommended to stop the managed metadata service before move using PowerShell.

     Stop-SPServiceInstance -Identity <ServiceGUID>
  • Get the service database by running the below command

    Get-SPDatabase | Where {$_.Type -like "*MetadataWebService*"} | Select Name
  • In your production, open SQL server, perform a database backup for the Managed Metadata service database, to do that check Back Up and Restore of SQL Server Databases. or you can use Database Detach and Attach (SQL Server) as the following:

    • Right click on database > de-attach.
    • locate the .mdf, .ndf, and .ldf files for Managed Metadata database files and paste it to your dev farm.
  • In production, attach the database again.
  • Start the service instance again.

    Start-SPServiceInstance -Identity <ServiceGUID>
  • In your development env, Perform a attach to the database files or restore the database backup based on your selected backup and restore method.

  • Now Point the Managed Metadata service application to a new database server by using Windows PowerShell

     $app = Get-SPServiceApplication -Name "<ServiceApplicationName>"
     Set-SPMetadataServiceApplication -Identity $app -DatabaseName "<DbName>"


For performing the move operations, you must have the following permissions:

  • A member of the Farm Administrators SharePoint group.
  • A member of the Administrators group on the local server
  • Have the Securityadmin fixed server role on the SQL Server instance.
  • Have the db_owner fixed database role for all of the databases that you are moving.

For more details check Move the Managed Metadata Service service application databases in SharePoint Server 2013

  • I will have to try this after hours. I will write back then after I have done it to let you know if it worked. Thank you.
    – Skylark
    Aug 10 '17 at 15:53
  • Take your time, and don't hesitate to inform me in case you need any further clarification Aug 10 '17 at 16:53
  • Thank you. I think I might not be able to get to this until next week.
    – Skylark
    Aug 11 '17 at 20:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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