Comprehensive data protection for all workloads
Post Reply
bunger
Expert
Posts: 117
Liked: 8 times
Joined: Jun 23, 2010 5:39 pm
Full Name: Bill Unger
Contact:

Should I use VSS to backup SQL Server

Post by bunger » Nov 01, 2012 1:23 pm

I just changed a server backup to use "application-aware image processing" and the backup is now failing with VSS issues. In reading various posts, I saw a mention that I shouldn't enable this option for servers running SQL. Is that true?

Thanks
Bill

jpeake
Enthusiast
Posts: 88
Liked: 25 times
Joined: Sep 25, 2012 7:57 pm
Contact:

Re: Should I use VSS to backup SQL Server

Post by jpeake » Nov 01, 2012 1:44 pm

What errors are you seeing? Curious about this one. I use VSS for our SQL servers and it seems to work fine...

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

Re: Should I use VSS to backup SQL Server

Post by Vitaliy S. » Nov 01, 2012 1:53 pm

bunger wrote:I saw a mention that I shouldn't enable this option for servers running SQL
If you want to backup your SQL Server VM in a consistent state you simple have to enable this option :) See our sticky F.A.Q. for additional information.

As to the error messages you observe, then please contact our support team for further troubleshooting as it described when you click New Topic. Thanks!

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

Re: Should I use VSS to backup SQL Server

Post by veremin » Nov 01, 2012 2:05 pm

Hi, Bill.

For the purpose of complete understanding may I ask you to provide a full description of error. Your issue seems to be confusing for me, since this function ("application-aware image processing") was created deliberately to guarantee a transactionally consistent backup of a VM running VSS aware applications (such as Active Directory, Microsoft SQL, Microsoft Exchange, Sharepoint) without shutting them down. It is Veeam’s proprietary technology that ensures successful VM recovery, as well as proper recovery of all applications installed on the VM without any data loss. So, it should work fine without any issues.

Please also make sure the user account you are providing has local administrator privileges on guest OS.

Best regards, Vladimir.

Cokovic
Expert
Posts: 295
Liked: 59 times
Joined: Sep 06, 2011 8:45 am
Full Name: Haris Cokovic
Contact:

Re: Should I use VSS to backup SQL Server

Post by Cokovic » Nov 01, 2012 3:33 pm

I've always came along with two possible solutions in such a case:

1. If SharePoint is present on that server and after installing the latest Servicepack for SharePoint it's necessary to run following line once:

psconfig –cmd upgrade –inplace b2b -wait

After that VSS backups went fine again.

2. Can't tell you exactly why but i do have one SQL server that needs to get some services shutdown and restarted in a specific order to get the backup working again. Have to do it after every reboot (for example after installing Windows patches). I've mentioned the necessary steps in an older post here.

Thanks,
Haris

Post Reply

Who is online

Users browsing this forum: No registered users and 10 guests