Comments
3 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 -
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
Add comment
Please sign in to leave a comment.
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