Veeam SQL backup and VSS writer errors question

Hello all,

I hope you could clarify this for me, I am currently working with some one who has a very old Veeam backup server currently running version 5 and we can not upgrade at the moment.
The Veeam backup is configured as "application aware" so VSS should pause I/O to the SQL server data base to during the backup. At the moment backups appear to fail when SQL VSS writer service is running however as soon as I disable the service the backup appears to complete successfully with no errors. Since we have no support for Veeam at the moment I hope some one could answer this for me, does Veeam require the SQL VSS writer service to backup recover the VM at a later date? Or can I leave it disabled?
LVL 1
Nolan GustavoAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Vitor MontalvãoMSSQL Senior EngineerCommented:
Are you using Veeam to backup the data and log files?
0
Nolan GustavoAuthor Commented:
Yes I am Victor, Veeam is the only backup solution currently in place.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
I think the problem is really because of that. SQL Server doesn't let any other process to touch the database files and that's why you are getting that issue. Also, isn't the right way to backup a database.
If Veeam doesn't allows you to backup a SQL Server database but only files then you need to use SQL Server to perform native backup on the databases and then you can use Veeam to backup the backup files. Did I make myself clear?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Nolan GustavoAuthor Commented:
Makes sense, thank you Victor.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Storage Software

From novice to tech pro — start learning today.