Incremental backup is too big

[us2001irvine]

Question 1:

To do the incremental backup, some servers (with little or no activity) take 1GB more space while the web and database servers take 3-5GB each per incremental backup job in a day or in several hours interval. Is this normal? And how to correct this problem?

(The full backup of a server is 1.4GB whereas the incremental backup is 1.06GB)


Question 2:

When backing up SQL server, the incremental selection results error of asking to backup master database. Is SQL server incremental backup function working? What am I missing here?

Thanks.

 

[justin2000]

Not sure what you are doing with yoour incrementals.

Make sure you are choosing to do a full backup - not the full backup - so you can use incremental modified time - hope that makes sense.

You can do an incremental ie. log backup of the SQL master database because the database recovery model is Simple - with a database recovery model of simple you can only do Full backups.

 

[LaChimere]

go in your incremental job. go in the properties, go in the general option, In the Backup method, make sure you are choosing Incremental with Change File - Reset Archive Bit
U r Probably using the following INCREMENTAL Using modified time

 

[LaChimere]

for the second part, make sure your credential to access your master database are ok

 

[us2001irvine]

Thanks, Justin and LaChimere for both of your kind help.

My incremental backup seems normal now with xxx MB/per server. The only thing that I can recall is that the disk is out of space, and also I may not configure the setting properly. Anyway, it is fine now.

Thanks again.

 

[us2001irvine]

Forget about my 2nd question:

We need to do full backup for SQL server, even though we select incremental backup method. Thanks Veritas tech support for helping me out on this.

Backup method: Incremental
SQL: full backup.