SQL.log file is increasing

[prodyot_dutta]

Hi

I am running Veritas Backup exec 9.1 with 2 agent and OFO license for windows servers.
Currently by backup is running quite normally but the log i.e SQL.log file is increasing day by day and its about to reach the disk space.Can anyone help me to resolve this problem or change the location of sql.log to another drive.The log states like this.
...............................................................................................
sqlagent 15e-16bENTER SQLAllocHandle
SQLSMALLINT 1
SQLHANDLE 00000000
SQLHANDLE * 00EFD6CC

sqlagent 15e-16bEXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 1
SQLHANDLE 00000000
SQLHANDLE * 0x00EFD6CC ( 0x00d01478)

sqlagent 15e-16bENTER SQLSetEnvAttr
SQLHENV 00D01478
SQLINTEGER 200
SQLPOINTER 0x00000003
SQLINTEGER -5

sqlagent 15e-16bEXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 00D01478
SQLINTEGER 200
SQLPOINTER 0x00000003 (BADMEM)
SQLINTEGER -5

sqlagent 15e-16bENTER SQLAllocHandle
SQLSMALLINT 2
SQLHANDLE 00D01478
SQLHANDLE * 00EFD6D0

sqlagent 15e-16bEXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 2
SQLHANDLE 00D01478
SQLHANDLE * 0x00EFD6D0 ( 0x00d01520)

sqlagent 15e-16bENTER SQLSetConnectAttrW
SQLHDBC 00D01520
SQLINTEGER 103
SQLPOINTER 0x0000001E
SQLINTEGER -5
................................................................................................

Regards..

Prodyot Dutta

[Simon_Armstrong]

What agents are installed? I take it one of them is the SQL agent?

You can reduce the size of your transaction logs by truncating them via the backup and then shrinking them (see links below):
http://seer.support.veritas.com/docs/270043.htm
http://seer.support.veritas.com/docs/253528.htm

[Deepali_Badave]

Hello,


Do not take transaction log or differential backup of Master database as it does not support it. Also keep the recovery model of other databases to Full when taking a transaction log backup.

NOTE : If we do not receive your reply within two business days, this post would be marked assumed answered and would be moved to answered questions pool.