We use cookies on our website to ensure we provide you with the best experience on our website. By using our website, you agree to the use of cookies for analytics and personalized content.This website uses cookies. More Information
It seems like your browser didn't download the required fonts. Please revise your security settings and try again.
Barracuda Yosemite Server Backup

Why did my Differential Backup of SQL database fail to restore after a successful restore of the last Full Backup in Yosemite Server Backup?

  • Type: Knowledgebase
  • Date changed: 10 months ago
Solution #00005544

Scope:

Yosemite Server Backup 8.8 to 8.9

Answer:
A bug with the Yosemite Server Backup has recently been identified where Differential backups are getting marked as Incremental backups on tape. The result of this is that when trying to restore this Differential backup, Yosemite tries to restore it as though it is an Incremental backup and fails the restore with a SQL command writer failure. The bug is fixed in the version release 8.9.01 of Yosemite Server Backup and will make it so that Differential backups moving forward will correctly be marked as Differential. This will resolve the issue for new backups going forward. For the situation with a restore from a Differential backup made prior to this fix, an ini edit has been made available under 8.9.01 that will force Yosemite to restore backups marked as Incremental as though they are Differential.

Here is the process you will want to take to use the ini solution to restore:
  1. Setup and run the restore of the last Full backup, un-checking Finalize recovery of Microsoft SQl and Exchange Server database.
  2. Once that restore is complete, stop the YSB service on the SQL server. From a command prompt enter:
    net stop ytbackup
  3. Edit the ytconfig.ini file on the SQL server. By default it is located at:
    C:\Program Files\Barracuda\Yosemite Server Backup\Config\
  4. Add the following to the bottom of that file:
    [SQL Server]
    forceDiffRestore=TRUE
  5. Save and close that file.
  6. Start the YSB service.
  7. Setup and run the restore of the Differential backup, checking Finalize recovery of Microsoft SQl and Exchange Server database.
(Note: After the restore completes you will want to go back and use the same process of adding the lines to the ytconfig.ini file to remove them to ensure they aren't left in place.)

Link to this page:
https://campus.barracuda.com/solution/50160000000ISDdAAO