Sample progress report

Table: Progress report for NetBackup for SQL Server backup shows a typical progress report that is created for a database backup.

Table: Progress report for NetBackup for SQL Server backup

Line	Text
1	OPERATION backup
2	Database "DatabaseA"
3	SQLHOST "JUY"
4	SQLINSTANCE "NEWINSTANCE"
5	NBSERVER "JUY"
6	MAXTRANSFERSIZE 0
7	BLOCKSIZE 0
8	ENDOPER TRUE
9	INF - BACKUP started using
10	Microsoft SQL Server Yukon - 9.00.852 (Intel X86)
11	Jul 19 2004 22:09:12
12	Copyright (c) 1988-2003 Microsoft Corporation
13	Beta Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
14	Batch = C:\Program Files\Veritas\NetBackup\dbext\mssql\temp\__09_42_24_076_00.bch, Op# = 1
15	INF - Using backup image juy.MSSQL7.JUY\NEWINSTANCE.db.DatabaseA.~.7.001of001.20060701094227..C
16	INF - backup database "DatabaseA" to VIRTUAL_DEVICE='VNBU0-5652-1224-1120228947' with stats = 10, blocksize = 65536, maxtransfersize = 65536, buffercount = 1
17	INF - Number of stripes: 1, Number of buffers per stripe 1.
18	12:41:07 Initiating backup
19	12:41:10 INF - Starting bpbrm
20	12:41:12 INF - Data socket = juy.domain.com.4146
21	12:41:12 INF - Name socket = juy.domain.com.1527
22	12:41:12 INF - Job ID = 143
23	12:41:12 INF - Backup ID = juy_1058982070
24	12:41:12 INF - Backup time = 1058982070
25	12:41:12 INF - Policy name = SQL
26	12:41:12 INF - Snapshot = 0
27	12:41:12 INF - Frozen image = 0
28	12:41:12 INF - Backup copy = 0
29	12:41:12 INF - Master server = juy
30	12:41:12 INF - Media server = juy
31	12:41:12 INF - Multiplexing = 0
32	12:41:12 INF - New data socket = juy.domain.com.1388
33	12:41:12 INF - Use shared memory = 1
34	12:41:12 INF - Compression = 0
35	12:41:12 INF - Encrypt = 0
36	12:41:12 INF - Client read timeout = 300
37	12:41:12 INF - Media mount timeout = 0
38	12:41:16 INF - Data buffer size = 262144
39	12:41:18 INF - Beginning backup on server juy of client juy
40	INF - Thread has been closed for stripe #0
41	12:41:25 INF - Server status = 0
42	12:41:26 INF - Backup by hao on client juy using policy SQL: the requested operation was successfully completed.

Observe the following:

Lines 1 to 8 contain the batch syntax which drove this operation. This operation was started from a batch file that the GUI created.
Line 9 indicates that the operation was a backup ("Dump"). The term 'Load' would indicate a restore.
Lines 10-13 provide the version of SQL Server and the Windows operating system.
Line 14 provides the name of the batch file. Since the backup was launched immediately, it was placed in install_path\NetBackup\DbExt\MsSql\Temp directory.
Line 16 provides the actual SQL syntax that was used to launch the backup command.
Line 17 indicates that this backup was a single stream backup.
Lines 18 to 42 provide NetBackup-based client parameters and statuses. Note that the server status on line 40 indicates that the operation was completed with status 0, which indicates success.