I would like to backup most of the databases except the database DBA. I use below syntax in the job step:
EXECUTE [dbo].[DatabaseBackup] @Databases = 'USER_DATABASES', '-DBA' @Directory = N'G:\BACKUP', @BackupType = 'DIFF', @Verify = 'Y', @CleanupTime = 336, @CheckSum = 'Y', @LogToTable = 'Y'
But it gives an error:
Msg 102, Sev 15, State 1, Line 3 : Incorrect syntax near '@Directory'. [SQLSTATE 42000]
I also tried:
@Databases = 'USER_DATABASES', -'DBA'
does not work either.
Can anyone help? Thanks.