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

sergioza

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

Manfred.Castro

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

sergioza

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

Manfred.Castro

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