how to prevent the data loss for SQL
Created: 24 Oct 2011 | Updated: 08 Jan 2013 | 3 comments
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
Discussion Filed Under:
Comments 3 Comments • Jump to latest comment
can u post dbclient logs from SQL server
Also post the BCH
Cheers !!!
EV Outlook Client Add-ins
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
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 give a "Thumbs Up" or mark as "Solution" if someones advice has helped you.
Would you like to reply?
Login or Register to post your comment.