User Database Back-ups Jobs - Must Modify When DB is Added?

BILBRANDON

We are new to SQL Backup and have just started setting up jobs. I have noticed that choosing User databases when creating a back-up job will add all of the CURRENT user databases to the job. But, you need to update the job every time a database is added. Is there a way to have it automatically pick up all user databases without specifying them by name in the T-SQL script it creates?


Thanks,
Bil

petey

You could use the USER qualifier e.g.

EXEC master..sqlbackup '-sql "BACKUP USER DATABASES TO DISK = [<AUTO>]"'

You'll need to amend the script manually though.