By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,688 Members | 1,888 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,688 IT Pros & Developers. It's quick & easy.

about incremental backup

P: n/a
HI,

I had a question on incremental backup.

We had an incremental backup every weekend. We did full backup every
other week. That is one week incremental + full , the other week is
incremental only. My question is for the first weekend incremental
backup, it took for example 1h, but the second weekend incremental
took almost 3 hours. It seems always this way, so I suppose it is not
related to the data change. And we almost had some amount data change
every week. I had no idea why the incremental backup took so much time
for the second weekend.

Just clarify that I did the incremental backup, not incremental delta
backup.

Any suggestion is very appreciated.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Incremental backup has to scan the header of every page to see if the
page has changed. Incremental backup is also not sensitive to LOBs -
they all get backed up whether they change or not. Your page size is
somewhere beteen 4K and 32K, so based on database size, you can
calculate how many pages have to be scanned.

jane wrote:
HI,

I had a question on incremental backup.

We had an incremental backup every weekend. We did full backup every
other week. That is one week incremental + full , the other week is
incremental only. My question is for the first weekend incremental
backup, it took for example 1h, but the second weekend incremental
took almost 3 hours. It seems always this way, so I suppose it is not
related to the data change. And we almost had some amount data change
every week. I had no idea why the incremental backup took so much time
for the second weekend.

Just clarify that I did the incremental backup, not incremental delta
backup.

Any suggestion is very appreciated.


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.