HI!
I got the report by following:
2012-04-13 00:10 ANR2578W Schedule SQL_LOGS in domain MSSQL for node DB01_MSSQL has missed its scheduled start up window.
2012-04-13 01:00 ANR2578W Schedule SQL_FULL in domain MSSQL for node DB01_MSSQL has missed its scheduled start up window.
I have installed the agent Dataprotection for SQL server ver 5.5.5.1 (64 bit) at win2008server. TSM server is 5.5.1.0.
I have tested manually backup at DP SQL Agent without problem.
This node DB01_MSSQL is already assocated to both SQL_FULL and SQL_LOGS.
tsm: BACKUP01_SERVER1>q assoc
Session established with server BACKUP01_SERVER1: Windows
Server Version 5, Release 5, Level 1.0
Server date/time: 04/13/2012 09:06:55 Last access: 04/13/2012 08:29:29
Policy Domain Name: MSSQL
Schedule Name: SQL_FULL
Associated Nodes: CSS-DB01_MSSQL DB-WIN-01_MSSQL DB01_MSSQL SCCM01_MSSQL
Policy Domain Name: MSSQL
Schedule Name: SQL_LOGS
Associated Nodes: CSS-DB01_MSSQL DB-WIN-01_MSSQL DB01_MSSQL SCCM01_MSSQL
Here is the schedule plan:
tsm: BACKUP01_SERVER1>q sche mssql
Domain * Schedule Name Action Start Date/Time Duration Period Day
------------ - ---------------- ------ -------------------- -------- ------ ---
MSSQL SQL_FULL CMD 11/07/2008 21:00:00 4 H 1 D WD
MSSQL SQL_LOGS CMD 11/07/2008 00:00:00 10 M 4 H Any
Here is nodelist:
tsm: BACKUP01_SERVER1>q node
Node Name Platform Policy Domain Days Since Days Since Locked?
Name Last Acce- Password
ss Set
------------------------- -------- -------------- ---------- ---------- -------
DB01 WinNT STANDARD <1 14 No
DB01_MSSQL TDP MSS- MSSQL <1 14 No
QL Win-
64
The service TSM MSSQL scheduler was tried to restart serveral times at client and still no result.
The dsm.opt file:
NODename db01_mssql
CLUSTERnode no
COMPRESSIon Off
PASSWORDAccess Generate
COMMMethod TCPip
TCPPort 1500
TCPServeraddress 10.10.10.172
TCPWindowsize 63
TCPBuffSize 32
SCHEDMODE Polling
schedlogname dsmsched_mssql.log
errorlogname dsmerr_mssql.log
schedlogRetention 14,d
errorlogRetention 14,d
INCLUDE "\...\meta\...\*" SqlDbMeta
INCLUDE "\...\data\...\*" SqlDbData
INCLUDE "\...\meta\...\log*" SqlLogMeta
INCLUDE "\...\data\...\log*" SqlLogData
I don't find any interest information at error logs (I can send the logs if needed).
The batch-files at client is still there sqlfull.cmd and sqllog.cmd at c:\ directory.
I need help, any ideas please?
JOJO.
I got the report by following:
2012-04-13 00:10 ANR2578W Schedule SQL_LOGS in domain MSSQL for node DB01_MSSQL has missed its scheduled start up window.
2012-04-13 01:00 ANR2578W Schedule SQL_FULL in domain MSSQL for node DB01_MSSQL has missed its scheduled start up window.
I have installed the agent Dataprotection for SQL server ver 5.5.5.1 (64 bit) at win2008server. TSM server is 5.5.1.0.
I have tested manually backup at DP SQL Agent without problem.
This node DB01_MSSQL is already assocated to both SQL_FULL and SQL_LOGS.
tsm: BACKUP01_SERVER1>q assoc
Session established with server BACKUP01_SERVER1: Windows
Server Version 5, Release 5, Level 1.0
Server date/time: 04/13/2012 09:06:55 Last access: 04/13/2012 08:29:29
Policy Domain Name: MSSQL
Schedule Name: SQL_FULL
Associated Nodes: CSS-DB01_MSSQL DB-WIN-01_MSSQL DB01_MSSQL SCCM01_MSSQL
Policy Domain Name: MSSQL
Schedule Name: SQL_LOGS
Associated Nodes: CSS-DB01_MSSQL DB-WIN-01_MSSQL DB01_MSSQL SCCM01_MSSQL
Here is the schedule plan:
tsm: BACKUP01_SERVER1>q sche mssql
Domain * Schedule Name Action Start Date/Time Duration Period Day
------------ - ---------------- ------ -------------------- -------- ------ ---
MSSQL SQL_FULL CMD 11/07/2008 21:00:00 4 H 1 D WD
MSSQL SQL_LOGS CMD 11/07/2008 00:00:00 10 M 4 H Any
Here is nodelist:
tsm: BACKUP01_SERVER1>q node
Node Name Platform Policy Domain Days Since Days Since Locked?
Name Last Acce- Password
ss Set
------------------------- -------- -------------- ---------- ---------- -------
DB01 WinNT STANDARD <1 14 No
DB01_MSSQL TDP MSS- MSSQL <1 14 No
QL Win-
64
The service TSM MSSQL scheduler was tried to restart serveral times at client and still no result.
The dsm.opt file:
NODename db01_mssql
CLUSTERnode no
COMPRESSIon Off
PASSWORDAccess Generate
COMMMethod TCPip
TCPPort 1500
TCPServeraddress 10.10.10.172
TCPWindowsize 63
TCPBuffSize 32
SCHEDMODE Polling
schedlogname dsmsched_mssql.log
errorlogname dsmerr_mssql.log
schedlogRetention 14,d
errorlogRetention 14,d
INCLUDE "\...\meta\...\*" SqlDbMeta
INCLUDE "\...\data\...\*" SqlDbData
INCLUDE "\...\meta\...\log*" SqlLogMeta
INCLUDE "\...\data\...\log*" SqlLogData
I don't find any interest information at error logs (I can send the logs if needed).
The batch-files at client is still there sqlfull.cmd and sqllog.cmd at c:\ directory.
I need help, any ideas please?
JOJO.