Comprehensive data protection for all workloads
Post Reply
PNWMtnBiker
Enthusiast
Posts: 63
Liked: 8 times
Joined: Jan 16, 2014 11:12 pm
Full Name: Jon Dufour
Contact:

Backup up SQL Express

Post by PNWMtnBiker » Apr 11, 2015 2:24 pm 1 person likes this post

How does backup for a SQL Express database work? Will Veeam do the same database backup that it would for a full SQL server?

PNWMtnBiker
Enthusiast
Posts: 63
Liked: 8 times
Joined: Jan 16, 2014 11:12 pm
Full Name: Jon Dufour
Contact:

Re: Backup up SQL Express

Post by PNWMtnBiker » Apr 11, 2015 9:17 pm 1 person likes this post

I should also add, being the free version I don't feel like I can expect the same SQL restore capabilities that I would with a full version. Likely nothing more than log truncation?

Vitaliy S.
Product Manager
Posts: 22777
Liked: 1526 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Backup up SQL Express

Post by Vitaliy S. » Apr 12, 2015 1:53 pm

If we are talking about VeeamZIP capability, then it does not allow log shipping/truncation or any other advanced settings of the backup job. Please take a look at our online user guide for more details regarding how application-aware backups are done> VM Guest OS Quiescence

Gostev
SVP, Product Management
Posts: 24473
Liked: 3413 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Backup up SQL Express

Post by Gostev » Apr 12, 2015 6:19 pm 1 person likes this post

I think he is asking if transaction log backup works for SQL Express databases.

Vitaliy S.
Product Manager
Posts: 22777
Liked: 1526 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Backup up SQL Express

Post by Vitaliy S. » Apr 12, 2015 7:03 pm 1 person likes this post

Ah... in this case SQL Server edition does not matter, you will be able to truncate logs for databases hosted by SQL Server Express as well.

PNWMtnBiker
Enthusiast
Posts: 63
Liked: 8 times
Joined: Jan 16, 2014 11:12 pm
Full Name: Jon Dufour
Contact:

Re: Backup up SQL Express

Post by PNWMtnBiker » Apr 13, 2015 12:21 am

I'm sorry I wasn't clear enough, yes the transaction log backup works fine as well as log truncation. I mean backing up SQL DB's and being able to restore a DB using SQL explorer in the same way that it would work for SQL Standard or Enterprise.

foggy
Veeam Software
Posts: 18037
Liked: 1533 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Backup up SQL Express

Post by foggy » Apr 13, 2015 6:35 am

SQL Server edition does not matter here as well. If you're after differences between free and paid Veeam B&R editions, then please review this comparison.

albertwt
Expert
Posts: 640
Liked: 20 times
Joined: Nov 05, 2009 12:24 pm
Location: Sydney, NSW
Contact:

Re: Backup up SQL Express

Post by albertwt » Apr 13, 2015 9:11 am

PNWMtnBiker wrote:I'm sorry I wasn't clear enough, yes the transaction log backup works fine as well as log truncation. I mean backing up SQL DB's and being able to restore a DB using SQL explorer in the same way that it would work for SQL Standard or Enterprise.
ok, so if my Windows VM contains the SQL Server Express edition, can I just create normal Backup Job and then select the application-aware backup option ?
--
/* Veeam software enthusiast user & supporter ! */

veremin
Product Manager
Posts: 16710
Liked: 1396 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Backup up SQL Express

Post by veremin » Apr 13, 2015 10:07 am 1 person likes this post

Correct. You can additionally set SQL-specific option, using corresponding tab. Thanks.

PNWMtnBiker
Enthusiast
Posts: 63
Liked: 8 times
Joined: Jan 16, 2014 11:12 pm
Full Name: Jon Dufour
Contact:

Re: Backup up SQL Express

Post by PNWMtnBiker » Apr 13, 2015 5:24 pm

albertwt wrote: ok, so if my Windows VM contains the SQL Server Express edition, can I just create normal Backup Job and then select the application-aware backup option ?
Yes, this is what I was trying to say, thank you. This is exactly how the job is setup.

This is all coming from our DBA who tells me the DB's aren't being backed up on this VM which is SQL Express. I tried to test a SQL restore on this VM and nothing came up in the SQL explorer vs. how it does if I test a restore on a VM with SQL Standard or Enterprise.

PNWMtnBiker
Enthusiast
Posts: 63
Liked: 8 times
Joined: Jan 16, 2014 11:12 pm
Full Name: Jon Dufour
Contact:

Re: Backup up SQL Express

Post by PNWMtnBiker » Apr 13, 2015 5:34 pm

Well, I'm fuzzy if something happened but I tested doing a SQL restore with this SQL Express server again just now from last nights backup and the DB's are showing up this time in the explorer.

veremin
Product Manager
Posts: 16710
Liked: 1396 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Backup up SQL Express

Post by veremin » Apr 14, 2015 10:19 am

Glad to hear that you've solved the problem. Should it reoccur again, don't hesitate to open a ticket with our support team. Thanks.

mohd.omar
Influencer
Posts: 12
Liked: 1 time
Joined: Sep 07, 2016 5:23 am
Full Name: Mohd Omar
Contact:

[MERGED] can veeam take a backup on SQL express DB?

Post by mohd.omar » Nov 10, 2016 8:23 am

hi all,
just want to know please if veeam backup and replication provide DB backup solution on SQL express version?

any reply or help is highly appreciated

foggy
Veeam Software
Posts: 18037
Liked: 1533 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: can veeam take a backup on SQL express DB?

Post by foggy » Nov 10, 2016 9:45 am 1 person likes this post

Yes, SQL Express can be backed up with Veeam B&R. Thanks.

mohd.omar
Influencer
Posts: 12
Liked: 1 time
Joined: Sep 07, 2016 5:23 am
Full Name: Mohd Omar
Contact:

Re: can veeam take a backup on SQL express DB?

Post by mohd.omar » Nov 10, 2016 10:36 am

Hi Foggy,
thank you so much ,
so what ever the job is replication or backup for sql express will be taken by veeam
appreciate your answer.
B regards

foggy
Veeam Software
Posts: 18037
Liked: 1533 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Backup up SQL Express

Post by foggy » Nov 10, 2016 10:37 am

Yes, job type doesn't matter.

Post Reply

Who is online

Users browsing this forum: Google [Bot] and 16 guests