Comprehensive data protection for all workloads
Post Reply
bunger
Expert
Posts: 117
Liked: 8 times
Joined: Jun 23, 2010 5:39 pm
Full Name: Bill Unger
Contact:

Incremental: How does Veeam handle restored SQL databases?

Post by bunger » May 18, 2016 8:28 pm

I am doing reverse incremental backups nightly.

I noticed that one of my 6 servers takes about 2.5 hours to backup, while the others take that much time combined. When digging into the specifics on that one server, I am finding that we have a SQL Server database that is being restored nightly to that server. Essentially, it is a copy of another production database that is used for reporting. Each night's restoration for that database is 185GB.

Is it possible that Veeam is seeing that entire database as new and backing up the entire 185GB every night? If so, are there any other options I might employ to only backup changes to the DB instead of the entire thing?

Thanks in advance!

PTide
Product Manager
Posts: 5451
Liked: 495 times
Joined: May 19, 2015 1:46 pm
Contact:

Re: Incremental: How does Veeam handle restored SQL databas

Post by PTide » May 19, 2016 8:55 am

Hi,
Is it possible that Veeam is seeing that entire database as new and backing up the entire 185GB every night?
It is not only possible, it is the reason why your backup takes so long. May I ask you why do you need to backup the copy of a database?

Thanks!

foggy
Veeam Software
Posts: 18791
Liked: 1650 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Incremental: How does Veeam handle restored SQL databas

Post by foggy » May 19, 2016 12:09 pm

I'd place the restored DB on a separate disk and exclude it from the backup job. You do back up the original DB server, right?

bunger
Expert
Posts: 117
Liked: 8 times
Joined: Jun 23, 2010 5:39 pm
Full Name: Bill Unger
Contact:

Re: Incremental: How does Veeam handle restored SQL databas

Post by bunger » May 19, 2016 3:22 pm

Foggy - that is where I am leaning.

The vendor for that database is requiring that specific setup, so I can't get around it.

chrisdearden
Expert
Posts: 1530
Liked: 225 times
Joined: Jul 21, 2010 9:47 am
Full Name: Chris Dearden
Contact:

Re: Incremental: How does Veeam handle restored SQL databas

Post by chrisdearden » May 19, 2016 5:09 pm

You could use the file level exclusions as well.

Post Reply

Who is online

Users browsing this forum: Bing [Bot], Cornel, Google [Bot] and 39 guests