需要有关TFS SQL备份和恢复的信息

本文介绍了需要有关TFS SQL备份和恢复的信息的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 HI，    我们有生产服务器 R& D团队使用PRODTFS ，我为我的试验和错误设置了 TESTTFSSERVER 。We have production server PRODTFS used by R&D teams  and I have setupTESTTFSSERVER 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  用于在新硬件上设置 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备份和恢复的信息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！