Home Forums SQL Server 2008 SQL Server 2008 - General need a solution to backup if a new database is added RE: need a solution to backup if a new database is added
dbafromthecold@gmail.com
SSChampion
Points: 10160
More actions
November 27, 2014 at 2:44 am
#1761230
How about polling the sys.databases table (via a SQL Server Agent job) and checking the create_date column based on a specified time frame.
You could then backup any databases that are return by the initial query.