SQL Backup without processing the logs

VMware specific discussions

SQL Backup without processing the logs

Veeam Logoby ahahum » Wed Feb 10, 2016 9:27 pm

Is it possible to restore from a Veeam backup that was taken without processing the transaction logs while retaining the ability to restore to a point in time (In SQL native tools) using the transaction log backups taken using the native SQL tools?

If so, how since there is no bak file to start with? My understanding (not a DBA, but I've dabbled) is that you must begin the restore process with a bak file containing the full SQL database backup and then replay the transaction logs.
ahahum
Influencer
 
Posts: 21
Liked: never
Joined: Mon Jul 26, 2010 8:01 pm
Full Name: Adam Bond

Re: SQL Backup without processing the logs

Veeam Logoby Vitaliy S. » Thu Feb 11, 2016 11:02 am

Hi Adam,

If you backed up all logs natively, then it should be possible to achieve that via SQL Management Studio. See this topic for more info > SQL Instant Recovery with Point in Time Restore

On a side note, why not to allow Veeam backup job handle this process?

Thanks!
Vitaliy S.
Veeam Software
 
Posts: 19770
Liked: 1120 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: SQL Backup without processing the logs

Veeam Logoby alanbolte » Fri Feb 12, 2016 1:20 am

The short version is, if you want to backup sql logs with native tools, you should create .bak files with native tools as well. If you're doing this, set the Veeam backup to "copy only" in the AAIP settings.
alanbolte
Expert
 
Posts: 635
Liked: 172 times
Joined: Mon Jun 18, 2012 8:58 pm
Full Name: Alan Bolte

Re: SQL Backup without processing the logs

Veeam Logoby ahahum » Fri Feb 12, 2016 3:54 pm

alanbolte wrote:The short version is, if you want to backup sql logs with native tools, you should create .bak files with native tools as well. If you're doing this, set the Veeam backup to "copy only" in the AAIP settings.

Will the VSS backup using veeam break the chain?
ahahum
Influencer
 
Posts: 21
Liked: never
Joined: Mon Jul 26, 2010 8:01 pm
Full Name: Adam Bond

Re: SQL Backup without processing the logs

Veeam Logoby Vitaliy S. » Fri Feb 12, 2016 4:07 pm

Yes, If you don't enable COPY_ONLY mode, then it will affect your backup strategy via native tools.
Vitaliy S.
Veeam Software
 
Posts: 19770
Liked: 1120 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

[MERGED] Veeam SQL Application-Aware DB restore option

Veeam Logoby mdelmastro » Tue Feb 21, 2017 6:15 am

Hi
Question please

We require Veeam to restore the SQL database from application-aware Veeam full/incremental backups, but leave the database in RECOVERY mode so that we can then manually apply transaction logs that we have not backed up through an application-aware Veeam backup.
This requirement has arisen because we will be operating log-shipping, which manages transaction log backups through SQL Agent jobs, as opposed to backing them up through an application-aware Veeam backup.
mdelmastro
Lurker
 
Posts: 1
Liked: never
Joined: Tue Feb 21, 2017 6:12 am
Full Name: Matthew Del Mastro

Re: Veeam SQL Application-Aware DB restore option

Veeam Logoby Vitaliy S. » Tue Feb 21, 2017 10:33 am

Hi Matthew,

If you want to manage logs through another too, then just set application-aware processing to COPY_ONLY mode.

Thanks!
Vitaliy S.
Veeam Software
 
Posts: 19770
Liked: 1120 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov


Return to VMware vSphere



Who is online

Users browsing this forum: manfri and 26 guests