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

BILBRANDONBILBRANDON Posts: 2
edited January 14, 2011 7:23PM in SQL Backup Previous Versions
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
· Share on Twitter

Comments

  • peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
Sign In or Register to comment.