cancel
Showing results for 
Search instead for 
Did you mean: 

V-79-57344-33938 : An error occurred on a query to database MyDatabaseName

Japtan
Level 2

Hello,

 

We use Backup Exec for years with different customers and servers but here, I can't solve the problem. This server run a Windows 2008 server x64 with Sql server 2005 Workgroup (32bit). The build of backupexec is 1364 (V12.0). I get this message every time I try to backup any MS SQL database (i tried even with master):

V-79-57344-33938 - Une erreur s'est produite lors d'une interrogation vers la base de données XXXXXXXXXXXXXXXXXXXXXXXX.

V-79-57344-33938 - Impossible d'ouvrir l'unité de sauvegarde 'XXXXXXXXXXXXXXXXXXXXXXXX__8aa739c1_58e...

(It is a french version, it means:

 V-79-57344-33938 - An error occurred on a query to database MyDatabaseName XXXXXXXXXXXXXXXXXXXXXXXX.

V-79-57344-33938 - Impossible to open the backup unit 'XXXXXXXXXXXXXXXXXXXXXXXX__8aa739c1_58e1_420c_...

 

At the same time, I get this in the MS SQL Server log:

10/15/2008 11:42:51,,Inconnu,BACKUP failed to complete the command BACKUP DATABASE XXXXXXXXXXXXXXXXXXX. Check the backup application log for detailed messages.
10/15/2008 11:42:51,,Inconnu,Erreur : 3041<c/> Gravité : 16<c/> État : 1.
10/15/2008 11:42:51,,Inconnu,Cannot open backup device 'XXXXXXXXXXXXXXXXXXXXXX_00__8aa739c1_58e1_420c_9a87_09007c075fb5_'. Operating system error 0x80770006(error not found).
10/15/2008 11:42:51,,Inconnu,Erreur : 3201<c/> Gravité : 16<c/> État : 7.
 

I can make a standard SQL server backup without any problem through the agent, on the HD.

 

Thanks : any help will be appreciated ;)

3 REPLIES 3

Anup
Level 6
Certified
are there any errors in event viewer regarding SQLDVI

Japtan
Level 2

Yes indeed :

SQLVDI: Loc=SVDS::Open. Desc=BADMEM. ErrorCode=(-1). Process=1244. Thread=1156. Server. Instance=MSSQLSERVER. VD=Global\XXXXXXXXXXXXXXXXXXX_00__4e7f3af7_04c5_4ef8_a481_1a6afce9d2a7__SQLVDIMemoryName_0. 

 

(Then the errors I already described)

 

SQLVDI: Loc=CVDS::Close. Desc=Abnormal termination state. ErrorCode=(0). Process=1680. Thread=5056. Client. Instance=. VD=Global\XXXXXXXXXXXXXXXXXXX_00__4e7f3af7_04c5_4ef8_a481_1a6afce9d2a7__SQLVDIMemoryName_0.

 

SQLVDI: Loc=SignalAbort. Desc=Client initiates abort. ErrorCode=(0). Process=1680. Thread=5056. Client. Instance=. VD=Global\XXXXXXXXXXXXXXXXXXXXX_00__4e7f3af7_04c5_4ef8_a481_1a6afce9d2a7__SQLVDIMemoryName_0.  

 What do you think about?

 

Japtan
Level 2

I searched a bit in this direction. I found 4 copies of sqlvdi.dll. What is strange is that the two which are in the x64 directory are version 2000.85.2102.0 from 6/4/2007 and the two in de x32 are 2000.85.2004.0 from 9/2/2007. I tried to replace th x32s by the x64s but it did not help. I guess the x64 ddl are different from the x32 but I do not find where to download it.

 

All updates are installed on the sql server and there is only one instance.