We're still testing SQL backups with Veeam, and we are backing up SQL transaction logs every two hours. My problem is, when I go to restore a database, it does not give me a Point-in-Time restore option. Looking at the backup, it shows we have the transaction log backup with a number of restore points. Also, when I look at the Veeam SQL explorer log, it shows the databases which have a Recovery model of "Full", and those with "Simple". However, under the "loading storage data" section for the server, all databases, Full and Simple, say the "Point-in-Time restore will not be available". All databases on a given server don't have to be in "Full" recovery model for Point-in-time restore of any particular database, do they?
Thanks.
-
- Novice
- Posts: 4
- Liked: never
- Joined: May 21, 2018 1:40 pm
- Full Name: Paul Long
- Contact:
-
- Product Manager
- Posts: 5797
- Liked: 1215 times
- Joined: Jul 15, 2013 11:09 am
- Full Name: Niels Engelen
- Contact:
Re: No Point-in-Time log restore
Hi Paul, this is unexpected behaviour. Normally the full recovery model databases should be visible. Please contact support for insight to see what is causing this behaviour.
Personal blog: https://foonet.be
GitHub: https://github.com/nielsengelen
GitHub: https://github.com/nielsengelen
Who is online
Users browsing this forum: No registered users and 45 guests