how to prevent the data loss for SQL

[Jojie]

hi,

Can anyone help me to solve this problem. i got an error while backing up the SQL Database. All the database is successful except this 2 database. Please see the error logs below.

TIMESTAMP 20111024021820
MASTERSERVER STARS01PRDBK01
CLIENT STARS01PRDDB01
INSTANCE STARS01PRDDB04
DATABASE EFDSAdmin
OPERATION BACKUP
OBJECTTYPE DATABASE
OPTION INCREMENTAL
STATUS -1
INFO Error <EFDSAdmin> is involved in another operation.
ENDOPER TRUE
TIMESTAMP 20111024022417
MASTERSERVER STARS01PRDBK01
CLIENT STARS01PRDDB01
INSTANCE STARS01PRDDB04
DATABASE K2Categories
OPERATION BACKUP
OBJECTTYPE DATABASE
OPTION INCREMENTAL
STATUS -1
INFO Error <K2Categories> is involved in another operation.
ENDOPER TRUE

[V4]

can u post dbclient logs from SQL server

Also post the BCH

[Marianne · Accepted solution]

SQL dba's doing disk backups?

You will need to have a look at SQL logs find out what 'other operations' are taking place.

SQL logs: SQL error logs (ERRORLOG usually located in <install_path>\mssql\log), the VDI log  (vdi.log usually in  <install_path>\mssql\log), and the Application Event Viewer log.

[Mark_Solutions]

Please post the logs from:

\veritas\netbackup\logs\mssql_backup_failures\

and

\veritas\netbackup\logs\user_ops\mssql\logs\

It sounds like you SQL DBAs may be running maintenance of their own (SQL Dumps) which can conflict with the NetBackup ones.

Also check the event logs at the tome of the failure for more clues