Dienstag, 10. April 2012 19:25
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
Tfs_Configuration, Tfs_ProjectCollection1, Tfs_ProjectCollection2, Tfs_Warehouse, ReportServer, ReportServerTempDB, Tfs_Warehouse,
Tfs_IntegationPlatformmy 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?
- Bearbeitet Kumar Raju Dienstag, 10. April 2012 19:26
Mittwoch, 11. April 2012 09:56
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!!
Donnerstag, 12. April 2012 05:48
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 :)
Dienstag, 17. April 2012 08:43Moderator
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
Vicky Song [MSFT]
MSDN Community Support | Feedback to us
- Als Antwort markiert Vicky SongModerator Donnerstag, 26. April 2012 03:09