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

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

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

Postby sergioza » Wed Nov 13, 2013 5:14 pm

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
sergioza
 
Posts: 4
Joined: Wed Nov 13, 2013 5:07 pm

Postby Manfred.Castro » Thu Nov 14, 2013 7:38 pm

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
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm

Automatically pickup active Databases for pick up...

Postby sergioza » Thu Nov 14, 2013 11:48 pm

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
sergioza
 
Posts: 4
Joined: Wed Nov 13, 2013 5:07 pm

Postby Manfred.Castro » Fri Nov 15, 2013 12:54 am

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
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests