Before I do an upgrade I always ask for the size of the TFS database set. It provides me the information on how long an upgrade might take. The queries below, also provides information of attachments that might be taking up extra disk space. By reducing the overall database set, the whole upgrade process will go faster. Plus, it is a good time to do some house cleaning.
If you use the Attach/Detach process to do an TFS 2013 upgrade, you don’t get progress status bar as you would using the Upgrade wizard. If you have a large database upgrade to perform, it is good to see some type of progress of the upgrade process.Below is some select T-SQL command that you can run to see what job is being executed.
Recently I was performing a upgrade from TFS 2010 to TFS 2013. During the upgrade process on step number 7, I received an error:
TF400744: An error occurred while executing the following script: CollectionFrameworkDev10ToDev11CTP1.sql.
After a upgrade to TFS 2013 and you get the TF400509 message. You will need to set the iterations and Areas for that Team Project. Below is the basic walkthrough on how to do this.