Hi, Server: 2K Advanced Symantec Backup Exec 10d SQL 2k Add-in used Our server had multiple hard drive failures on the day we wanted to retire it. I have managed the following restores, 1. Master database 2. User databases However I am failing to restore the MSDB - it reaches 99% before the above error is displayed. Byte count never increases past 0. Steps I am following: 1. Putting the MSDB database into single user mode. 2.Taking existing database offline 3. Replace databases or filegroups I desperately need to recover my DTS packages, please help!

Glad we could help. You could mark a post in the thread as solution and close it out.

Job name : Restore 00083 Job type : Restore Job status : Failed Job log : C:\Program Files\VERITAS\Backup Exec\NT\Data\BEX_XXXXXX_00785.xml Server name : XXXXXX Selection list name : Restore 00072 Device name : Backup-to-Disk Device 1 Target name : All Devices (XXXXXXX) Media set name : Error category : Resource Errors Error : e0008492 - Database Query Failure. See the job log for details. For additional information regarding this error refer to link V-79-57344-33938 Job Summary Information Original start time : 09 July 2013 15:58:27 Job started : 09 July 2013 15:58:31 Job ended : 09 July 2013 16:17:07 Elapsed time : 00:18:36 Files : 0 Directories : 0 Skipped files : 1 Corrupt files : 0 Files in use : 0 Byte count : 0 bytes Job rate : -1.00 MB/Min (Byte count divided by Elapsed time for job) Set Detail Information - Restore \\XXXXX\ Set type : Restore Set status : Completed Set description : Resource name : \\XXXXX\ Logon account : XXXX\XXXXXX Error : e0008492 - Database Query Failure. See the job log for details. Agent used : Yes Advanced Open File Option used : No Image used : No Start time : 09 July 2013 15:59:05 End time : 09 July 2013 16:17:07 Files : 0 Directories : 0 Skipped files : 1 Corrupt files : 0 Files in use : 0 Byte count : 0 bytes Rate : 0.00 MB/Min Media used : B2D028031

There actually are a lot of technotes available to help you troubleshoot and fix this issue. However, as you had mentioned disk failure, Have you confirmed if the SQL instance you are restoring to is the same version or later than the one you backed up from? Also, in the event viewer are you seeing any errors with relation to SQL VDI? See if any of the below are aplicable and help http://www.symantec.com/docs/TECH72460 http://www.symantec.com/docs/TECH35815 http://www.symantec.com/docs/TECH67379 http://www.symantec.com/docs/TECH28134

Hi Jay, I am the same version of SQL Server - fortunately the data was replicated to a hosted server. Which was the exact same version - so I was able to get the version number very easily which meant the master restored easily! I don't understand the SQL VDI comment - can you expand please? I was following this article http://www.symantec.com/business/support/index?page=content&id=TECH22575 which is not quite the same as our version of backup exec but is a good start. Will review your links and respond back in 5 Thanks

The technote that you are using should certainly be helpful. Also, on a quick thought, could you check if the database files are readonly (look in the OS) What I meant was in the Windows event viewer, you might get some errors/warnings about SQLVDI corresponding to the restore. If we have something like this it would be helpful to troubleshoot as the 'database query failure' is a very generic error.

http://www.symantec.com/docs/TECH72460 This gives me 3 subsequent links http://www.symantec.com/business/support/index?page=content&id=TECH64494 I am not seeing anything different in the Application Log other than what I see on screen in veritas http://www.symantec.com/business/support/index?page=content&id=TECH35815 I am not sure how to check the MDACs are in sync as the old server is not able to boot, but everything else looks good! http://www.symantec.com/business/support/index?page=content&id=TECH28134 There is over 100GB of disk space, and the MSDB database is under 30Mb!

Restoring MSDB - e0008492 - Database Query Failure

33 Replies

plateau
Level 3
12 years ago
Found this link

FIX: Error messages and an event may be logged when you use the Virtual Device Interface in SQL Server 2005 or in SQL Server 2000

http://support.microsoft.com/default.aspx?scid=kb;EN-US;934396

However the hotfix link only seems to list 2005?!

Help!
Jaydeep_S
Level 6
12 years ago
If you have VDI error related to the time of the restore to get more details about the error, you might need to check the VDI.log file. This is normally in

<DriveName>\Program Files\ Microsoft SQL Server\SSQL\Log

Also see if this helps http://support.microsoft.com/kb/934396
Plateau222
Level 4
12 years ago
I was just about to reply with that link! However when I follow the get hotfix I only see 2005 listed?!

Cheers

Dave
Plateau222
Level 4
12 years ago

----------------------------------------------
2013/07/06 14:28:40 pid(1008) tid(1028)
Error on Global\master_00__3f48fde1_0108_4c82_8247_0937283ff095_
Error at CVDS::Close: Abnormal termination state

----------------------------------------------
2013/07/06 14:28:40 pid(1008) tid(1028)
Error on Global\master_00__3f48fde1_0108_4c82_8247_0937283ff095_
Error at TriggerAbort: invoked

----------------------------------------------
2013/07/06 17:20:43 pid(988) tid(400)
Error on Global\master_00__a525e291_4246_4d4b_897b_1401a1bd64da_
Error at SVDS::Open: Open(control) Status Code: 5, x5
Explanation: Access is denied.

----------------------------------------------
2013/07/06 17:20:45 pid(1008) tid(1580)
Error on Global\master_00__a525e291_4246_4d4b_897b_1401a1bd64da_
Error at CVDS::Close: Abnormal termination state

----------------------------------------------
2013/07/06 17:20:45 pid(1008) tid(1580)
Error on Global\master_00__a525e291_4246_4d4b_897b_1401a1bd64da_
Error at TriggerAbort: invoked

----------------------------------------------
2013/07/06 17:22:16 pid(988) tid(400)
Error on Global\master_00__76aa299a_3b3d_4b98_9dd2_b3e9e9115e34_
Error at SVDS::Open: Open(control) Status Code: 5, x5
Explanation: Access is denied.

----------------------------------------------
2013/07/06 17:22:18 pid(1008) tid(1424)
Error on Global\master_00__76aa299a_3b3d_4b98_9dd2_b3e9e9115e34_
Error at CVDS::Close: Abnormal termination state

----------------------------------------------
2013/07/06 17:22:18 pid(1008) tid(1424)
Error on Global\master_00__76aa299a_3b3d_4b98_9dd2_b3e9e9115e34_
Error at TriggerAbort: invoked
Plateau222
Level 4
12 years ago
The above is ly entire VDI log

Found a SQLbackup simulator @ http://archive.msdn.microsoft.com/sqlbackupsim/Release/ProjectReleases.aspx?ReleaseId=5648

Which I will give a go too
Jaydeep_S
Level 6
12 years ago
Try if this link works for the SQL 2k hotfix http://support.microsoft.com/kb/935465

Also, have you tried re-registering the SQLVDI.dll Here are the steps -

Stop all of the SQL Services.

Search for, and document the location of each instance of sqlvdi.dll.

Click Start, click Run, type Regsvr32 Path\SQLVDI.DLL in the Open box, and then click OK.

Reboot the SQL Server.
Plateau222
Level 4
12 years ago
Hi Jay, thanks I am on SQL 2000 sp4 - so is this still needed?
Jaydeep_S
Level 6
12 years ago
Probabely yes as -

Prerequisites

SQL Server 2000 Service Pack 4 (SP4)

For more information about how to obtain SQL Server 2000 Service Pack 4, click the following article number to view the article in the Microsoft Knowledge Base:
290211 How to obtain the latest SQL Server 2000 service pack
Plateau222
Level 4
12 years ago
Just a FYI my version of that DLL is 2000.85.2101.0 and that link was for 2000.85.2101.0. too.

Do you still think I should uninstall and re-register the file? I would be surprised if this file was corrupt as the server is a clean build and was only built on Saturday morning.

Thanks again
Jaydeep_S
Level 6
12 years ago
Not sure about applying the patch again, but you could try re-registering none the less as we are getting errors about this VDI

Forum Discussion

Restoring MSDB - e0008492 - Database Query Failure

33 Replies

Prerequisites

Related Content

Oracle database restore from vmware type backup

Oracle database restore fail

BMR restore.

Netbackup Rman Database restores

SQL Database Restore

Recent Discussions

Backup Exec Job got canceled

BackupExec for Oracle 23ai?

Add Oracle DB in Backup Exec

Veritas Backup Exec version upgrade & migrate to another new Server

Veritas Backup Exec 23 - Slow Backup after Windows server 2019 upgrade