SQL Backups are not allowing point in time recovery

VMware specific discussions

SQL Backups are not allowing point in time recovery

Veeam Logoby m_taylor » Tue Mar 01, 2016 3:42 pm

CaseId: 01714182

Currently evaluating VEEAM 9.0 for purchase. We have been backing up our test/dev SQL server (which is part of a SQL AlwaysOn Cluster) successfully as an Application Aware backup. However, when we test the restore, we are not presented with the option to restore to a specific point in time. Also, in the SQL Explorer window, when highlighting a database to restore, the information next to "Available Restore Period" says "not available". Seem to be having an issue of backing up the transaction logs, although I cant see where it is failing. In the backup job we have "process transaction logs with this job". We are using guest OS credentials that also has the sysadmin role on the SQL server.

Any ideas?

Many thanks
m_taylor
Lurker
 
Posts: 2
Liked: 1 time
Joined: Mon Feb 29, 2016 8:03 pm
Full Name: Mark Taylor

Re: SQL Backups are not allowing point in time recovery

Veeam Logoby m_taylor » Tue Mar 01, 2016 5:46 pm 1 person likes this post

I misunderstood the selections in the job. I just selected "Truncate logs" expecting VEEAM backup to allow me to restore to a point in time. I have now read this article suggesting I need to choose the option - back up the logs periodically.

https://helpcenter.veeam.com/backup/hyp ... ation.html

I will post back the results of my next test, and close the topic if successful.
m_taylor
Lurker
 
Posts: 2
Liked: 1 time
Joined: Mon Feb 29, 2016 8:03 pm
Full Name: Mark Taylor


Return to VMware vSphere



Who is online

Users browsing this forum: heavy and 32 guests