Backup up SQL Express

Availability for the Always-On Enterprise

Backup up SQL Express

Veeam Logoby PNWMtnBiker » Sat 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: Thu Jan 16, 2014 11:12 pm
Full Name: Jon Dufour

Re: Backup up SQL Express

Veeam Logoby PNWMtnBiker » Sat 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?
PNWMtnBiker
Enthusiast
 
Posts: 63
Liked: 8 times
Joined: Thu Jan 16, 2014 11:12 pm
Full Name: Jon Dufour

Re: Backup up SQL Express

Veeam Logoby Vitaliy S. » Sun 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
Vitaliy S.
Veeam Software
 
Posts: 19972
Liked: 1145 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Backup up SQL Express

Veeam Logoby Gostev » Sun 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.
Gostev
Veeam Software
 
Posts: 21621
Liked: 2411 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: Backup up SQL Express

Veeam Logoby Vitaliy S. » Sun 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.
Vitaliy S.
Veeam Software
 
Posts: 19972
Liked: 1145 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Backup up SQL Express

Veeam Logoby PNWMtnBiker » Mon 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.
PNWMtnBiker
Enthusiast
 
Posts: 63
Liked: 8 times
Joined: Thu Jan 16, 2014 11:12 pm
Full Name: Jon Dufour

Re: Backup up SQL Express

Veeam Logoby foggy » Mon 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.
foggy
Veeam Software
 
Posts: 15295
Liked: 1133 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Backup up SQL Express

Veeam Logoby albertwt » Mon 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 ! */
albertwt
Expert
 
Posts: 621
Liked: 20 times
Joined: Thu Nov 05, 2009 12:24 pm
Location: Sydney, NSW

Re: Backup up SQL Express

Veeam Logoby v.Eremin » Mon Apr 13, 2015 10:07 am 1 person likes this post

Correct. You can additionally set SQL-specific option, using corresponding tab. Thanks.
v.Eremin
Veeam Software
 
Posts: 13734
Liked: 1027 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: Backup up SQL Express

Veeam Logoby PNWMtnBiker » Mon Apr 13, 2015 5:24 pm

albertwt wrote:
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 ?


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: Thu Jan 16, 2014 11:12 pm
Full Name: Jon Dufour

Re: Backup up SQL Express

Veeam Logoby PNWMtnBiker » Mon 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.
PNWMtnBiker
Enthusiast
 
Posts: 63
Liked: 8 times
Joined: Thu Jan 16, 2014 11:12 pm
Full Name: Jon Dufour

Re: Backup up SQL Express

Veeam Logoby v.Eremin » Tue 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.
v.Eremin
Veeam Software
 
Posts: 13734
Liked: 1027 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

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

Veeam Logoby mohd.omar » Thu 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
mohd.omar
Influencer
 
Posts: 12
Liked: 1 time
Joined: Wed Sep 07, 2016 5:23 am
Full Name: Mohd Omar

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

Veeam Logoby foggy » Thu Nov 10, 2016 9:45 am 1 person likes this post

Yes, SQL Express can be backed up with Veeam B&R. Thanks.
foggy
Veeam Software
 
Posts: 15295
Liked: 1133 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

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

Veeam Logoby mohd.omar » Thu 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
mohd.omar
Influencer
 
Posts: 12
Liked: 1 time
Joined: Wed Sep 07, 2016 5:23 am
Full Name: Mohd Omar

Next

Return to Veeam Backup & Replication



Who is online

Users browsing this forum: arnaud.quenum and 1 guest