Comprehensive data protection for all workloads
Post Reply
arosas
Enthusiast
Posts: 63
Liked: 10 times
Joined: Jun 09, 2015 9:33 pm
Full Name: Tony Rosas
Contact:

New SQL Database

Post by arosas »

When adding a new database to a SQL server, Veeam does not see it until the job is run a second time, usually we just run an active full. I searched through the forum and found an old post regarding the same. We have had the issue since we started backing up SQL DB's.

https://forums.veeam.com/post288459.htm ... se#p288459

1 VM-1Job
Daily incremental
Weekly Active Full
Log backup every 15 minutes.

When the SQL DBA adds a DB to a server, the next day we start getting the messages about transaction logs from some databases were not backed up, We then need to run an active full even though the job ran successful.

Sequence of events
Job is running log backups every 15 minutes fine.
DBA adds new DB during the day.
Backup job runs at 2am
Log backup resumes
transaction logs from some databases were not backed up messages begin
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: New SQL Database

Post by foggy »

Hi Tony, Veeam B&R should start backing up logs from the new database after the next backup job run, be it either full or incremental one. If you see different behavior, please contact technical support for a closer look.
Post Reply

Who is online

Users browsing this forum: Bing [Bot], Google [Bot], Semrush [Bot], tsightler and 147 guests