Backup job warns me about missing vss writer

VMware specific discussions

Backup job warns me about missing vss writer

Veeam Logoby Darkyputz » Mon 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.
Darkyputz
Influencer
 
Posts: 23
Liked: never
Joined: Tue Feb 16, 2016 7:51 pm
Full Name: Jan Meinecke

Re: Backup job warns me about missing vss writer

Veeam Logoby alanbolte » Mon 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.
alanbolte
Expert
 
Posts: 635
Liked: 170 times
Joined: Mon Jun 18, 2012 8:58 pm
Full Name: Alan Bolte

Re: Backup job warns me about missing vss writer

Veeam Logoby Doan » Tue Feb 23, 2016 3:39 pm

I have the same issue after upgrading to version 9.
The service is running.
Doan
Novice
 
Posts: 3
Liked: 1 time
Joined: Tue Feb 23, 2016 3:38 pm
Full Name: Luan Doan

Re: Backup job warns me about missing vss writer

Veeam Logoby Gostev » Tue Feb 23, 2016 9:03 pm

What is your support case ID for this issue?
Gostev
Veeam Software
 
Posts: 21385
Liked: 2348 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: Backup job warns me about missing vss writer

Veeam Logoby Scraps » Wed 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
Scraps
Lurker
 
Posts: 1
Liked: never
Joined: Wed Feb 24, 2016 11:11 am
Full Name: Ryan

Re: Backup job warns me about missing vss writer

Veeam Logoby alanbolte » Wed 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.
alanbolte
Expert
 
Posts: 635
Liked: 170 times
Joined: Mon Jun 18, 2012 8:58 pm
Full Name: Alan Bolte

Re: Backup job warns me about missing vss writer

Veeam Logoby Doan » Fri 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.
Doan
Novice
 
Posts: 3
Liked: 1 time
Joined: Tue Feb 23, 2016 3:38 pm
Full Name: Luan Doan

Re: Backup job warns me about missing vss writer

Veeam Logoby eneurink » Mon 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
eneurink
Lurker
 
Posts: 1
Liked: never
Joined: Mon Feb 29, 2016 11:39 am
Full Name: Erik Neurink

Re: Backup job warns me about missing vss writer

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

Re: Backup job warns me about missing vss writer

Veeam Logoby Doan » Wed 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.
Doan
Novice
 
Posts: 3
Liked: 1 time
Joined: Tue Feb 23, 2016 3:38 pm
Full Name: Luan Doan

Re: Backup job warns me about missing vss writer

Veeam Logoby GregorS » Tue 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
GregorS
Veeam ProPartner
 
Posts: 24
Liked: 7 times
Joined: Wed Apr 10, 2013 12:11 pm
Location: Ljubljana, SI - Slovenija
Full Name: Gregor Smerke

Re: Backup job warns me about missing vss writer

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

Re: Backup job warns me about missing vss writer

Veeam Logoby GregorS » Wed Mar 16, 2016 1:54 pm

NT AUTHORITY\SYSTEM is sysadmin. Service restart did not help.
GregorS
Veeam ProPartner
 
Posts: 24
Liked: 7 times
Joined: Wed Apr 10, 2013 12:11 pm
Location: Ljubljana, SI - Slovenija
Full Name: Gregor Smerke

Re: Backup job warns me about missing vss writer

Veeam Logoby foggy » Wed Mar 16, 2016 1:55 pm

Then I suggest opening your own case for investigation.
foggy
Veeam Software
 
Posts: 14712
Liked: 1075 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Backup job warns me about missing vss writer

Veeam Logoby GregorS » Thu Mar 17, 2016 12:36 pm 1 person likes this post

SUPPORT CASE ID# 01733384
GregorS
Veeam ProPartner
 
Posts: 24
Liked: 7 times
Joined: Wed Apr 10, 2013 12:11 pm
Location: Ljubljana, SI - Slovenija
Full Name: Gregor Smerke

Next

Return to VMware vSphere



Who is online

Users browsing this forum: DGrinev, rweis and 31 guests