How can we help you today? How can we help you today?

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

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
BILBRANDON
0

Comments

1 comment

Sort by
  • 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.
    petey
    0

Add comment

Please sign in to leave a comment.