需要有关TFS SQL备份和恢复的信息 [英] need info on TFS SQL backup and restore
问题描述
HI，
我们有生产服务器 R& D团队使用PRODTFS ，我为我的试验和错误设置了
TESTTFSSERVER 。
We have production server PRODTFS used by R&D teams and I have setup TESTTFSSERVER for my trial and error.
我们已经配置了备份通过TFS管理控制台，以便每晚都有生产服务器的完整数据库备份 PRODTFS 。
We have configured backups via TFS Admin console, so that every night there will be full database backup for production server PRODTFS.
现在我使用了 PRODTFS < /强>&NBSP;用于在新硬件上设置
TESTTFSSERVER 的SQL备份。我执行了以下步骤来设置：
Now I have used PRODTFS SQL backups to setup my TESTTFSSERVER on new hardware. I performed following steps to setup:
1）在新硬件上恢复到SQL服务器的所有备份。
1) Restored all the backups to SQL server on new hardware.
2）运行TFS应用程序向导但没有配置。
2) Ran the TFS application wizard but didnt configure.
3）在CMD promt（管理员模式）中运行以下命令
3) ran the following commands in CMD promt (Admin mode)
TFSConfig PrepareClone / SQLInstance： TESTTFSSERVER / DatabaseName：Tfs_Configuration / notificationURL：http：// TESTTFSSERVER ：8080 / tfs
TFSConfig PrepareClone /SQLInstance:TESTTFSSERVER /DatabaseName:Tfs_Configuration /notificationURL: http://TESTTFSSERVER:8080/tfs
TFSConfig ChangeServerID / SQLInstance： TESTTFSSERVER / DatabaseName：Tfs_Configuration
TFSConfig ChangeServerID /SQLInstance:TESTTFSSERVER /DatabaseName:Tfs_Configuration
TFSConfig RemapDBs / DatabaseName： TESTTFSSERVER ; Tfs_configuration / SQLInstances： TESTTFSSERVER / AnalysisInstance： TESTTFSSERVER / AnalysisDatabaseName:Tfs_Analysis
TFSConfig RemapDBs /DatabaseName:TESTTFSSERVER;Tfs_configuration /SQLInstances:TESTTFSSERVER /AnalysisInstance:TESTTFSSERVER /AnalysisDatabaseName:Tfs_Analysis
并配置TFS选择应用程序层只有模式。
and configured TFS choosing application tier only mode.
我在同一台服务器上同时拥有TFS APP和SQL，因为它只是一个测试服务器。
i have both TFS APP and SQL on the same server since it is just a testserver.
所有通讯ands顺利进行，这是在5月的某个时间进行的，并且TESTTFS设置成功完成并验证了这个测试服务器在任何方面都没有打扰PRODTFS。
All the commands went well and this was performed sometime in May and TESTTFS setup done successfully and verified that this test server is not disturbing PRODTFS in any ways.
现在我的团队成员想要在工作项目上对 TESTTFSSERVER 进行试验，他正在寻找最新的数据，但服务器的数据一直持续到5月。我进行了完整备份，该备份来自每日备份，来自 PRODTFS
，并在其中一个集合中恢复 TESTTFSSERVER ，恢复完成后，集合无法访问。
now that my team member wanted to make sme trial on TESTTFSSERVER on workitems and he was looking for latest data but the server had data till the month of may. I took full backup which got it from daily backups which was from PRODTFS and restored on TESTTFSSERVER for one of the collections, after restoration completed,the collection was inaccessible.
我们在恢复备份之前需要遵循哪些方法和步骤？
What are the ways and steps to follow before we restore the backup ?
是因为，我运行了更改服务器ID TESTTFSSERVER 不接受来自 PRODTFS的备份？
is it because, i ran change serverID TESTTFSSERVER will not accept backups coming from PRODTFS ?
推荐答案
在PRODTFS上启动TFS管理控制台
start TFS Admin Console on PRODTFS
分离集合
获取集合数据库的完整SQL备份
take a full SQL backup of the collection database
在TESTTFSSERVER上重新附加集合
re-attach the collection
：
删除要用新版本替换的现有集合
drop the existing collection you want to replace with new version
删除SQL Server中的数据库
delete the database in SQL server
从PRODTFS恢复后卫
restore the fullback from PRODTFS
启动TFS管理控制台 - 选择附加集合
start TFS Admin Console - select attach collection
这篇关于需要有关TFS SQL备份和恢复的信息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
