Veeam Backup & Replication SQL Server - need tutorial

Hyper-V specific discussions

Veeam Backup & Replication SQL Server - need tutorial

Veeam Logoby grzesiekb » Wed Feb 27, 2013 9:53 pm

Hy,
this is my first post on this forum.
I have hyper-v machine with Windows Server 2008r2 and SQL Server 2008R2 Std. I configured backup of virtual machine with option ''Enable application aware-image processing''.
I know that Veeam can restore sql databases. Where I can find informations, manual how to use Veeam B&R with Microsoft Sql Server installed inside hyper-v machine.
My version Veeam B&R 6.5 Trial. I cannot find any restore options for MSSQL.
grzesiekb
Lurker
 
Posts: 1
Liked: never
Joined: Wed Feb 27, 2013 7:56 am
Full Name: grzesiekb

Re: Veeam Backup & Replication SQL Server - need tutorial

Veeam Logoby v.Eremin » Thu Feb 28, 2013 8:51 am

Best practice for backing up MS SQL server includes:

1) Enabling Application-Aware Image Processing option, which Veeam’s proprietary technology responsible for creating a transactionally consistent backup of a VM running VSS-aware applications (such as Active Directory, Microsoft SQL, Microsoft Exchange, Sharepoint, etc) without shutting them down. It also ensures successful VM recovery, as well as proper recovery of all applications installed on the VM without any data loss.

2) Enabling log truncation. This option can be selected while backing up or replicating systems, like Microsoft Exchange or Microsoft SQL, that use transaction logs, so that, the storage space isn’t overflown by them.

As to restore process, for VMware environment VB&R provides set of wizard called U-AIR that lead you through the process of recovery of application objects, including Application-specific wizards for Active Directory, Microsoft SQL and Microsoft Exchange.

Unfortunately, by now there is no similar functionality available for Hyper-V environment. So, if you’re willing to restore Microsoft SQL specific items you should think about using Instant VM recovery along with Microsoft SQL Management studio.

Hope this helps.
Thanks.
v.Eremin
Veeam Software
 
Posts: 13255
Liked: 968 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: Veeam Backup & Replication SQL Server - need tutorial

Veeam Logoby chrisdearden » Thu Feb 28, 2013 9:36 am

Veeam doesn't have the functionality to restore a DB directly back into SQL without using the virtual labs . However from the Vm level backup, the database files are quiesced and stable. You can run a file level restore of the mdb/ldb files and attach as a new database.
chrisdearden
Expert
 
Posts: 1529
Liked: 225 times
Joined: Wed Jul 21, 2010 9:47 am
Full Name: Chris Dearden

Re: Veeam Backup & Replication SQL Server - need tutorial

Veeam Logoby rbrambley » Thu Feb 28, 2013 5:44 pm

BTW the place to get free tutorials is our Veeam Online University at:
http://www.veeam.com/university/vmware-backup.html

There is a U-AIR tutorial for AD already there. Unfortunately not SQL. The U-AIR process is the same however. There are also tutorials for building the vlab, application group, and surebackup job which are all the pieces of using U-AIR recovery.

U-AIR for Hyper-V is not available today. Only VMware - as mentioned aboved.
rbrambley
Veeam Software
 
Posts: 445
Liked: 54 times
Joined: Tue Jun 16, 2009 1:23 pm
Full Name: Rich Brambley

[MERGED] SQL Restores from a Backup/Replica?

Veeam Logoby jbarrow.viracoribt » Wed Mar 06, 2013 3:37 pm

How do you guys restore your SQL backups from your Backups or Replicas? We're asked on occasion to restore a database from Server A over to Server B to do a refresh. Since Veeam pretty much treats the SQL data (MDF/LDF files) as flat files, do you just manually restore these files to a temp location and then use SQL management studio to import them?

Just curious to see how others do this.
jbarrow.viracoribt
Expert
 
Posts: 184
Liked: 18 times
Joined: Fri Feb 15, 2013 9:31 pm
Full Name: Jonathan Barrow

Re: SQL Restores from a Backup/Replica?

Veeam Logoby seapro220 » Wed Mar 06, 2013 5:28 pm

Whenever I first started out trying to understand the Veeam backup process, I changed my backup strategy to only using VBR. What I determined was that for incremental or transactional logging, the VBR job was breaking the SQL restore points - and making that process unusable. I changed my VBR job to NOT flush, but that didn't work. Since then, I'm utilizing the following process -

1. weekly full and rollup of server. that way I have a 'server' image for restores.
2. daily trans,incremental, and weekly sql backup processes. I process them locally on my sql box, but offload them them nightly.
This process provides my ability in SQL to use the Management tools for trans/incremental, and full backup restores for a week at a time.

Not to be 'long in the tooth' - but because of how the file is taken, via VBR, the only process of restore is to restore it as a 'flat' file, and use the SQL mgmt tools to import/create a new db. Kinda sucks and perhaps there's a better way - but I dont think so.

mark
seapro220
Enthusiast
 
Posts: 51
Liked: 2 times
Joined: Fri Feb 24, 2012 2:49 pm
Full Name: mark foster

[MERGED] : MS SQL Replica

Veeam Logoby filloweb » Mon May 06, 2013 3:27 pm

Hi all,

There is a Best Practice Step by Step to implementing a scheduled replica from a esxi to another esxi ( every esxi with local datastore ) for a Windows 2008 R2 x64 with MS SQL database?

Thanks a lot.
Filippo
filloweb
Lurker
 
Posts: 1
Liked: never
Joined: Mon May 06, 2013 3:24 pm
Full Name: Filippo

Re: Veeam Backup & Replication SQL Server - need tutorial

Veeam Logoby v.Eremin » Mon May 06, 2013 3:32 pm

Though abovementioned discussion is primarily concerned with backing up SQL VM, the proposed best practices are applicable to replication scenario, as well.

Long story short, enable Application Aware Image Processing and log truncation options.

Hope this helps.
Thanks.
v.Eremin
Veeam Software
 
Posts: 13255
Liked: 968 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: SQL Restores from a Backup/Replica?

Veeam Logoby bob.baird.xedo » Wed Jun 26, 2013 9:01 am

seapro220 wrote:Whenever I first started out trying to understand the Veeam backup process, I changed my backup strategy to only using VBR. What I determined was that for incremental or transactional logging, the VBR job was breaking the SQL restore points - and making that process unusable. I changed my VBR job to NOT flush, but that didn't work. Since then, I'm utilizing the following process -

1. weekly full and rollup of server. that way I have a 'server' image for restores.
2. daily trans,incremental, and weekly sql backup processes. I process them locally on my sql box, but offload them them nightly.
This process provides my ability in SQL to use the Management tools for trans/incremental, and full backup restores for a week at a time.

Not to be 'long in the tooth' - but because of how the file is taken, via VBR, the only process of restore is to restore it as a 'flat' file, and use the SQL mgmt tools to import/create a new db. Kinda sucks and perhaps there's a better way - but I dont think so.

mark



Hi Mark,

I'm just curious as to what software you use for your separate SQL backups?

We currently use RedGate SQL Backup and this works perfectly well - we have weekly full, daily differential and hourly transaction logs being backed up and copied to a NAS we have on our network.

We are now looking at using Veeam B&R to backup our VM's and I'm curious as to what settings we need to make in the backup jobs to ensure the database backup "chains" wont get broken by the Veeam backup.

Any advice would be appreciated.


Thanks,
Bob
bob.baird.xedo
Influencer
 
Posts: 20
Liked: never
Joined: Wed Feb 13, 2013 12:20 pm
Full Name: Bob Baird

Re: SQL Restores from a Backup/Replica?

Veeam Logoby foggy » Fri Jun 28, 2013 12:00 pm

bob.baird.xedo wrote:We are now looking at using Veeam B&R to backup our VM's and I'm curious as to what settings we need to make in the backup jobs to ensure the database backup "chains" wont get broken by the Veeam backup.

Bob, you can disable transaction logs truncation in the Veeam B&R backup job settings and let only RedGate to do this.
foggy
Veeam Software
 
Posts: 14716
Liked: 1075 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

[MERGED] Using Veeam to Backup MS SQL Server

Veeam Logoby brad126 » Tue Aug 20, 2013 2:52 pm

Recently, we have successfully P2V'ed our Microsoft SQL 2005 server. This was a long overdue project that is now complete, but now I'm brainstorming our backup strategy. We currently use Veeam to backup and replicate our VM's, CA Arcserve to backup our CIFS shares, and the CA Arcserve agent to backup SQL.

Are most who use Veeam to backup SQL using a combination of Veeam and your general backup software (Arcserve, Backup Exec, etc.)? Reason I ask is I'd love to drop the CA agent and strictly use Veeam, but the agent is extremely useful if/when having to restore a single database.

What's the best approach that Veeam guys/girls are using to backup SQL VM's?
brad126
Novice
 
Posts: 5
Liked: never
Joined: Thu Mar 14, 2013 6:11 pm

Re: Veeam Backup & Replication SQL Server - need tutorial

Veeam Logoby foggy » Tue Aug 20, 2013 3:21 pm

You can successfully restore single database files from backups created by Veeam B&R, no problems with that. Please review the topic above for general recommendations on backing up SQL Server with Veeam B&R.
foggy
Veeam Software
 
Posts: 14716
Liked: 1075 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Veeam Backup & Replication SQL Server - need tutorial

Veeam Logoby brad126 » Wed Aug 21, 2013 2:00 am

foggy wrote:You can successfully restore single database files from backups created by Veeam B&R, no problems with that. Please review the topic above for general recommendations on backing up SQL Server with Veeam B&R.



Is there any considerations to keep in mind when choosing between synthetic full and active full when it comes to SQL?
brad126
Novice
 
Posts: 5
Liked: never
Joined: Thu Mar 14, 2013 6:11 pm

Re: Veeam Backup & Replication SQL Server - need tutorial

Veeam Logoby Vitaliy S. » Wed Aug 21, 2013 11:34 am

Hello brad,

Synthetic fulls are usually preferable (it doesn't matter whether you backup SQL Server or any other VM) since jobs with Synthetic full configured do not create any load on your production VMs to create full backups. On the other hand, active fulls are also recommended to perform, for example you can do that once a month (depends on your internal backup policies and regulations).

Thank you!
Vitaliy S.
Veeam Software
 
Posts: 19539
Liked: 1097 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Veeam Backup & Replication SQL Server - need tutorial

Veeam Logoby nakamitchi » Fri Mar 10, 2017 12:43 pm

Hello,
What would be different between Veeam B&R v9.5 standart and enterprise versions for MS SQL backup and restore?
We have standart. Can we backup and restore MS SQL? any limitations ?

Thanks
nakamitchi
Novice
 
Posts: 6
Liked: never
Joined: Wed Dec 14, 2016 7:42 am
Full Name: Sysadminas

Next

Return to Microsoft Hyper-V



Who is online

Users browsing this forum: No registered users and 4 guests