When attempting to restore a Microsoft SQL Database that had backups targeted to a Device Pool, the restore may fail with "V-79-65323-4305 -An error occurred on a query to database DATABASE NAME"

Article:TECH203214  |  Created: 2013-02-25  |  Updated: 2013-02-25  |  Article URL http://www.symantec.com/docs/TECH203214
NOTE: If you are experiencing this particular known issue, we recommend that you Subscribe to receive email notification each time this article is updated. Subscribers will be the first to learn about any releases, status changes, workarounds or decisions made.
Article Type
Technical Solution


Issue



When attempting to restore a Microsoft SQL database that has been backed up to multiple devices in a device pool the restore fails with the error (s) below.


Error



V-79-65323-4305 -An error occurred on a query to database DATABASE NAME.

Debug Log Error:
[fsys\sql2]          - PostDataTransferComplete - Not for Read or Write 14
[fsys\sql2]          - SQL Error GUID: 7c9fdf0
[fsys\sql2]          - SQL Error Source: Microsoft OLE DB Provider for SQL Server
[fsys\sql2]          - SQL Error Description: RESTORE LOG is terminating abnormally.
[fsys\sql2]          - SQL Error State: 42000
[fsys\sql2]          - SQL Error Number: 3013
[fsys\sql2]          - SQL Error GUID: 7c9fdf0
[fsys\sql2]          - SQL Error Source: Microsoft OLE DB Provider for SQL Server
[fsys\sql2]          - SQL Error Description: The log in this backup set begins at LSN 60000000235100001, which is too recent to apply to the database. An earlier log backup that includes LSN 60000000234400001 can be restored.
[fsys\sql2]          - SQL Error State: 42000
[fsys\sql2]          - SQL Error Number: 4305


Solution



Workaround: Configure the Microsoft SQL Database backups to only backup to one device.

 

Symantec Corporation has acknowledged that the above-mentioned issue is present in the current version(s) of the product(s) mentioned at the end of this article. Symantec Corporation is committed to product quality and satisfied customers.
This issue is currently under investigation by Symantec Corporation. Pending the outcome of the investigation, this issue may be resolved by way of a patch or hotfix in current or future revisions of the software. However, this particular issue is not currently scheduled for any release. If you feel this issue has a direct business impact for you and your continued use of the product, please contact your Symantec Sales representative or the Symantec Sales group to discuss these concerns. For information on how to contact Symantec Sales, please see http://www.symantec.com

Please be sure to refer back to this document periodically as any changes to the status of the issue will be reflected here.


Supplemental Materials

SourceETrack
Value3085931
Description

SQL: unable to restore log backups for SQL databases when the backup spanned multiple devices in a device pool


SourceUMI
ValueV-79-65323-4305
Description

An error occurred on a query to database DATABASE NAME



Article URL http://www.symantec.com/docs/TECH203214


Terms of use for this information are found in Legal Notices