sql continuous protection
Created: 07 Mar 2008 | Updated: 02 Mar 2009
I wonder if someone can assist.
I have been using backup exec to control sql backups up to a month ago and we then swapped to Continuous protection to carry out the backups.
We have needed to restore from the backup earlier this week and have had some difficulty in doing this. Choosing a snapshot and using this it appears we are getting back data from later in the week as opposed to earlier.
Any reason for this that you would be aware?
Also as a general rule if you have both backup Exec and continuous protection what prefered method of backup do you choose for SQL?