List of snapshots

Management reporting and documentation

List of snapshots

Veeam Logoby felyjos » Tue Dec 03, 2013 8:22 pm

Hello,

Do we have a report in VeeamOne, Veeam Backup, vCenter, etc... which lists all snapshots took for a particular VM within the last 24 hours?
Thanks,
DOm
felyjos
Expert
 
Posts: 285
Liked: 3 times
Joined: Wed Jun 08, 2011 5:46 pm
Full Name: Dominique DUCHEMIN

Re: List of snapshots

Veeam Logoby Vitaliy S. » Wed Dec 04, 2013 6:42 am 1 person likes this post

Hi Dom,

Do you mean the historical information about all snapshots? Not sure this information is stored somewhere, however you may want to use Custom report pack to review all existing snapshot files. Out of curiosity, why do you need this information?

Thanks!
Vitaliy S.
Veeam Software
 
Posts: 19539
Liked: 1097 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: List of snapshots

Veeam Logoby felyjos » Wed Dec 04, 2013 1:59 pm

Hi Vitaly,

Yes it is an historical about snapshots I need. I will check the Custom Report Pack.
I would like this information as several VMs SQL backup are failing when they have an existing snapshot at the time of the SQL backup.
"BackupVirtualDeviceFile::PrepareToFreeze: failure on backup device '{4FEEA406-DD73-47D8-BC10-0ADAD6A44D6D}1'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).
BACKUP failed to complete the command BACKUP DATABASE ADWDB. Check the backup application log for detailed messages."

Still in progress....
Thanks,
Dom
felyjos
Expert
 
Posts: 285
Liked: 3 times
Joined: Wed Jun 08, 2011 5:46 pm
Full Name: Dominique DUCHEMIN

Re: List of snapshots

Veeam Logoby Vitaliy S. » Wed Dec 04, 2013 3:39 pm 1 person likes this post

Dom,

Do you need to keep these snapshots on the SQL Server VMs or they are used by the backup job? If this is the case, then to make sure there are no snapshots at the time of SQL backup, I would use different schedule for VM backup and SQL jobs, plus I would set an alarm for the snapshot presence.

Thanks!
Vitaliy S.
Veeam Software
 
Posts: 19539
Liked: 1097 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: List of snapshots

Veeam Logoby felyjos » Wed Dec 04, 2013 3:57 pm

Vitaly,

Excellent tips, I will check them and also I read something about a possible exclusion of snapshots during SQL backup I need to read deeper also this path

Thanks,
Dom
felyjos
Expert
 
Posts: 285
Liked: 3 times
Joined: Wed Jun 08, 2011 5:46 pm
Full Name: Dominique DUCHEMIN

Re: List of snapshots

Veeam Logoby Vitaliy S. » Wed Dec 04, 2013 4:11 pm 1 person likes this post

You can exclude any database from VSS processing if you follow this procedure > viewtopic.php?f=24&t=18561&p=93611&hilit=registry+sql+vcenter#p93611

Hope this helps!
Vitaliy S.
Veeam Software
 
Posts: 19539
Liked: 1097 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: List of snapshots

Veeam Logoby felyjos » Wed Dec 04, 2013 7:59 pm

Vitaliy S. wrote:Dom,

Do you need to keep these snapshots on the SQL Server VMs or they are used by the backup job? If this is the case, then to make sure there are no snapshots at the time of SQL backup, I would use different schedule for VM backup and SQL jobs, plus I would set an alarm for the snapshot presence.

Thanks!


Vitaly,

Different schedule seems not options as Veeam Backup is using jobs with several VMs in it and I don't know when a particular VM will be backed up... some jobs are running from 8 pm to 2 am ... depending on the content of VMs.
SQL is running cycling backups every 2 or 4 hours but as a 24/7 shop I could not have a window of 6 or more hours to be out of the Veeam Backup.

Thanks,
Dom
felyjos
Expert
 
Posts: 285
Liked: 3 times
Joined: Wed Jun 08, 2011 5:46 pm
Full Name: Dominique DUCHEMIN

Re: List of snapshots

Veeam Logoby felyjos » Wed Dec 04, 2013 8:01 pm

Vitaliy S. wrote:You can exclude any database from VSS processing if you follow this procedure > viewtopic.php?f=24&t=18561&p=93611&hilit=registry+sql+vcenter#p93611

Hope this helps!


This does not help as I don't want to exclude any database(s) from the backup (SQL or VEeam Backup) I want to exclude the snapshot(s) which should not be here most of the time.... for several machines I noticed that snapshots are present as in previous tasks (Backup, Migration, ....etc..) the snapshot created has never been removed... the process was timing out before the removal step...

Thanks,
Dom
felyjos
Expert
 
Posts: 285
Liked: 3 times
Joined: Wed Jun 08, 2011 5:46 pm
Full Name: Dominique DUCHEMIN

Re: List of snapshots

Veeam Logoby Vitaliy S. » Thu Dec 05, 2013 1:59 pm 1 person likes this post

felyjos wrote:Different schedule seems not options as Veeam Backup is using jobs with several VMs in it and I don't know when a particular VM will be backed up... some jobs are running from 8 pm to 2 am ...

Do you use VM containers in the backup job or you have added VMs individually?
Vitaliy S.
Veeam Software
 
Posts: 19539
Liked: 1097 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: List of snapshots

Veeam Logoby felyjos » Thu Dec 05, 2013 2:10 pm

Vitaly,

We add VM Individually... Which type of container is available?

Thanks,
Dom
felyjos
Expert
 
Posts: 285
Liked: 3 times
Joined: Wed Jun 08, 2011 5:46 pm
Full Name: Dominique DUCHEMIN

Re: List of snapshots

Veeam Logoby Vitaliy S. » Thu Dec 05, 2013 2:15 pm 1 person likes this post

Well...if you add VMs individually, then you can control how they are going to be backed up by using up and down arrows, I think it should help you with the scheduling.
Vitaliy S.
Veeam Software
 
Posts: 19539
Liked: 1097 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: List of snapshots

Veeam Logoby felyjos » Thu Dec 05, 2013 2:24 pm

We have tried to manage the schedule using the arrangement but some VMs are backed up in 10-15 minutes one day then the next day it is 45 minutes so our window get overlapped....
so a job could run in 2 hours one day and 4 the next day !!! not sure yet what is causing this change...
Now as we have 480 VMs backed up successfully it seems to be more "ontime" ...
Conflicts seen during the veeam backup are:
- I/O is frozen on database - SQL 2005
- failures due to existing snapshots

Still checking what is going on ...

Thanks,
Dom
felyjos
Expert
 
Posts: 285
Liked: 3 times
Joined: Wed Jun 08, 2011 5:46 pm
Full Name: Dominique DUCHEMIN

Re: List of snapshots

Veeam Logoby Vitaliy S. » Thu Dec 05, 2013 2:55 pm

Ok, please keep us updated on your findings. Maybe Windows event log will give more insight into this.
Vitaliy S.
Veeam Software
 
Posts: 19539
Liked: 1097 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov


Return to Reporting



Who is online

Users browsing this forum: No registered users and 2 guests