Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

how to prevent the data loss for SQL

Created: 24 Oct 2011 • Updated: 08 Jan 2013 | 3 comments
Jojie's picture
This issue has been solved. See solution.

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

Comments 3 CommentsJump to latest comment

captain jack sparrow's picture

can u post dbclient logs from SQL server

Also post the BCH

 Cheers !!!

CJS

Marianne's picture

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.

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

SOLUTION
Mark_Solutions's picture

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

Authorised Symantec Consultant

Don't forget to "Mark as Solution" if someones advice has solved your issue - and please bring back the Thumbs Up!!.