CODEWITHSUNDEEP
databasetfssql-server-2012
Captain Kirk
Captain Kirk

Reputation: 63

TFS Database growing rapidely

My TFS Database is growing rapidely. I need to know how I can figure out what is taking most of that space and find a way to destroy the information that I don't need to keep. We are using GIT inside TFS. Does GIT in TFS manage Branches the same way it does on our PC or it create a copy of all the files?

At the end, I would like to reduce the required space for the database file.

thanks

Upvotes: 0

Views: 1293

Answers (1)

Andy Li-MSFT
Andy Li-MSFT

Reputation: 30432

Files aren’t stored on the file system like they would be when git is running on your local machine. Instead they are stored in the TFS SQL server database.

If there are many users who frequently modify and commit the changes, the tables you mentioned will be growing accordingly.

You can refer to this article to see how the git files are stored, then figure out what caused the Database growth.

Normally, the files you committed/attached will be stored in tbl_Content Table, so, you can also check if there is the abnormal growth for that table based on this article.

To clean up and reduce the size of the TFS database, there are a couple of ways to clean your TFS database:

You can also reference this article: https://social.technet.microsoft.com/wiki/contents/articles/19932.reduce-the-size-of-tfs-databases-after-cleaning-some-source-control-files.aspx

Upvotes: 1

Related Questions