Backup Exec 2012 not restoring incremental backups

What do you mean by not being able to restore from your incremental backups?  You cannot see the backup sets?  You have to provide more details if you want help.

To add to what pkh said, do you have the full backup prior to the Incremental? You need the Full + all the Incremental to the point you want to restore.

Hi,

Please attach the job log, if possible.

Regards,

S

Not that we cannot restore, we do have full backups and we also have separate incremental backups. The challenge is we needed to restore an sql instalnce of yesterday using an incremental backup we have. but it does not seem to do the job.

Job Log for NHCCLDC2 Restore 00031

Job server: NHCCLDC2
Job name: NHCCLDC2 Restore 00031
Job started: Tuesday, November 19, 2013 at 7:40:11 PM
Job type: Restore
Job Log: BEX_NHCCLDC2_00656.xml

Drive and media mount requested: 11/19/2013 7:40:12 PM

Drive and media information from media mount: 11/19/2013 7:40:12 PM
Drive Name: Disk cartridge RD-1000
Media Label: B2D000034
Media GUID: {5e135468-c2d9-42a8-bf6a-af946583c028}
Overwrite Protected Until: 10/7/2013 5:00:56 PM
Appendable Until: 10/9/2013 4:40:10 PM


All Media Used
 B2D000034

Restoring data to NHCCLDC2\NHCCLDC2.

Storage Media #1: " Media created 10/3/2013 4:06:31 PM "
Backup performed on 10/3/2013 at 4:46 PM
Backup set #1: " NHCCLDC2 Backup 00177-Full "
Microsoft SQL Server Agent: Started

Restore started on 11/19/2013 at 7:40:14 PM.

Restore completed on 11/19/2013 at 7:52:58 PM.

Restored 1 databases
Processed 9,958,352,876 bytes in  12 minutes and  39 seconds.
Throughput rate: 751 MB/min

I may have missed something here.  You said that the restore does not do the job, but the joblog shows that the restore was successful.

Good thanks for the observation, the question is if you do not do full backup and only do incremental backups can u restore all the data lost say the previous day? this could the challenge we are facing. restore is successfull but the information restored is not showing atall. Case is the sql database we backed up when we run the above restore is shows successfull but I do not see the data. Could it be that the method we used is not fine.

Gives us a lot of dought using BEC 2012 going forward?

Any further help from Symantec would be bvery useful and unfortunately the local support is not there in my country.

Is your incremental backup a log backup?  If so, then you need to restore the full backup and then the log backup.  You cannot just restore the log backup.

Yes we have restored the full backup as at end of last month. If we now restore the log does it update us with recent info?

Kindly clarify

Yes, provided the log covers the period from the full backup until now.  You also need to restore the log immediately after you restore the full backup.  You cannot restore the full backup, update the database and then restore the log.

To add to what pkh said you need to restore all the incremental till the point you want to restore since the full backup., Example you performed a Full on Friday and Incremental from Mon-Thur and if you want to restore set from Thursday you would need to first restore -

Friday Full (SQL restore options use leave the database nonoperational; additional transaction logs or differential backups can be restored)

Monday Incremental (SQL restore options use leave the database nonoperational; additional transaction logs or differential backups can be restored)

Tuesday Incremental (SQL restore options use leave the database nonoperational; additional transaction logs or differential backups can be restored)

Wednesday Incremental (SQL restore options use leave the database nonoperational; additional transaction logs or differential backups can be restored)

Thursday Incremental (SQL restore options use leave the database ready to use; additional transaction logs or differential backups cannot be restored)