Forum Discussion

sdcadmin's avatar
sdcadmin
Level 5
13 years ago
Solved

Restore & File Size

Hello,

1.  I have two issues.  The first is that I am trying to restore a SQL database.  We take full backups on the weekend and differentials during the week.  I am was able to successfully restore the full backup that was taken on 03/02/2013.  The differential restore gives me an error 0xe0008492 and V-79-65323-3117 - The log or differential backup cannot be reestored because no files are ready to rollforward. I have searched Symantec and the Internet to no avail.

2. We have an OpenStorage Device.  Under properties -> Advance tab, Split Data Stream is set to 50 GB by default and Data Stream Chunk size is set to 256 KB by default.  Is this the best setting or is there a better setting that can be used?  I ask because we had our B2D folder set to 1,000 GB and was wondering what's the best practice. 

Any assistance provided is greatly appreciated, thanks!

William

2010
Backup and Recovery
Backup Exec
Best Practice
Restore
Windows Server (2003-2008)
  • VJware's avatar
    VJware
    13 years ago

    Did you have a look @ http://www.symantec.com/docs/TECH71884  ?

6 Replies

Sort By
  • VJware's avatar
    VJware
    Level 6
    13 years ago

    Did you have a look @ http://www.symantec.com/docs/TECH71884  ?

  • sdcadmin's avatar
    sdcadmin
    Level 5
    13 years ago

    Thanks VJware!  That problem is solved but now I have a new one.

    This Differential backup cannot be restored because the database has not been restored to the correct earlier state v-79-65323-3136.

    I'm getting ready to search the Internet but could not find anything here at Symantec.  I looked at the database and it shows as (restoring...).  I BE not putting the db back online after it finishes?  Or doesn't that mean something else is going on here?

  • VJware's avatar
    VJware
    Level 6
    13 years ago

    This occurs if the differential backup (or rather its catalog) was corrupt . Common reasons are failed jobs between the full & this diff, or sql native backups/maintenance plans being run between the full & the diff.

  • sdcadmin's avatar
    sdcadmin
    Level 5
    13 years ago

    I reviewed the job history of the Full and Diff backups and there were some failed jobs.  The part of the job that failed had nothing to do with the server that I am trying to restore; however it appears that if any server in the group fails a differential backup, then the entire job becomes no go.  Is that the correct conclusion?

  • VJware's avatar
    VJware
    Level 6
    13 years ago

    Yes, there could be a possibility of corrupt catalogs chain... have you confirmed that you are trying to restore the appropriate diff backup set which matches with the full backup (which was restored earlier)

     

  • sdcadmin's avatar
    sdcadmin
    Level 5
    13 years ago

    Yes, we have confirmed that it is the correct differential backup set.