Video Screencast Help

Backup Exec 2012 not restoring incremental backups

Created: 19 Nov 2013 | 10 comments

Dear Team,

 

I have daily incremental backups and the challenge we have faced is that we cannot restore from them. Any one with some help on this issue would be very helpful.

 

Regards

 

David

Operating Systems:

Comments 10 CommentsJump to latest comment

pkh's picture

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.

Jaydeep S's picture

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.

Vishal Shinde's picture

Hi,

Please attach the job log, if possible.

Regards,

S

Vishal Shinde

Sr.Learning Consultant

Symantec Education Services

detuket@nhcc.co.ug's picture

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

 

Completed status: Successful
Expand AllCollapse All

 

Job Information
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
Job Operation - Restore
Server - NHCCLDC2
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

Network control connection is established between 127.0.0.1:3121 <--> 127.0.0.1:10000 Network data connection is established between 127.0.0.1:3127 <--> 127.0.0.1:3126

Set Information - NHCCLDC2\NHCCLDC2
Restore Set Information
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 Set Detail Information
Database Consistency Checks
Restore completed on 11/19/2013 at 7:52:58 PM.
Restore Set Summary
Restored 1 databases
Processed 9,958,352,876 bytes in  12 minutes and  39 seconds.
Throughput rate: 751 MB/min

 

pkh's picture

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.

detuket@nhcc.co.ug's picture

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.

pkh's picture

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.

detuket@nhcc.co.ug's picture

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

pkh's picture

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.

Jaydeep S's picture

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)