-
- Enthusiast
- Posts: 99
- Liked: 12 times
- Joined: Jul 23, 2012 3:48 pm
- Contact:
SQL Server Restores?
I'm following the steps outlined in this blog post:
http://www.veeam.com/blog/how-to-restor ... abase.html
And what I'm seeing in the Veeam SQL Explorer isn't matching. I'm good to go up until I pick the restore point and then the blog post shows the option to pick the most recent restore point or a slider to restore to a specific transaction log. I don't see that at all. I get the "Standard" Veeam restore screen where there is the list of backup points. Why is mine different? Is the blog post version 9 and I'm running version 8? I am doing application aware processing, etc on the backup jobs. I am not sure what the difference could be other than maybe the blog post is version 9. Anyone have any other ideas?
http://www.veeam.com/blog/how-to-restor ... abase.html
And what I'm seeing in the Veeam SQL Explorer isn't matching. I'm good to go up until I pick the restore point and then the blog post shows the option to pick the most recent restore point or a slider to restore to a specific transaction log. I don't see that at all. I get the "Standard" Veeam restore screen where there is the list of backup points. Why is mine different? Is the blog post version 9 and I'm running version 8? I am doing application aware processing, etc on the backup jobs. I am not sure what the difference could be other than maybe the blog post is version 9. Anyone have any other ideas?
-
- Veteran
- Posts: 391
- Liked: 107 times
- Joined: Apr 27, 2015 1:59 pm
- Full Name: Ryan Jacksland
- Location: NY, USA
- Contact:
Re: SQL Server Restores?
I am going to say it might be v9. I checked my v8 update 2 and I do not have those sliders or screens as well. Might be a little preview!
Cheers!
Cheers!
VMCE v9
-
- Chief Product Officer
- Posts: 31814
- Liked: 7302 times
- Joined: Jan 01, 2006 1:01 am
- Location: Baar, Switzerland
- Contact:
Re: SQL Server Restores?
This is v8 for sure, as v9 is not available even internally yet. If you don't have these controls available, this means you're simply not performing transaction log backups, which are required for point in time recovery. Without transaction log backup enabled, you can only perform the restore to a database state of an image-level backup. Thanks!
-
- Veteran
- Posts: 391
- Liked: 107 times
- Joined: Apr 27, 2015 1:59 pm
- Full Name: Ryan Jacksland
- Location: NY, USA
- Contact:
Re: SQL Server Restores?
I double checked the SQL backup, and it was set to Truncate Logs. if I changed it to Backup Logs Periodically that would give the option with the slider to choose a point in time?
VMCE v9
-
- VeeaMVP
- Posts: 6166
- Liked: 1971 times
- Joined: Jul 26, 2009 3:39 pm
- Full Name: Luca Dell'Oca
- Location: Varese, Italy
- Contact:
Re: SQL Server Restores?
Correct, the transaction log backup is what gives you point in time restore capabilities.
Luca Dell'Oca
Principal EMEA Cloud Architect @ Veeam Software
@dellock6
https://www.virtualtothecore.com/
vExpert 2011 -> 2022
Veeam VMCE #1
Principal EMEA Cloud Architect @ Veeam Software
@dellock6
https://www.virtualtothecore.com/
vExpert 2011 -> 2022
Veeam VMCE #1
Who is online
Users browsing this forum: Google [Bot], Semrush [Bot] and 63 guests