cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Veritas.com
Support

Jobs Completed with Exception Errors?

chinh_tran_2
Not applicable

‎03-31-2006 08:28 AM

I have a daily full backup job that includes backup of SQL files. My job status showed it completed successfully but with exception... these files are included below... I tried using the Advanced Open Files option and it seems to make it worse (w/o advanced open file, it'll backup 35.5gb and with it, it'll stopped at 32gbs)

Below are the output I received, my questions are, is it necessary to backup these files or should backing up the database be good enough? and 2, if these files are necessary to completely backup my sql db, what kind of setting would i need to do in order to make it backup?

The item D:\Program Files\Good Technology\GoodLink Server\logs\STEWARTSERVER\STEWARTSERVER.access in use - skipped.
The item D:\Program Files\Good Technology\GoodLink Server\logs\STEWARTSERVER\STEWARTSERVER.diagnostics in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0000900005\SQL0000900005.Hash.gthr in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0000900005\SQL0000900005.Hash.gthr.Dir in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0000900005\SQL0000900005.Hash.gthr.h0 in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0000900005\SQL0000900005.Hash.gthr.h0.Dir in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0000900005\SQL0000900005.Hash.gthr.h1 in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0000900005\SQL0000900005.Hash.gthr.h1.Dir in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0000900005\SQL0000900005.Hash.gthr.h3 in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0000900005\SQL0000900005.Hash.gthr.h4A in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0000900005\SQL0000900005.Hash.gthr.h4A.Dir in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0000900005\SQL0000900005.Hash.gthr.h4B in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0000900005\SQL0000900005.Hash.gthr.h4B.Dir in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0000900005\SQL0000900005.Hash.gthr.idx in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0000900005\SQL0000900005.Idm.gthr in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0000900005\SQL0000900005.Ntfy1.gthr in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0000900005\Build\Indexer\CiFiles\00010009.ci in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0000900005\Build\Indexer\CiFiles\CiCL0001.000 in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0000900005\Build\Indexer\CiFiles\CiPT0000.000 in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0000900005\Build\Indexer\CiFiles\CiSL0001.000 in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0000900005\Build\Indexer\CiFiles\INDEX.000 in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0000900005\Build\Indexer\NlFiles\00000001.ps1 in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0000900005\Build\Indexer\NlFiles\00000001.ps2 in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0000900005\Build\Indexer\NlFiles\CiP10000.000 in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0000900005\Build\Indexer\NlFiles\CiP20000.000 in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0000900005\Build\Indexer\NlFiles\CiST0000.000 in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0000900005\Build\Indexer\NlFiles\DocId.Map in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0000900005\Build\Indexer\NlFiles\propstor.bk1 in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0000900005\Build\Indexer\NlFiles\propstor.bk2 in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0001000005\SQL0001000005.Hash.gthr in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0001000005\SQL0001000005.Hash.gthr.Dir in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0001000005\SQL0001000005.Hash.gthr.h0 in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0001000005\SQL0001000005.Hash.gthr.h0.Dir in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0001000005\SQL0001000005.Hash.gthr.h1 in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0001000005\SQL0001000005.Hash.gthr.h1.Dir in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0001000005\SQL0001000005.Hash.gthr.h3 in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0001000005\SQL0001000005.Hash.gthr.h4A in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0001000005\SQL0001000005.Hash.gthr.h4A.Dir in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0001000005\SQL0001000005.Hash.gthr.h4B in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0001000005\SQL0001000005.Hash.gthr.h4B.Dir in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0001000005\SQL0001000005.Hash.gthr.idx in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0001000005\SQL0001000005.Idm.gthr in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0001000005\SQL0001000005.Ntfy1.gthr in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0001000005\Build\Indexer\CiFiles\00010001.ci in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0001000005\Build\Indexer\CiFiles\CiCL0001.000 in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0001000005\Build\Indexer\CiFiles\CiPT0000.000 in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0001000005\Build\Indexer\CiFiles\CiSL0001.000 in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0001000005\Build\Indexer\CiFiles\INDEX.000 in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0001000005\Build\Indexer\NlFiles\00000001.ps1 in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0001000005\Build\Indexer\NlFiles\00000001.ps2 in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0001000005\Build\Indexer\NlFiles\CiP10000.000 in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0001000005\Build\Indexer\NlFiles\CiP20000.000 in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0001000005\Build\Indexer\NlFiles\CiST0000.000 in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0001000005\Build\Indexer\NlFiles\DocId.Map in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0001000005\Build\Indexer\NlFiles\propstor.bk1 in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0001000005\Build\Indexer\NlFiles\propstor.bk2 in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQLServer\GatherLogs\SQL0000900005.8.gthr in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQLServer\GatherLogs\SQL0001000005.8.gthr in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG in use - skipped.
The item D:\Program Files\Microsoft SQL Server\MSSQL\LOG\SQLAGENT.OUT in use - skipped.
0 Kudos
2 REPLIES 2

Jon_Rhoades
Level 4

‎03-31-2006 09:09 AM

There is an SQL agent to use to backup SQL - I would recomend getting and using that
0 Kudos

Shraddha_Dhaval
Level 6

‎04-03-2006 06:21 AM

Hi Chinh,

Yes, it is neccessary to backup these files.

Backup Exec (tm) 9.x or Backup Exec 10.0 for Windows Servers uses the Active File Exclusion feature to eliminate the SQL Server and flat-files from the file system backup. This will prevent "in use - skipped" errors on the .LOG files.

You can refer to the following doument.

http://seer.support.veritas.com/docs/242688.htm

Corrupt data, bad blocks/sectors, and excessive fragmentation on a hard disk will cause an Advanced Open File Option (AOFO) backup to fail.
The I/O device error is only one of many errors that can occur because of this.

To resolve the issue:

Run the Windows Error Checking Utility, a disk defragmentation, and check the Windows Event Viewer Logs on the machine being backed up to find out what files are causing the error to occur.


This should resolve your issue.

Please write us back if we have not understood your problem.


Thanks.

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.
0 Kudos