Discussions specific to the VMware vSphere hypervisor
Post Reply
kellison
Enthusiast
Posts: 25
Liked: never
Joined: Dec 22, 2009 5:56 pm
Full Name: Ken Ellison
Contact:

VSS Backup

Post by kellison » Dec 14, 2011 8:18 pm

I configured a backup to use the application-aware image processing (uses the Microsoft VSS). How can I verify that in fact it did quiesce my SQL database when it performed the snapshot? Looking at the Veeam backup job log it only shows that the snapshot took place.

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

Re: VSS Backup

Post by Gostev » Dec 14, 2011 8:44 pm

Does the Veeam log say "Preparing guest for hot backup"? This means AAIP is used.
You can also look for VSS events in the system event log of the corresponding VM.

kellison
Enthusiast
Posts: 25
Liked: never
Joined: Dec 22, 2009 5:56 pm
Full Name: Ken Ellison
Contact:

Re: VSS Backup

Post by kellison » Dec 15, 2011 4:33 pm

Yes, the Veeam log does say "Preparing guest for hot backup"?

You mentioned "This means AAIP is used" - I am not familiar with that acronym. Are you saying that if I see that in the Veeam log then it is quiescing my SQL database?

I looked at the event log on my SQL VM but do not see anything there pertaining to VSS events.

Sethbartlett
Expert
Posts: 282
Liked: 25 times
Joined: Nov 10, 2010 6:51 pm
Full Name: Seth Bartlett
Contact:

Re: VSS Backup

Post by Sethbartlett » Dec 15, 2011 4:35 pm

AAIP = Application-aware image processing. Your job will fail (or log a warning - depending on settings) if VSS/AAIP fails also.
Skype: Sethbartlett88 - Make sure to label who you are and why you want to add me ;)
Twitter: @sethbartlett
If my post was helpful, please like it. Sometimes twitter is quicker to hit me up if you need me.

wberryment
Novice
Posts: 3
Liked: never
Joined: Dec 09, 2011 8:23 pm
Full Name: Wayne
Contact:

Re: VSS Backup

Post by wberryment » Dec 15, 2011 7:10 pm

You can also look at your SQL log file to see if it locked transactions to sql during the time frame of your backup.
wayne

mteamjpy
Enthusiast
Posts: 74
Liked: never
Joined: Aug 10, 2011 12:31 pm
Contact:

Re: VSS Backup

Post by mteamjpy » Jul 10, 2012 10:06 am

hi , does this explanation still exact in 6.1 ?

i only got job started
building vm
vm size
CBT
prepare next vm (?)
processing
al vm have been ...

so i do not see "Preparing guest for hot backup"

sorry but i prefer to ask

regards

Jean -pol

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

Re: VSS Backup

Post by foggy » Jul 10, 2012 2:10 pm 1 person likes this post

Yes, this message should be logged in the job session in case VSS is engaged. Make sure you have enabled application-aware image processing in the job settings (as it is not enabled by default) and that the VM is turned on. In any case, the reason why you do not see the message can be found in the job log file, feel free to contact technical support service to assist you in reviewing the log file. Also, SQL Server event log could help in troubleshooting. Thanks!

mteamjpy
Enthusiast
Posts: 74
Liked: never
Joined: Aug 10, 2011 12:31 pm
Contact:

Re: VSS Backup

Post by mteamjpy » Jul 10, 2012 3:51 pm

thanks foggy ,

all i got from the event viewer is that VSS is timed out
no other error explaining me this time out.

i don't event see him receive the command either .


how could i determine this ?

thanks

Jean-pol

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

Re: VSS Backup

Post by Cokovic » Jul 10, 2012 4:42 pm 4 people like this post

1. Check that application aware image processing is activated
2. Under advanced settings in application aware image processing: what are your settings there? Require success?
3. On your SQL server open a command prompt andy type: vssadmin list writers. How is the state of you SQL writer?

If your SQL VSS writer is in a failed state or timed out or both try the following:

net stop SQLWriter
net start SQLWriter

net stop EventSystem
press y to confirm all other services.

net stop swprv
net stop vss
net stop vmvss
net stop VMTools
net stop VMUpgradeHelper
net stop ReportServer
net stop winmgmt
net start EventSystem
net start swprv
net start vss
net start vmvss
net start VMTools
net start VMUpgradeHelper
net start ReportServer
net start winmgmt

Then run your backup again. This is what helped me with a VSS timeout issue on a SQL server.

Cheers,
Haris

mteamjpy
Enthusiast
Posts: 74
Liked: never
Joined: Aug 10, 2011 12:31 pm
Contact:

Re: VSS Backup

Post by mteamjpy » Jul 11, 2012 11:44 am

2. Under advanced settings in application aware image processing: what are your settings there? Require success?

with tested the two parameters , no change

3. the list writter respond with no error

4. i restarted the vss just before the backup no change

also we get some shareporint component over it , maybe additional step is needed?

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

Re: VSS Backup

Post by Vitaliy S. » Jul 11, 2012 1:45 pm

No additional steps are needed, If you configure your backup job to require success on VSS freeze and your backup job does not fail, that means that all your VMs within this job have been successfully backed up with "application-aware image processing".

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

Re: VSS Backup

Post by Cokovic » Jul 11, 2012 1:54 pm

mteamjpy wrote:hi , does this explanation still exact in 6.1 ?

i only got job started
building vm
vm size
CBT
prepare next vm (?)
processing
al vm have been ...

so i do not see "Preparing guest for hot backup"

sorry but i prefer to ask

regards

Jean -pol
When you double click your job to see the statistics please click the VM in the left pane. Then you will see some addtional informations in the right pane regarding this VM. And there you should see the VSS processing entries. What you described here is just the overall statistics from the report. That is why you cant see the VSS processing information :)

RJI
Service Provider
Posts: 12
Liked: never
Joined: Jan 23, 2010 1:02 am
Full Name: Richard Ihmels
Contact:

Re: VSS Backup

Post by RJI » Jul 19, 2012 7:24 pm

Gostev wrote: Does the Veeam log say "Preparing guest for hot backup"? This means AAIP is used.
You can also look for VSS events in the system event log of the corresponding VM.

Do you know if this logging to the event log can be enabled/disabled? Is it writer dependant? I am sure I have seen successful messages before, but that may have been on an Exchange server.

My Veeam job runs fine and does state "Preparing guest for hot backup" but nothing is listed in the VM's Application or System event logs.

Veeam v6.1 backing up a Windows Server 2003 Standard guest.

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

Re: VSS Backup

Post by foggy » Jul 20, 2012 11:04 am 1 person likes this post

You should see Event ID 7036 messages about the Volume Shadow Copy and Microsoft Software Shadow Copy Provider services entering the running/stopping state during backup in the System log.

Post Reply

Who is online

Users browsing this forum: iostrikov and 30 guests