can i deleteTfs_Warehouse, ReportServer, ReportServerTempDB backups from SQL server?

Question

i want to cleanup the database which are not useful, from the SQL server

-here are the list of backups for each DB on the SQL server

database names

Tfs_Configuration, Tfs_ProjectCollection1, Tfs_ProjectCollection2, Tfs_Warehouse, ReportServer, ReportServerTempDB, Tfs_Warehouse, 

Tfs_IntegationPlatform

my question is i did not configure Team Foundation Server Reporting Services,so i shouldn't have the ReportServer or ReportServerTempDB database but how come Tfs_warehouse and  ReportServer, ReportServerTempDBservers exists in SQL server..

so can i DELETE these backups from SQL server?or  can i use this databases for configuring my reporting services?

 

Answer 1

Did you know what are the size of them? so if they have small size what the useful of deleting them in anyway.

---

We are volunteers, if the reply help you mark it as your answer. thanks!!

Blog: http://mohamedradwan.wordpress.com

 

Answer 2

I would not delete the actual databases, that will likely cripple your TFS instance. Regarding backups I would suggest you have a look at the backup plan and adjust the retention rules for the backups to minimize the number of backups you keep. Simply removing all backups for some of the databases will likely make it impossible (or at least difficult) to do a disaster recovery. I have not validated this so if you are lucky someone will say I'm wrong :)

---

Jesper Fernström
QWise Software engineering – refactored!

Answer 3

Hello aajaamu,

First, ReportServer and ReportServerTempDB databases are Reporting Services databases. And as you did not configure Team Foundation Server with Reporting Services, you will not backup the ReportServer or ReportServerTempDB databases.

In addition, as you do not configure your TFS server with Reporting Service you should not have Tfs_Warehouse in the source SQL Server (I suspect that you configure the Reporting Service for the TFS server sometime ago). And both the Tfs_Warehouse and Tfs_Analysis databases extract data from Tfs_Collection database. So I personally think that it is OK even though you do not back up them.

For more information about back up TFS databases, please see: http://msdn.microsoft.com/en-us/library/ms253070.aspx  

Thanks.

---

Vicky Song [MSFT]
MSDN Community Support | Feedback to us