1

Differential backup of new sql database fails until full backup is made

view story
linux-howto

http://serverfault.com – I have setup a job that runs every night and makes a full backup of all databases on the server. During the day, another job makes differential backups every few hours. The problem comes when a new database is created. The differential backup job fails every time, until the full backup job runs for the first time since the database was added. After that, everything runs as expected, at least until another new database is added. Of course, a differential backup doesn't make sense when there's no full backup yet, and I'm assuming that's why I'm getting an error. Question is, is there someth (HowTos)