This is task appeared when I needed to migrate SharePoint site collection from one farm to another.

First time we had used SharePoint 2010 back up mechanism, but this approach hard enough. We had a lot of errors during restore: broken connector, errors with content hub, access problems and so on. Every such restoration has brought new errors. We could not document restore process well enough.But then we have found new way of migration.

Migration guide simple and short:

1. Open SQL Server Management Studio and create back of Managed Metadata Service’s database (every Managed Metadata Service has their own database. Database name is something like this “Managed Metadata Service_0eb8ebdccb234c5ea23e677d816e845f”)
2. Restore database from this backup into new farm to database of another Managed Metadata Service.

 

Keep in the mind, that you can not create two Managed Metadata Services in the one farm this way, because  the Guid of the service store directly in the database. After such restore you can work with just one service.