Discussions specific to the VMware vSphere hypervisor
Darkyputz
Influencer
Posts: 23
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
Veeam Software
Posts: 23216
Liked: 2970 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.
Veeam Software
Posts: 21726
Liked: 1306 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: 32
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: 17116
Liked: 1399 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: 32
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: 17116
Liked: 1399 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: 32
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

Post Reply

Who is online

Users browsing this forum: Baidu [Spider] and 14 guests