TSM backups hanging

[brianfulcher15]

Hey guys, I have a server that the backups are hanging on. Please help if you can. I only have client side access so please bear with me

Specs
Client 5,5,0
server 5,4,1.2
Windows server 2003 sp1
TOE is disabled
RSS is enabled
Speed/duplex is set correctly

Here are the last parts of the logs

SchedLOG

03/28/2009 03:45:12 ANS1228E Sending of object '\\servername\d$\Microsoft SQL Server\MSSQL\Data\templog.ldf' failed
03/28/2009 03:45:12 ANS4987E Error processing '\\servername\d$\Microsoft SQL Server\MSSQL\Data\templog.ldf': the object is in use by another process
03/28/2009 03:45:12 ANS1802E Incremental backup of '\\servername\d$' finished with 12 failure
03/28/2009 03:45:16 ANS1898I ***** Processed 5,500 files *****
03/28/2009 03:45:17 ANS1898I ***** Processed 6,500 files *****
03/28/2009 03:45:18 ANS1898I ***** Processed 7,500 files *****
03/28/2009 03:45:18 Directory--> 0 \\servername\e$\SQLBACKUP\Data\C2DB [Sent]
03/28/2009 03:45:18 Directory--> 0 \\servername\e$\SQLBACKUP\Data\DBATools Changed
03/28/2009 03:45:18 Retry # 1 Directory--> 0 \\servername\e$\SQLBACKUP\Data\C2DB [Sent]
03/28/2009 03:45:18 Retry # 1 Directory--> 0 \\servername\e$\SQLBACKUP\Data\DBATools [Sent]
03/28/2009 03:45:18 Directory--> 0 \\servername\e$\SQLBACKUP\Data\master Changed
03/28/2009 03:45:18 Retry # 2 Directory--> 0 \\servername\e$\SQLBACKUP\Data\DBATools [Sent]
03/28/2009 03:45:18 Retry # 1 Directory--> 0 \\servername\e$\SQLBACKUP\Data\master [Sent]
03/28/2009 03:45:18 Directory--> 0 \\servername\e$\SQLBACKUP\Data\model Changed
03/28/2009 03:45:18 Retry # 2 Directory--> 0 \\servername\e$\SQLBACKUP\Data\master [Sent]
03/28/2009 03:45:18 Retry # 1 Directory--> 0 \\servername\e$\SQLBACKUP\Data\model [Sent]
03/28/2009 03:45:18 Directory--> 0 \\servername\e$\SQLBACKUP\Data\msdb Changed
03/28/2009 03:45:20 Retry # 2 Directory--> 0 \\servername\e$\SQLBACKUP\Data\model [Sent]
03/28/2009 03:45:20 Retry # 1 Directory--> 0 \\servername\e$\SQLBACKUP\Data\msdb [Sent]
03/28/2009 03:45:20 Expiring--> 3,080,011,264 \\servername\e$\SQLBACKUP\Data\C2DB\C2DB_20090326001500.BAK [Sent]



opt file


PASSWORDACCESS GENERATE
TCPSERVERADDRESS TSMserver.lnc.com
ERRORLOGName "c:\Program Files\Tivoli\TSM\baclient\dsmerror.log"
ERRORLOGRetention 15 D
SCHEDLOGName "c:\Program Files\Tivoli\TSM\baclient\dsmsched.log"
SCHEDLOGRetention 15 D
TCPBUFFSIZE 512
TCPWINDOWSIZE 2048
MANAGEDSERVICES WEBCLIENT
EXCLUDE.BACKUP "*:\microsoft uam volume\...\*"
EXCLUDE.BACKUP "*:\microsoft uam volume\...\*.*"
EXCLUDE.BACKUP "*:\...\EA DATA. SF"
EXCLUDE.BACKUP "*:\IBMBIO.COM"
EXCLUDE.BACKUP "*:\IBMDOS.COM"
EXCLUDE.BACKUP "*:\IO.SYS"
EXCLUDE.BACKUP "*:\...\system32\config\...\*"
EXCLUDE.BACKUP "*:\...\system32\Perflib*.dat"
EXCLUDE.BACKUP "*:\...\system32\dhcp\...\*"
INCLUDE.BACKUP "*:\...\system32\dhcp\backup\...\*"
EXCLUDE.BACKUP "*:\...\system32\dns\...\*"
INCLUDE.BACKUP "*:\...\system32\dns\backup\...\*"
EXCLUDE.ARCHIVE "*:\microsoft uam volume\...\*"
EXCLUDE.ARCHIVE "*:\microsoft uam volume\...\*.*"
EXCLUDE.ARCHIVE "*:\...\EA DATA. SF"
EXCLUDE.ARCHIVE "*:\IBMBIO.COM"
EXCLUDE.ARCHIVE "*:\IBMDOS.COM"
EXCLUDE.ARCHIVE "*:\IO.SYS"
EXCLUDE.ARCHIVE "*:\...\system32\config\...\*"
EXCLUDE.ARCHIVE "*:\...\system32\Perflib*.dat"
EXCLUDE.ARCHIVE "*:\...\system32\dhcp\...\*"
INCLUDE.ARCHIVE "*:\...\system32\dhcp\backup\...\*"
EXCLUDE.ARCHIVE "*:\...\system32\dns\...\*"
INCLUDE.ARCHIVE "*:\...\system32\dns\backup\...\*"
EXCLUDE.DIR "*:\System Volume Information"
EXCLUDE.DIR "*:\...\Temporary Internet Files"
EXCLUDE.DIR "*:\Recycled"
EXCLUDE.DIR "*:\Recycler"
EXCLUDE.DIR "*:\$Recycle.Bin"
EXCLUDE.DIR "E:\CSQUARED"

 

[chad_small]

You need to exclude the ldf and mdf files from SQL. Is that BAK file at the end a DB dump? I can't say for sure why it's hanging. Could be a server side issue, because nothing indicates as to why it would hang.

 

[brianfulcher15]

any links to a howto guide to exclude those.

any way to tell if they have been excluded?

 

[chad_small]

We do it using a client option set, but it's the same exclude either way:

Option Seq Force Option Value
------------------ ----- ------ ----------------------
INCLEXCL 25 No Exclude *:\...\*.mdf
INCLEXCL 26 No Exclude *:\...\*.ldf
INCLEXCL 27 No Exclude *:\...\*.ndf

 

[brianfulcher15]

what are the numbers for? i have never really messed with sql...

 

[chad_small]

Ignore everything except the exclude unless you plan to use it in a client options set.