Video Screencast Help

SQL Restore from

Created: 14 Aug 2013 • Updated: 01 Oct 2013 | 6 comments
andrademac's picture
This issue has been solved. See solution.

I configured SQL database Backup in continuous mode, but when I want restore information from a previous day, only appear one or two point of restore (Two hours at day). The Question is How much information could I lost in this restore scenario?

2. What happen with the SQL logs or how is the sql backup process.  In the admin manual there are not much information about it.



Operating Systems:

Comments 6 CommentsJump to latest comment

pkh's picture

Suppose you only have backups taken at 10 a.m. and 11 a.m.  and your server crashes at 4 p.m., you would loose any input from 11 a.m. or 10 a.m. to 4 p.m. when you do a restore.  Worse, if somebody discovered that there is a wrong entry done at 9.30 a.m. which needs to be reversed, you would be unable to restore the database to a point before the erroneous entry.

The reason why you are only seeing one or two backup sets is because the rest are overwritten.  You have probably not choose to retain them for a longer period.

To backup your logs, you need to configure a separate log backup job.  See my article below

Igor S's picture

Hello Andrademac

Would you be able to confirm what backup application you are using ?

Igor S

pkh's picture

I thought it is obvious from the title of the forum.  What other product can he be using?

Igor S's picture

Hello PKH

As Symantec has a number of backup products I would rather not assume the product andrademac has.

Also from the answer you provided it sounds like this is for Backup Exec stand alone not Backup Exec.Cloud.

This is why i why I whanted to clarify.

Igor S 

andrademac's picture

Thanks for your interest in this case, the product is Backup Exec Cloud in

I think we could lose some hours of information despite the SQL backup said to be continuous.

Igor S's picture

Hello Andrademac

When you select SQL, System State or Exchange we would use VSS to take a snap of the changes.

This snap occurs during the following times and it is not editable, 04:00, 12:00 and 20:00 hours.

Then that data is stored using the following rules.(

·         Up to three revisions are saved on the first day

·         Daily revisions for the first week

·         Weekly revisions for the first month

·         Monthly revisions for three months

Your data is never deleted or removed prematurely by Backup Revision data older than 90 days is deleted, but the final revision remains. Several other situations result in data deletion:

·         Deselecting data in your backup policy

·         Deleting data from your local computer

When it comes to the logs we would trim them during snapshot period back them up also.

Igor S