Default Application Backups

[BackupSysAdmin]

I noticed on the Default-Application Backups, there are only 5 files.  However it appears that for each database instance (such as WSS_Content, or BESMgt), the size is completely different. (See below).  Is there a reason for this?  My .bch file is set to create a Full backup of my SPP instance that has several databases.  Again, I am new to Netbackup and this forum has helped me out a great deal.  However, I see that I still have a long way to go.  Thanks again for you all assistance.

Client	Backup Date	Backup Time	Policy	Number of Files	Kilobytes	Schedule Name	Schedule Type	Elapsed Time	Compressed
abcd1234	5/11/2012	12:09:28 PM	ADCB_SQL_SPP_1234	5	101312	Default-Application-Backup	UBackup	0:00:48	Yes
abcd1234	5/11/2012	12:10:37 PM	ADCB_SQL_SPP_1234	5	38560	Default-Application-Backup	UBackup	0:00:47	Yes
abcd1234	5/11/2012	12:08:32 PM	ADCB_SQL_SPP_1234	5	23040	Default-Application-Backup	UBackup	0:00:40	Yes
abcd1234	5/11/2012	12:07:37 PM	ADCB_SQL_SPP_1234	5	18592	Default-Application-Backup	UBackup	0:00:39	Yes
abcd1234	5/11/2012	12:06:46 PM	ADCB_SQL_SPP_1234	5	3968	Default-Application-Backup	UBackup	0:00:35	Yes
abcd1234	5/11/2012	12:05:50 PM	ADCB_SQL_SPP_1234	5	19392	Default-Application-Backup	UBackup	0:00:39	Yes
abcd1234	5/11/2012	12:04:38 PM	ADCB_SQL_SPP_1234	5	3776	Default-Application-Backup	UBackup	0:00:56	Yes
abcd1234	5/11/2012	12:03:39 PM	ADCB_SQL_SPP_1234	5	5312	Default-Application-Backup	UBackup	0:00:38	Yes
abcd1234	5/11/2012	12:02:35 PM	ADCB_SQL_SPP_1234	5	45280	Default-Application-Backup	UBackup	0:00:45	Yes
abcd1234	5/11/2012	12:01:43 PM	ADCB_SQL_SPP_1234	5	3744	Default-Application-Backup	UBackup	0:00:36	Yes
abcd1234	5/11/2012	12:00:51 PM	ADCB_SQL_SPP_1234	5	2240	Default-Application-Backup	UBackup	0:00:35	Yes
abcd1234	5/11/2012	11:59:59 AM	ADCB_SQL_SPP_1234	5	320	Default-Application-Backup	UBackup	0:00:35	Yes
abcd1234	5/11/2012	11:59:04 AM	ADCB_SQL_SPP_1234	5	832	Default-Application-Backup	UBackup	0:00:39	Yes
abcd1234	5/11/2012	5:18:25 AM	ADCB_SQL_SPP_1234	5	196231456	Default-Application-Backup	UBackup	6:40:20	Yes

[Yasuhisa_Ishika · Accepted solution]

Jobs of  Application Backup schedule type are initiated by the application that is backed up.

I assume that you configured MS SQL Server backup.When job of Automatic Backup schedule runs, NetBackup Client on the client host commands SQL Server instance to backup databases through VDI linked with NetBackup. How jobs will be created, which data will be included in each job,  and size of each jobs are determined at SQL Server side. Size will be various, and it is normal behavior.

[Marianne]

In support of Yasuhisa's excellent post - there are more checks you can perform:

In each of those backup jobs, you can see the database name in the Overview tab of the job.
For details about each of those streams and what exactly is backed up by each of them, ensure dbclient log folder exists on the SQL client. The log wil tell you what SQL is backing up.