Symantec Backup Exec 2012 y servidor SQL server con SQLExpress 2005 SP2,

Tenemos una instalación en servidor Dell con Windows Server 2008 y Symantec Backup Exec 2012, conectados a Unidad Robotica Dell TL2000 via iSCSI la cual esta funcionando correctamente, estamos realizando backup's de 5 servidores incluyendo el servidor de backup exec, uno de ellos es un servidor SQL server con SQLExpress 2005 SP2, al momento de realizar la tarea de Backup del servidor de SQLExpress, nos arroja un warning de no poder ejecutar dicha tarea porque la integridad fisica y logica de las BD's esta dando error. Ya hicimos las pruebas de Integridad Fisica y logicas, de las DB's. y sigue dando el servidor SQL server con SQLExpress 2005 SP2, al momento de realizar la tarea de Backup del servidor de SQLExpress, un mensaje de error o alerta.

Si ya realizamos la revision de las BD's se les aplico el comando de chequeo de integridad y no arrojaron ningun problema de inconsistencia.

Especificamente que esta causando esa alerta, ?

1) un problema de configuracion de Symantec Back Exec 2012

2) un problema de funcionamimento de la Unidad Robotica Dell TL 2000.

3) Y mas importante como corregir?

Gracias

Windows Server (2003-2008)

Sush---
12 years ago
Please refer to the following technotes that may help

http://www.symantec.com/docs/TECH179267 : SQL backup fails with error : V-79-57344-65085 - There was a problem running the DBCC. The operating system returned error 1117(The request could not be performed because of an I/O device error.)

http://www.symantec.com/docs/TECH144229 : SQL Backup fail with error "Final error: 0xe0008443 - One or more SQL Database consistency checks have failed"

http://www.symantec.com/docs/TECH53367 : Error "0xe0008443 - One or more SQL Database consistency checks have failed" appears in the backup job log while backing up Microsoft SQL Server or SQL databases.

http://www.symantec.com/docs/TECH128858 : Backup fails with "0xe0008443 - One or more SQL Database consistency checks have failed" error.

Thanks,

-Sush...

13 Replies

CraigV
Moderator
12 years ago
Can you post the exact error message?
VJware
Level 6
12 years ago
Backup Exec account permissions to backup SQL dBs can also cause this issue. Ensure the Backup Exec logon account is added in SQL logins & has sysadmin, db_owner permissions to backup (and run a consistency check) of the SQL dBs.
Sush---
Level 6
12 years ago
Hello there,

Backup Exec uses SQL VDI to backup the SQL databases. So you may also try to manually take the backups from SQL Management console and see if you still get the errors during the manual backups.

Right steps are... right click on the database in the SQL Mangement console>> Task>> Backups.

It would be more helpful if you provide the exact error as mentioned by CraigV.

Thanks,

-Sush...
Safety2012
Level 3
12 years ago

This is the summary of my case:

Exact Error: V-79-57344-65085

We have an installation on Dell server with Windows Server 2008 and Symantec Backup Exec 2012, connected to Unit Robotics Dell TL2000 via iSCSI which is working correctly, we are making backup from 5 servers including server backup exec, one of them is a SQL server SQLExpress 2005 server with SP2, the time of the backup task SQLExpress server, gives a warning to us not to be able to run this task because the physical and logical integrity of the BD's is giving error. I did tests Physical and logical integrity of the DB's. and continues to the SQL server with SQLExpress 2005 SP2, when performing the backup task SQLExpress server, an error message or warning.

Specifically what is causing this alert?

1) a configuration of Symantec Back Exec 2012

2) an issue of Robotica Unit funcionamimento Dell TL 2000.

3) And most importantly how to correct?

Thank
Safety2012
Level 3
12 years ago

I was able to back up without the review of integrity so do not think it's permissions.

What else can it be?

This is the exact Error: V-79-57344-65085
Safety2012
Level 3
12 years ago

hi

thank for your kind answer

This is the exac error: V-79-57344-65085
Sush---
Level 6
12 years ago
Please refer to the following technotes that may help

http://www.symantec.com/docs/TECH179267 : SQL backup fails with error : V-79-57344-65085 - There was a problem running the DBCC. The operating system returned error 1117(The request could not be performed because of an I/O device error.)

http://www.symantec.com/docs/TECH144229 : SQL Backup fail with error "Final error: 0xe0008443 - One or more SQL Database consistency checks have failed"

http://www.symantec.com/docs/TECH53367 : Error "0xe0008443 - One or more SQL Database consistency checks have failed" appears in the backup job log while backing up Microsoft SQL Server or SQL databases.

http://www.symantec.com/docs/TECH128858 : Backup fails with "0xe0008443 - One or more SQL Database consistency checks have failed" error.

Thanks,

-Sush...
Safety2012
Level 3
12 years ago

Hi

Thank for your kind answer and comment.

This is the exact error: V-79-57344-65085

I appreciatte your cfeedback
Safety2012
Level 3
12 years ago

currently we are doing backed up manually in any problem.

The point is we buy back exec to automate and support save more reliable as tape drive.

And it gives us the error V-79-57344-65085

appreciatte feedback
Sush---
Level 6
12 years ago
Hello there,

The manual backup step was just suggested for troubleshooting purpose. Please follow the technotes from the last post.

Thanks,

-Sush...