Post reply

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

  • 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]

  • November 26, 2014 at 3:35 am

    #1761029

    Use this:

    @databases = 'USER_DATABASES, -YourVLDB'

    -- Gianluca Sartori

  • 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]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply