We have an old server with the VS2010 TFS server, and it broke the hardware problem, and now we need to switch to the new server. How to move the database to a new server? We have a database backup.
Here's the MSDN article Recover Data to Another Server or Instance . It contains a detailed set of steps to restore from backups.
These steps also assume that SQL Server used Marked Transactions . Another part of this is the Back Up Team Foundation Server article.
To successfully back up Team Foundation Server, you must not only back up all the databases that the deployment uses, but also synchronize the backups at the same time. You can manage this synchronization most efficiently if you use marked transactions.