What are the challenges you face when working across database platforms? Take the survey
Options

Error 918: Failed to retrieve restore history id.

PhilJaxPhilJax Posts: 15
edited March 23, 2011 8:16AM in SQL Backup Previous Versions
Hi, Whilst restoring some database backups (using the partial restore method), I encounter an issue whilst restoring the differential database backups: -

Error 918: Failed to retrieve restore history id.
SQL error 102: Incorrect syntax near ')'.

Warning 195: Failed to update backup history table (BACKUPMEDIAFAMILY).
SQL error 102: Incorrect syntax near '='.

SQL Backup exit code: 195
SQL error code: 102

This appears to be an issue within Red Gate backup itself, as I do not receive any errors restoring other backup files using Red Gate - only differential backups.

I do not encounter any issues restoring Microsoft Backups either.

If you need any further information, please let me know.

Comments

  • Options
    peteypetey Posts: 2,358 New member
    Could you please post the RESTORE command you were using to restore the differential backup?

    Could you also please run Profiler to trace the commands used by the SQL Backup Agent Service (SQBCoreService.exe) while restoring the differential backup, and post the commands that were incorrectly formed?

    Thanks.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.