Any Way to Configure Include and Exclude DBs. ...

sergiozasergioza Posts: 9
edited November 14, 2013 6:54PM in SQL Backup Previous Versions
Hi,

I may be missing something, but is there an option when creating "Scheduled Backup Job" to Configure RedGate Backup to Automatically Include New Dbs
to be backed up and exclude the ones which were deleted on the Server?

Many Thanx

Comments

  • You could use the All or USER option to to backup all or all user databases.
    Unfortunately these options are not available from the UI as the UI will script out all the database names.
    You will have to manually edit the job step in SQL Server Agent.

    http://documentation.red-gate.com/displ ... ESargument
    Manfred Castro
    Product Support
    Red Gate Software
  • The idea behind using "RedGate" was to automate backups as much as possible.

    so, GUI doesn't allow to specify all and script will get regenerated?


    it means that i need to go to GUI daily on each Server and check "All"?

    or instead of

    EXECUTE master..sqlbackup '-SQL "BACKUP DATABASES [master,model,...

    I can somehow specify all?

    if not, is this option in new release?

    Thank You

    S
  • In the GUI when you check the ALL check box it will script out all the names of the databases.

    EXECUTE master..sqlbackup '-SQL "BACKUP DATABASES [master,model,msdb,db1,db2......

    You can edit the job so that it uses the ALL argument or * wildcard.

    EXECUTE master..sqlbackup '-SQL "BACKUP ALL DATABASES

    or

    EXECUTE master..sqlbackup '-SQL "BACKUP DATABASES [*]

    There are no plans to change this behavior in new or future releases
    Manfred Castro
    Product Support
    Red Gate Software
Sign In or Register to comment.