Date - 01/2008
Affected Product & Version - NetVault: Backup 7.4.5 and later
Affected Module & Version - APM for Sybase (Version 5.0)
OS Version - All supported platform
Application Information - 12.5.2 and later (15.x is not supported)
Description:
Sybase DB backup job hangs during backup.
Symptoms:
Sybase db backup hangs during backup when the database is inconsistent. For example, job hangs while dumping data as follows -
Dump xxxx kilobytes DUMPED
Dump yyyy kilobytes DUMPED
Put Sybase ASE service to single user mode so that no other user is active.
1. Login to isql.
2. Use sp_dboption command to change DB mode to single user mode -
1> use master
2> go
1> sp_dboption testdb,"single user",true
2> go
1> checkpoint
2> go
3. Use DBCC utility (such as "dbcc checkdb", "dbcc checkalloc", "dbcc tablealloc" etc) and check DB consistency.
4. Change DB status back to multi user mode as required. See above step [2] and change true to false to switch DB mode back to multi user mode.
5. Make sure no error is returned and then try the backup again.
