Ola Hallengren backup script - can I omit specific database(s) from backup

• quackhandle1975

  SSChampion

  Points: 11055

  More actions

  November 26, 2014 at 3:16 am

  #312800

  Hi,

  I am using Ola's fantastic backup/index/dbcc checkdb scripts but I have a VLDB (300GB) in amongst other dbs on the instance.

  I want to take a backup of all user dbs but not the large on, I will do this at a later time.

  I can see the code says "USER_DATABASES" but can I omit one?

  Cheers

  qh

  [font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  November 26, 2014 at 3:35 am

  #1761029

  Use this:

  @databases = 'USER_DATABASES, -YourVLDB'

  -- Gianluca Sartori

• quackhandle1975

  SSChampion

  Points: 11055

  More actions

  November 26, 2014 at 4:00 am

  #1761035

  Doh! Thanks Gianluca. :satisfied:

  qh

  [font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]