How to exclude Team Project Collection database in TF backup plan

Question

Hi,

My TFS server is 2010 sp1 and installed the latest power tools. There are some Team Project Collections for lab or practice that I don't want to backup.

I tried to delete lines <Database Name="databaseName">SQL ServerName</Database> under <TfsCollections> in configPT.xml located at "C:\ProgramData\Microsoft\Team Foundation\Server Configuration\" path. But every time I took Full Backup, all these lines backed to the configPT.xml file and all databases were backup.

Is there any step I missed? How can I fix this issus?

 

Thanks

Answer 1

Hello Wade,

Thanks for your post.

To exclude the Tfs_CollectionName database from the TFS backup plan is possible with your approach you mentioned above.

And after you delete the line <Database Name="databaseName">SQL ServerName</Database> in the configPT.xml file, please delete your local cache and then reopen the TFS Administration Console. And at this time, you should not have that deleted Tfs_CollectionName database shown in the TFS backup plan.

You can find your local cache in the path: C:\Users\userName\AppData\Local\Microsoft\Team Foundation\3.0\Cache

Thanks,

---

Vicky Song [MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 2

Hi Vicky,

Thanks for your answer, but it seems not work. At first, I didn't delete the cache and after I refreshed TFS Administration Console, the databases connected to the lines I deleted were disappeared in TFS backup plan.

I used "Take Full Backup Now" for trial, I found it inspected every Team Project Collection database and all the lines backed to the ConfigPT.xml file.

Even I followed your steps, it still inspected every database and back it up. Did I install the wrong version of Power tools? Or I need to restart system or something? (The version of TfsConfigPT.exe is 10.0.40818.0.)