TF400856: The following service is not registered in the database: FileContent.

Within TFS 2013 Update 2 you may come across the above error. A job was introduced to migrate BLOB data after the system had been upgraded from the old schema to the new schema in order to reduce upgrade time. There are two fixes for this.

  1. Upgrade to TFS 2013 Update 3
  2. Run this script on all of your collection databases.

EXEC prc_SetServiceVersion @serviceName = 'FileContent', @version = 2

I hope this helps if you are trying to get a clean running TFS!