Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

SQL restores failing

Created: 04 Feb 2013 • Updated: 06 Feb 2013 | 11 comments

Hi,

 

Trying to restore a SQL database from tape and get the following errors

Job ended: 3. februar 2013 at 19:31:37 Completed status: Failed Final error: 0xe0008492 - Database Query Failure. See the job log for details. Final error category: Resource Errors For additional information regarding this error refer to link V-79-57344-33938

 

Why is this happening?

 

Thanks!

Comments 11 CommentsJump to latest comment

VJware's picture

Are you restoring to the original location or to a different location ? Would you pls post the complete job log along with the options which you selected for the restore.

Gurvinder Rait's picture

The error is generic but can happen during restore to original or restore to another server instance

Ensure the following options are selected in the restore job

- overwrite existing database. If redirecting then this is not required.

- When redirecting there is no need to create a target test database

- If you are doing a redirected restore then ensure the correct instance name is selected in restore job properties.

With the above option the restore should work

This is an old article but can be referred to know the restore job setup and options to be selected -

http://www.symantec.com/docs/TECH56694

zak2011's picture

@Vjware--Thankyou for the reply. I am restoring to the original location but with a different database name.

@Guruvinder-  Thanks for the reply.

- I am doing a redirected restore.

- I tried doing the restore without doing a target test database and also tried by creating one.

- The correct instanace name is selected in the restore.

This is the job log

Note- Sorry some of the logs maybe a bit repetitive.

Job server: BACKUPSRV03
Job name: BookingSBK_restore_04202013
Job started: 4. februar 2013 at 23:03:24
Job type: Restore
Job Log: BEX_BACKUPSRV03_33527.xml
Job Operation - Restore
Server - SQLCLU01.company.local
Drive and media mount requested: 04.02.2013 23:03:28
Drive and media information from media mount: 04.02.2013 23:04:10
Robotic Library Name: HP MSL6000 Tape Library
Drive Name: Tape drive 0001
Slot: 23
Media Label: PM4730L4
Media GUID: {0e86d79a-7879-4e2d-8dc3-100b7739e65f}
Overwrite Protected Until: 03.02.2013 06:34:24
Appendable Until: 09.01.2013 09:25:55


All Media Used
 PM4730L4

 TSY556L2

 NNX258L2

Network control connection is established between 10.0.4.25:49868 <--> 10.10.4.25:10000 Network data connection is established between 10.0.4.25:49878 <--> 10.10.4.25:57706

Set Information - SQLCLU01.company.local
Restore Set Information
Restoring data to SQLCLU01.company.local\BookingSbk_restored.

Storage Media #1: " Media created 04.01.2013 09:24:57 "
Backup performed on 04.01.2013 at 18:32
Backup set #10: " SQLCLU01.company.local-SQL Databases-Full "
Microsoft SQL Server Agent: Started

Restore started on 04.02.2013 at 23:04:57.
Restore completed on 04.02.2013 at 23:08:50.
Restore Set Summary
Restored 1 databases
Processed 17 645 364 bytes in  3 minutes and  52 seconds.
Throughput rate: 4.35 MB/min
Drive and media mount requested: 04.02.2013 23:10:30
Drive and media information from media mount: 04.02.2013 23:11:41
Robotic Library Name: HP MSL6000 Tape Library
Drive Name: Tape drive 0001
Slot: 1
Media Label: TSY556L2
Media GUID: {5badd2a4-4908-457d-844b-993a0230d384}
Overwrite Protected Until: 04.02.2013 02:05:33
Appendable Until: 25.01.2013 02:05:33

Network control connection is established between 10.0.4.25:49868 <--> 10.10.4.25:10000 Network data connection is established between 10.0.4.25:49942 <--> 10.10.4.25:57805

Set Information - SQLCLU01.company.local
Restore Set Information
Restoring data to SQLCLU01.company.local\BookingSbk_restored.

Storage Media #3: " Media created 01.01.2013 20:18:29 "
Backup performed on 05.01.2013 at 03:21
Backup set #255: " SQLCLU01.company.local-SQL Databases-Incremental "
Microsoft SQL Server Agent: Started

Restore started on 04.02.2013 at 23:11:56.
Restore Set Detail Information
V-79-65323-4305 - 
An error occurred on a query to database BookingSbk_restored.
Restore completed on 04.02.2013 at 23:12:05.
Restore Set Summary
Restored 1 databases
1 item was skipped.
Processed 1 536 bytes in  9 seconds.
Throughput rate: 0.010 MB/min
Network control connection is established between 10.0.4.25:49868 <--> 10.10.4.25:10000
Network data connection is established between    10.0.4.25:49949 <--> 10.10.4.25:57815
Set Information - SQLCLU01.company.local
Restore Set Information
Restoring data to SQLCLU01.company.local\BookingSbk_restored.

Storage Media #3: " Media created 01.01.2013 20:18:29 "
Backup performed on 05.01.2013 at 07:21
Backup set #262: " SQLCLU01.company.local-SQL Databases-Incremental "
Microsoft SQL Server Agent: Started

Restore started on 04.02.2013 at 23:12:22.
Restore completed on 04.02.2013 at 23:12:22.
Restore Set Summary
Processed 0 bytes in  1 second.
Throughput rate: 0.000 MB/min
Network control connection is established between 10.0.4.25:49868 <--> 10.10.4.25:10000
Network data connection is established between    10.0.4.25:49954 <--> 10.10.4.25:57821
Set Information - SQLCLU01.company.local
Restore Set Information
Restoring data to SQLCLU01.company.local\BookingSbk_restored.

Storage Media #3: " Media created 01.01.2013 20:18:29 "
Backup performed on 05.01.2013 at 11:21
Backup set #269: " SQLCLU01.company.local-SQL Databases-Incremental "
Microsoft SQL Server Agent: Started

Restore started on 04.02.2013 at 23:12:30.
Restore completed on 04.02.2013 at 23:12:36.
Restore Set Summary
Processed 0 bytes in  6 seconds.
Throughput rate: 0.000 MB/min
Network control connection is established between 10.0.4.25:49868 <--> 10.10.4.25:10000
Network data connection is established between    10.0.4.25:49955 <--> 10.10.4.25:57827
Set Information - SQLCLU01.company.local
Restore Set Information
Restoring data to SQLCLU01.company.local\BookingSbk_restored.

Storage Media #3: " Media created 01.01.2013 20:18:29 "
Backup performed on 05.01.2013 at 15:22
Backup set #276: " SQLCLU01.company.local-SQL Databases-Incremental "
Microsoft SQL Server Agent: Started

Restore started on 04.02.2013 at 23:12:46.
Restore completed on 04.02.2013 at 23:12:46.
Restore Set Summary
Processed 0 bytes in  1 second.
Throughput rate: 0.000 MB/min
Network control connection is established between 10.0.4.25:49868 <--> 10.10.4.25:10000
Network data connection is established between    10.0.4.25:49957 <--> 10.10.4.25:57832
Set Information - SQLCLU01.company.local
Restore Set Information
Restoring data to SQLCLU01.company.local\BookingSbk_restored.

Storage Media #3: " Media created 01.01.2013 20:18:29 "
Backup performed on 05.01.2013 at 19:21
Backup set #283: " SQLCLU01.company.local-SQL Databases-Incremental "
Microsoft SQL Server Agent: Started

Restore started on 04.02.2013 at 23:12:59.
Restore completed on 04.02.2013 at 23:12:59.
Restore Set Summary
Processed 0 bytes in  1 second.
Throughput rate: 0.000 MB/min
Network control connection is established between 10.0.4.25:49868 <--> 10.10.4.25:10000
Network data connection is established between    10.0.4.25:49958 <--> 10.10.4.25:57836
Set Information - SQLCLU01.company.local
Restore Set Information
Restoring data to SQLCLU01.company.local\BookingSbk_restored.

Storage Media #3: " Media created 01.01.2013 20:18:29 "
Backup performed on 05.01.2013 at 23:21
Backup set #300: " SQLCLU01.company.local-SQL Databases-Incremental "
Microsoft SQL Server Agent: Started

Restore started on 04.02.2013 at 23:13:40.
Restore completed on 04.02.2013 at 23:13:40.
Restore Set Summary
Processed 0 bytes in  1 second.
Throughput rate: 0.000 MB/min
Network control connection is established between 10.0.4.25:49868 <--> 10.10.4.25:10000
Network data connection is established between    10.0.4.25:49960 <--> 10.10.4.25:57839
Set Information - SQLCLU01.company.local
Restore Set Information
Restoring data to SQLCLU01.company.local\BookingSbk_restored.

Storage Media #3: " Media created 01.01.2013 20:18:29 "
Backup performed on 06.01.2013 at 03:21
Backup set #311: " SQLCLU01.company.local-SQL Databases-Incremental "
Microsoft SQL Server Agent: Started

Restore started on 04.02.2013 at 23:13:58.
Restore completed on 04.02.2013 at 23:13:58.
Restore Set Summary
Processed 0 bytes in  1 second.
Throughput rate: 0.000 MB/min
Network control connection is established between 10.0.4.25:49868 <--> 10.10.4.25:10000
Network data connection is established between    10.0.4.25:49961 <--> 10.10.4.25:57846
Set Information - SQLCLU01.company.local
Restore Set Information
Restoring data to SQLCLU01.company.local\BookingSbk_restored.

Storage Media #3: " Media created 01.01.2013 20:18:29 "
Backup performed on 06.01.2013 at 07:20
Backup set #328: " SQLCLU01.company.local-SQL Databases-Incremental "
Microsoft SQL Server Agent: Started

Restore started on 04.02.2013 at 23:14:34.
Restore completed on 04.02.2013 at 23:14:34.
Restore Set Summary
Processed 0 bytes in  1 second.
Throughput rate: 0.000 MB/min
Network control connection is established between 10.0.4.25:49868 <--> 10.10.4.25:10000
Network data connection is established between    10.0.4.25:49971 <--> 10.10.4.25:57852
Set Information - SQLCLU01.company.local
Restore Set Information
Restoring data to SQLCLU01.company.local\BookingSbk_restored.

Storage Media #3: " Media created 01.01.2013 20:18:29 "
Backup performed on 06.01.2013 at 11:21
Backup set #335: " SQLCLU01.company.local-SQL Databases-Incremental "
Microsoft SQL Server Agent: Started

Restore started on 04.02.2013 at 23:14:43.
Restore completed on 04.02.2013 at 23:14:43.
Restore Set Summary
Processed 0 bytes in  1 second.
Throughput rate: 0.000 MB/min
Network control connection is established between 10.0.4.25:49868 <--> 10.10.4.25:10000
Network data connection is established between    10.0.4.25:49973 <--> 10.10.4.25:57858
Set Information - SQLCLU01.company.local
Restore Set Information
Restoring data to SQLCLU01.company.local\BookingSbk_restored.

Storage Media #3: " Media created 01.01.2013 20:18:29 "
Backup performed on 06.01.2013 at 15:21
Backup set #342: " SQLCLU01.company.local-SQL Databases-Incremental "
Microsoft SQL Server Agent: Started

Restore started on 04.02.2013 at 23:14:53.
Restore completed on 04.02.2013 at 23:14:53.
Restore Set Summary
Processed 0 bytes in  1 second.
Throughput rate: 0.000 MB/min
Network control connection is established between 10.0.4.25:49868 <--> 10.10.4.25:10000
Network data connection is established between    10.0.4.25:49974 <--> 10.10.4.25:57861
Set Information - SQLCLU01.company.local
Restore Set Information
Restoring data to SQLCLU01.company.local\BookingSbk_restored.

Storage Media #3: " Media created 01.01.2013 20:18:29 "
Backup performed on 06.01.2013 at 19:22
Backup set #349: " SQLCLU01.company.local-SQL Databases-Incremental "
Microsoft SQL Server Agent: Started

Restore started on 04.02.2013 at 23:15:04.
Restore completed on 04.02.2013 at 23:15:05.
Restore Set Summary
Processed 0 bytes in  1 second.
Throughput rate: 0.000 MB/min
Network control connection is established between 10.0.4.25:49868 <--> 10.10.4.25:10000
Network data connection is established between    10.0.4.25:49975 <--> 10.10.4.25:57867
Set Information - SQLCLU01.company.local
Restore Set Information
Restoring data to SQLCLU01.company.local\BookingSbk_restored.

Storage Media #3: " Media created 01.01.2013 20:18:29 "
Backup performed on 06.01.2013 at 23:22
Backup set #370: " SQLCLU01.company.local-SQL Databases-Incremental "
Microsoft SQL Server Agent: Started

Restore started on 04.02.2013 at 23:16:13.
Restore completed on 04.02.2013 at 23:16:13.
Restore Set Summary
Processed 0 bytes in  1 second.
Throughput rate: 0.000 MB/min
Network control connection is established between 10.0.4.25:49868 <--> 10.10.4.25:10000
Network data connection is established between    10.0.4.25:49985 <--> 10.10.4.25:57871
Set Information - SQLCLU01.company.local
Restore Set Information
Restoring data to SQLCLU01.company.local\BookingSbk_restored.

Storage Media #3: " Media created 01.01.2013 20:18:29 "
Backup performed on 07.01.2013 at 03:21
Backup set #396: " SQLCLU01.company.local-SQL Databases-Incremental "
Microsoft SQL Server Agent: Started

Restore started on 04.02.2013 at 23:17:41.
Restore completed on 04.02.2013 at 23:17:42.
Restore Set Summary
Processed 0 bytes in  1 second.
Throughput rate: 0.000 MB/min
Drive and media mount requested: 04.02.2013 23:19:11
Drive and media information from media mount: 04.02.2013 23:20:23
Robotic Library Name: HP MSL6000 Tape Library
Drive Name: Tape drive 0001
Slot: 8
Media Label: NNX258L2
Media GUID: {280489ba-cf5b-4160-8cee-1fd6cf8addbd}
Overwrite Protected Until: 31.01.2013 22:07:05
Appendable Until: 19.01.2013 06:58:15

Network control connection is established between 10.0.4.25:49868 <--> 10.10.4.25:10000 Network data connection is established between 10.0.4.25:50016 <--> 10.10.4.25:57891

Set Information - SQLCLU01.company.local
Restore Set Information
Restoring data to SQLCLU01.company.local\BookingSbk_restored.

Storage Media #9: " Media created 01.01.2013 20:18:29 "
Backup performed on 16.01.2013 at 07:21
Backup set #1117: " SQLCLU01.company.local-SQL Databases-Incremental "
Microsoft SQL Server Agent: Started

Restore started on 04.02.2013 at 23:20:37.
Restore Set Detail Information
Database Consistency Checks
 
Restore completed on 04.02.2013 at 23:20:38.
Restore Set Summary
Processed 0 bytes in  1 second.
Throughput rate: 0.000 MB/min
Job Completion Status
Job ended: 4. februar 2013 at 23:21:15
Completed status: Failed
Final error: 0xe0008492 - Database Query Failure. See the job log for details.
Final error category: Resource Errors

For additional information regarding this error refer to link V-79-57344-33938

Errors
Click an error below to locate it in the job log

 

Restore- SQLCLU01.company.local
V-79-65323-4305 - An error occurred on a query to database BookingSbk_restored.

 

 

Thanks,

 

zak2011's picture

Tried doing a restore to another SQL server and it is giving the following error

V-79-65323-4305 - An error occurred on a query to database BookingRestore. V-79-65323-4305 - The log in this backup set begins at LSN 5145000000025300001, which is too recent to apply to the database. An earlier log backup that includes LSN 5029000000042500001 can be restored.

 

Thanks,

VJware's picture

In the redirection options, do specify the target server's name (This needs to be specified even though if its the source server as you restoring to a different database)...Instance name can be left blank if using default instance...

There are 3 other options such as r~

Use Alternate Drive (Only when the original drive does not exist OR Even when original drive does exist)

Use Destination Instance's default data directory

Use this path

If choosing the first option, please ensure "Even when original drive does exist" is selected if restoring to C:\, else choose other options. If choosing the last, the path should be similar to D:\Folder

 

 

Gurvinder Rait's picture

Are you sure all Incremental sets are present ? It seems BE doesnt find an Incremental set and is complaining because of that. Just the full restore till all incrementals are present should work fine.

 

Storage Media #3: " Media created 01.01.2013 20:18:29 "
Backup performed on 05.01.2013 at 03:21
Backup set #255: " SQLCLU01.company.local-SQL Databases-Incremental "
Microsoft SQL Server Agent: Started
Restore started on 04.02.2013 at 23:11:56.
Restore Set Detail Information
V-79-65323-4305 - 
An error occurred on a query to database BookingSbk_restored.
Restore completed on 04.02.2013 at 23:12:05.
Restore Set Summary
Restored 1 databases
1 item was skipped.
Processed 1 536 bytes in  9 seconds.
Throughput rate: 0.010 MB/min

 

zak2011's picture

@Guruvinder- When i chose the point in time i need to be restored, the job summary talks about the required media and then i put the required media. I beleive all the incrementals should be there.

Atleast shouldnt the full backup work?. The retension for tape is one year and i am only requesting the backup from last month.

Thanks

Gurvinder Rait's picture

Have you just tried to restore from Full backup set ? does it work. You can open a case with Tech Support to get this Investigated further since when the failure happens we can check the debug to see what BE is actually looking for. The error in the job log doesnt say much.

zak2011's picture

I am trying to choose the Full backup set. When i see the contents of the backup set on the tape it shows me the SQL full database backup is present. However when i go to the restore job and say show the individual backup sets that i would like to restore, i dont see the ones on the tape. I have done a full inventory and catalog of the tape. If i see the backups sets on tape shouldnt i able to restore it?

Thanks,

Arun

zak2011's picture

I am getting the following error message now

Restore- sqlsrv04.company.local
V-79-65323-4305 - An error occurred on a query to database bookingsbk. V-79-65323-4305 - The log in this backup set begins at LSN 5145000000025300001, which is too recent to apply to the database. An earlier log backup that includes LSN 5029000000042500001 can be restored.

 

Does this mean the incremental sets are no longer there. If they are not there..then why do i get the summary stating that two of the media should be put.

 

If i need to restore only the Full backup set..how do i do that?

Thanks

zak2011's picture

Hi,

I tried restoring the database from tapes again. I got the message 'Database query failed'.

After opening the SQL Management studio, it shows the status ' Database ABCD restoring'.

However the job from the backup exec server is not running.
If i right click the SQL database and go to Tasks-Restore from transactional logs..it does that

and then the database gets restored.

Thanks VJware and Guruvinder for all the help offered.