Host-based backup of VMware vSphere VMs.
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 »

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
Chief Product Officer
Posts: 31505
Liked: 6689 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: VSS Backup

Post by Gostev »

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 »

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
Veteran
Posts: 282
Liked: 26 times
Joined: Nov 10, 2010 6:51 pm
Full Name: Seth Bartlett
Contact:

Re: VSS Backup

Post by Sethbartlett »

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 »

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 »

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: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: VSS Backup

Post by foggy » 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 »

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
Veteran
Posts: 295
Liked: 59 times
Joined: Sep 06, 2011 8:45 am
Full Name: Haris Cokovic
Contact:

Re: VSS Backup

Post by Cokovic » 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 »

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.
VP, Product Management
Posts: 27097
Liked: 2715 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: VSS Backup

Post by Vitaliy S. »

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
Veteran
Posts: 295
Liked: 59 times
Joined: Sep 06, 2011 8:45 am
Full Name: Haris Cokovic
Contact:

Re: VSS Backup

Post by Cokovic »

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: 13
Liked: never
Joined: Jan 23, 2010 1:02 am
Full Name: Richard Ihmels
Contact:

Re: VSS Backup

Post by RJI »

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: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: VSS Backup

Post by foggy » 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: No registered users and 30 guests