script

• ramyours2003

  SSChampion

  Points: 12268

  More actions

  March 5, 2012 at 3:53 am

  #258114

  i have more thann 30 Dataabses starting with How to take backup of all the databases starting with H*

• HowardW

  One Orange Chip

  Points: 29109

  More actions

  March 5, 2012 at 4:26 am

  #1454721

  You could easily build your own backup script and use the sys.databases system view to filter out names as required.

  Or, you could use something like Ola's backup scripts which support a wildcard for the @Databases parameter (@Databases = 'H%'):

  http://ola.hallengren.com/sql-server-backup.html