What are the challenges you face when working across database platforms? Take the survey
Options

Automatically include new databases in backup job

hotspexhotspex Posts: 7
edited April 18, 2013 11:45AM in SQL Backup Previous Versions
Hi,

I created a new scheduled backup job. And I selected "Include these: All". This selected all of my existing databases, User and System. The backup job works as expected.

Now, we have a web application that automatically creates databases when someone (application user) creates a new project through the application GUI. Also, after "n" number of days of inactivity, the application knows to detach the inactive databases.

My question is: Does the backup job know to include the newly created databases? And does it know not to backup the detached databses? Or do I need to always be updating my backup job to make sure any changes (additions, deletions) need to be accounted for?

thanks
Hani

Comments

Sign In or Register to comment.