Screencasts - Hilfsvideos

how to prevent the data loss for SQL

Created: 24 Okt. 2011 • Aktualisiert: 08 Jan. 2013 | 3 Kommentare
das Bild der Jojies
Dieses Problem wurde gelöst. Siehe Lösung.

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

Kommentare KommentareZum neuesten Kommentar

das Bild der V4s

can u post dbclient logs from SQL server

Also post the BCH

das Bild der Mariannes

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

LÖSUNG
das Bild der Mark_Solutionss

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!!.