13/6/2011 18:41 El Bruno

[TFS2010] Script para eliminar las bases de datos de Team Foundation (con cuidado che!)

image47dd1de4

Buenas,

ayer comenté como restaurar un BackUp de Team Foundation Server 2010. Sin embargo en el paso 5, debíamos eliminar todas las bases de datos relacionadas con Team Foundation, incluyendo Reporting Services y Sharepoint. Esto que puede hacerse desde SQL Server Management Studio con un par de clicks, también puede hacerse con el siguiente script:

   1: EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N'ReportServer'
   2: GO
   3: USE [master]
   4: GO
   5: ALTER DATABASE [ReportServer] SET  SINGLE_USER WITH ROLLBACK IMMEDIATE
   6: GO
   7: USE [master]
   8: GO
   9: /****** Object:  Database [ReportServer]    Script Date: 06/12/2011 12:56:39 ******/
  10: DROP DATABASE [ReportServer]
  11: GO
  12: EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N'ReportServerTempDB'
  13: GO
  14: USE [master]
  15: GO
  16: /****** Object:  Database [ReportServerTempDB]    Script Date: 06/12/2011 12:56:39 ******/
  17: DROP DATABASE [ReportServerTempDB]
  18: GO
  19: EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N'TailspinToys'
  20: GO
  21: USE [master]
  22: GO
  23: /****** Object:  Database [TailspinToys]    Script Date: 06/12/2011 12:56:39 ******/
  24: DROP DATABASE [TailspinToys]
  25: GO
  26: EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N'Tfs_ALMBook'
  27: GO
  28: USE [master]
  29: GO
  30: ALTER DATABASE [Tfs_ALMBook] SET  SINGLE_USER WITH ROLLBACK IMMEDIATE
  31: GO
  32: USE [master]
  33: GO
  34: /****** Object:  Database [Tfs_ALMBook]    Script Date: 06/12/2011 12:56:39 ******/
  35: DROP DATABASE [Tfs_ALMBook]
  36: GO
  37: EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N'Tfs_Configuration'
  38: GO
  39: USE [master]
  40: GO
  41: ALTER DATABASE [Tfs_Configuration] SET  SINGLE_USER WITH ROLLBACK IMMEDIATE
  42: GO
  43: USE [master]
  44: GO
  45: /****** Object:  Database [Tfs_Configuration]    Script Date: 06/12/2011 12:56:39 ******/
  46: DROP DATABASE [Tfs_Configuration]
  47: GO
  48: EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N'Tfs_DefaultCollection'
  49: GO
  50: USE [master]
  51: GO
  52: /****** Object:  Database [Tfs_DefaultCollection]    Script Date: 06/12/2011 12:56:39 ******/
  53: DROP DATABASE [Tfs_DefaultCollection]
  54: GO
  55: EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N'Tfs_Warehouse'
  56: GO
  57: USE [master]
  58: GO
  59: /****** Object:  Database [Tfs_Warehouse]    Script Date: 06/12/2011 12:56:39 ******/
  60: DROP DATABASE [Tfs_Warehouse]
  61: GO
  62: EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N'WSS_AdminContent'
  63: GO
  64: USE [master]
  65: GO
  66: /****** Object:  Database [WSS_AdminContent]    Script Date: 06/12/2011 12:56:39 ******/
  67: DROP DATABASE [WSS_AdminContent]
  68: GO
  69: EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N'WSS_Config'
  70: GO
  71: USE [master]
  72: GO
  73: /****** Object:  Database [WSS_Config]    Script Date: 06/12/2011 12:56:39 ******/
  74: DROP DATABASE [WSS_Config]
  75: GO
  76: EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N'WSS_Content'
  77: GO
  78: USE [master]
  79: GO
  80: /****** Object:  Database [WSS_Content]    Script Date: 06/12/2011 12:56:39 ******/
  81: DROP DATABASE [WSS_Content]
  82: GO

 

Obviamente no hace ni falta que advierta que hay que utilizar este script con precaución. El mismo se puede descargar desde

Saludos @ Here

El Bruno

   

Archivado en: ,
Comparte este post: