Discussions specific to the VMware vSphere hypervisor
Post Reply
Darkyputz
Enthusiast
Posts: 27
Liked: never
Joined: Feb 16, 2016 7:51 pm
Full Name: Jan Meinecke
Contact:

Backup job warns me about missing vss writer

Post by Darkyputz » Feb 22, 2016 7:46 pm

Hello!

I am new to this backup solution, and unfortunately, the KB ID: 2095 that i found to that subject is sub optimal when it comes to solve the issue
It states, that my SQl database is having a space in its name...but after checking my existing databases, none of them is having spaces in name or before nor after.

I just did a query of my databases...and they look spaceless:
Select '#'+name+'#' from sys.databases
#master#
#tempdb#
#model#
#msdb#
#amwsys#
#sample999#
#testrestore#
#law#
#KDAD#
#java#

Did anyone came across that issue before and found a fix?
Thx in advance and here the KB to that issue:

Products: Veeam Backup & Replication
Version: 9.x

Job reports warning "SQL VSS Writer is missing: databases will be backed up in crash-consistent state and transaction log processing will be skipped"
Cause

Your SQL instance have databases with names ending in a space character.
Solution

Please rename the database to a new name (without a space in it)
More Information

Running vssadmin list writers shows that SqlServerWriter in not in the list.

alanbolte
Expert
Posts: 635
Liked: 172 times
Joined: Jun 18, 2012 8:58 pm
Full Name: Alan Bolte
Contact:

Re: Backup job warns me about missing vss writer

Post by alanbolte » Feb 22, 2016 10:14 pm

Is the SQL Writer service actually running?

Otherwise, I recommend creating a support case, and posting the case ID here.

Doan
Novice
Posts: 3
Liked: 1 time
Joined: Feb 23, 2016 3:38 pm
Full Name: Luan Doan
Contact:

Re: Backup job warns me about missing vss writer

Post by Doan » Feb 23, 2016 3:39 pm

I have the same issue after upgrading to version 9.
The service is running.

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

Re: Backup job warns me about missing vss writer

Post by Gostev » Feb 23, 2016 9:03 pm

What is your support case ID for this issue?

Scraps
Lurker
Posts: 1
Liked: never
Joined: Feb 24, 2016 11:11 am
Full Name: Ryan
Contact:

Re: Backup job warns me about missing vss writer

Post by Scraps » Feb 24, 2016 11:22 am

Hi Guys

I have the same issue after upgrading to V9.
Had no issues on V8 only now after I upgraded to V9 the problem started. My case ID # 01707939

alanbolte
Expert
Posts: 635
Liked: 172 times
Joined: Jun 18, 2012 8:58 pm
Full Name: Alan Bolte
Contact:

Re: Backup job warns me about missing vss writer

Post by alanbolte » Feb 24, 2016 3:35 pm

What version of SQL are all of you running? If I recall correctly, early versions of SQL Server 2005 used the MSDE writer instead of the SQL writer, and we only support the latter.

Doan
Novice
Posts: 3
Liked: 1 time
Joined: Feb 23, 2016 3:38 pm
Full Name: Luan Doan
Contact:

Re: Backup job warns me about missing vss writer

Post by Doan » Feb 26, 2016 9:16 am

My suppor case ID is: 01708116

We are running SQL Server 2008R2.

We do also have customers with the same setup, where we don't have this issue.

eneurink
Lurker
Posts: 1
Liked: never
Joined: Feb 29, 2016 11:39 am
Full Name: Erik Neurink
Contact:

Re: Backup job warns me about missing vss writer

Post by eneurink » Feb 29, 2016 11:44 am

Hello,
I am sorry, my Englisch is not so good but, we have the same problem. After installing te upgrade to version 9 i get the error "SQL VSS Writer is missing: databases will be backed up in crash-consistent state"
The error is with backing-up de the SQL server switch is Using SQL 2005 but with the VSS Writer.
The VSS Writer is logging in with the administrator account and still the problem.
I hope some one has an awnser or bether, a sollution for this problem.
Thanx
Erik

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

Re: Backup job warns me about missing vss writer

Post by Vitaliy S. » Feb 29, 2016 12:33 pm

Please take a look at this KB article. If it doesn't help, please open a support case to investigate this issue further.

Doan
Novice
Posts: 3
Liked: 1 time
Joined: Feb 23, 2016 3:38 pm
Full Name: Luan Doan
Contact:

Re: Backup job warns me about missing vss writer

Post by Doan » Mar 02, 2016 8:23 am 1 person likes this post

Giving the account under which SQL VSS Writer service is running the sysadmin role solved my issue.

Go to services.msc and check the Log On As.
Connect to all named instances and check if the account has sysadmin role. If you don't see the Log On As account, you will have to create a New Login... and give it sysadmin role.

GregorS
Veeam ProPartner
Posts: 33
Liked: 10 times
Joined: Apr 10, 2013 12:11 pm
Full Name: Gregor Smerke
Location: Ljubljana, SI - Slovenija
Contact:

Re: Backup job warns me about missing vss writer

Post by GregorS » Mar 15, 2016 11:01 am

Hi!

I've got this old Windows XP VM with MS SQL Server 2005 Express. SQL Server (<Instance>) system service is running under Network Service account and SQL Server VSS Writer service is running under Local System account. The account used for application-aware processing (AAP) guest OS credentials has sysadmin server role. Nothing from KB2095 seems to apply, SqlServerWriter is in Stable state. The best part is that Veeam backup job performs correctly regarding AAP on this SQL! It's just that since VBR upgrade to v9.0 there's this silly warning that triggers e-mail being sent to my mailbox every morning. Do you need another ticket lifted or is it already known that a remedy for this specific issue will be included in the upcoming Update 1?


Regards
Gregor

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

Re: Backup job warns me about missing vss writer

Post by foggy » Mar 15, 2016 11:28 am

GregorS wrote:SQL Server VSS Writer service is running under Local System account.
In the Luan's case giving the account under which SQL Server VSS Writer service is running the sysadmin role resolved the issue. Could you please check this is the case? Also, restarting the service did help in another case mentioned in this thread.

GregorS
Veeam ProPartner
Posts: 33
Liked: 10 times
Joined: Apr 10, 2013 12:11 pm
Full Name: Gregor Smerke
Location: Ljubljana, SI - Slovenija
Contact:

Re: Backup job warns me about missing vss writer

Post by GregorS » Mar 16, 2016 1:54 pm

NT AUTHORITY\SYSTEM is sysadmin. Service restart did not help.

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

Re: Backup job warns me about missing vss writer

Post by foggy » Mar 16, 2016 1:55 pm

Then I suggest opening your own case for investigation.

GregorS
Veeam ProPartner
Posts: 33
Liked: 10 times
Joined: Apr 10, 2013 12:11 pm
Full Name: Gregor Smerke
Location: Ljubljana, SI - Slovenija
Contact:

Re: Backup job warns me about missing vss writer

Post by GregorS » Mar 17, 2016 12:36 pm 1 person likes this post

SUPPORT CASE ID# 01733384

enoch
Service Provider
Posts: 145
Liked: 10 times
Joined: Jun 29, 2013 12:14 pm
Full Name: Peter Enoch
Contact:

Re: Backup job warns me about missing vss writer

Post by enoch » Mar 20, 2016 3:03 pm

Also have this issue with one VM.

Before v9.0 (8.0) there was not a warning.

Have checked that the service account running as SQL VSS Writer is Sysadmin on SQL.

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

Re: Backup job warns me about missing vss writer

Post by foggy » Mar 21, 2016 9:47 am

Do you have a case opened for this?

enoch
Service Provider
Posts: 145
Liked: 10 times
Joined: Jun 29, 2013 12:14 pm
Full Name: Peter Enoch
Contact:

Re: Backup job warns me about missing vss writer

Post by enoch » Mar 21, 2016 10:15 am

No, but will do today.

I was asking because it could have been har general issue/problem.

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

Re: Backup job warns me about missing vss writer

Post by foggy » Mar 21, 2016 10:21 am

Based on this thread, the behavior can be caused by different issues, so it is recommended to check with support.

showstopper
Lurker
Posts: 2
Liked: never
Joined: Mar 30, 2016 9:09 am
Full Name: Tony Shawyer
Contact:

Re: Backup job warns me about missing vss writer

Post by showstopper » Mar 30, 2016 9:11 am

GregorS wrote:SUPPORT CASE ID# 01733384
Did you manage to fix your issue? I have exactly the same issue with XP and SQL Express - working under 8, but "fails" in 9.

showstopper
Lurker
Posts: 2
Liked: never
Joined: Mar 30, 2016 9:09 am
Full Name: Tony Shawyer
Contact:

Re: Backup job warns me about missing vss writer

Post by showstopper » Mar 30, 2016 10:00 am

showstopper wrote: Did you manage to fix your issue? I have exactly the same issue with XP and SQL Express - working under 8, but "fails" in 9.

EDIT - I updated to Update 1 and i still have the same issue.
I will log a call with support.

GregorS
Veeam ProPartner
Posts: 33
Liked: 10 times
Joined: Apr 10, 2013 12:11 pm
Full Name: Gregor Smerke
Location: Ljubljana, SI - Slovenija
Contact:

Re: Backup job warns me about missing vss writer

Post by GregorS » Mar 30, 2016 11:19 am

Hi Tony

Support stated that XP was no longer a supported OS and that they would not be fixing this. As I understood they excluded the XP version of the SQL VSS API from VBR v9... or something...

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

Re: Backup job warns me about missing vss writer

Post by veremin » Mar 30, 2016 5:51 pm

Application Aware logic including SQL logs processing works for Microsoft Windows 2003 and later, meaning XP is out of scope here. Thanks.

Dave
Enthusiast
Posts: 28
Liked: never
Joined: Dec 17, 2009 3:45 pm
Full Name: DT
Contact:

Re: Backup job warns me about missing vss writer

Post by Dave » Apr 21, 2016 9:46 am

Hi,

Is there an option to suppress the warning message, we have disabled the sql vss writer service. In veeam 8 we did not get this warning message.

Regards,
Dave

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

Re: Backup job warns me about missing vss writer

Post by foggy » Apr 21, 2016 6:57 pm

v8 didn't have this check and just silently performed database backup in crash consistent state. I don't think there's a way to suppress this warning.

m.novelli
Veeam ProPartner
Posts: 353
Liked: 40 times
Joined: Dec 29, 2009 12:48 pm
Full Name: Marco Novelli
Location: Asti - Italy
Contact:

Re: Backup job warns me about missing vss writer

Post by m.novelli » Jul 26, 2016 7:44 am

Hello guys, I'm having the same warning after upgrading a customer to Veeam Backup v9 Update 1

The VM is a Windows XP SP3 with SQL Server 2005 Express SP4

Is there a way to suppress the warning "SQL VSS Writer is missing"?

Many thanks!

Marco

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

Re: Backup job warns me about missing vss writer

Post by Vitaliy S. » Jul 26, 2016 10:29 am

I guess you can suppress this by disabling application-aware image processing for this VM and switch to VMware Tools Quiescence.

iknowtech
Service Provider
Posts: 24
Liked: 6 times
Joined: Oct 26, 2017 1:11 am
Full Name: Jason Brantley
Contact:

Re: Backup job warns me about missing vss writer

Post by iknowtech » Jul 25, 2019 3:10 pm

Hmm, I'm getting his on Server 2019, with SQL Server Express 2014. Was anyone getting this that wasn't on XP that got a resolution with support?

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

Re: Backup job warns me about missing vss writer

Post by foggy » Aug 05, 2019 4:49 pm

Hi Jason, I recommend contacting support directly with this unless you've already done so.

iknowtech
Service Provider
Posts: 24
Liked: 6 times
Joined: Oct 26, 2017 1:11 am
Full Name: Jason Brantley
Contact:

Re: Backup job warns me about missing vss writer

Post by iknowtech » Aug 10, 2019 10:20 pm 1 person likes this post

I was able to confirm that it was an issue with the SQL VSS Writer service not having Access to SQL. I had to get the LOB App vendor to provide me the SA login to SQL Express so I could setup a service account with SysAdmin rights, then use that account for the VSS Writer Service.

Post Reply

Who is online

Users browsing this forum: Bing [Bot] and 10 guests