-
- VP, Product Management
- Posts: 27347
- Liked: 2785 times
- Joined: Mar 30, 2009 9:13 am
- Full Name: Vitaliy Safarov
- Contact:
Re: What is the best way of protecting the Veeam Backup serv
Hi Sven,
Backup job does not exclude any databases from the VM image. Do you say that you can't find Veeam backup database when you do FLR or restore the entire VM image?
Thanks!
Backup job does not exclude any databases from the VM image. Do you say that you can't find Veeam backup database when you do FLR or restore the entire VM image?
Thanks!
-
- Influencer
- Posts: 10
- Liked: 1 time
- Joined: Dec 12, 2014 11:07 am
- Full Name: Maygyver
- Contact:
Re: What is the best way of protecting the Veeam Backup serv
Hi,
I am checking backup status of every MSSQL database through a check_mk mssql.vbs skript.
Every database is getting the status of being backed up. But the "veeam backup" database not.
Sven
I am checking backup status of every MSSQL database through a check_mk mssql.vbs skript.
Every database is getting the status of being backed up. But the "veeam backup" database not.
Sven
Code: Select all
' Loop all databases to get the date of the last backup. Only show databases
' which have at least one backup
Dim lastBackupDate
addOutput( "<<<mssql_backup>>>" )
For Each dbName in dbNames.Keys
RS.open "SELECT CONVERT(VARCHAR, DATEADD(s, DATEDIFF(s, '19700101', MAX(backup_finish_date)), '19700101'), 120) AS last_backup_date " & _
"FROM msdb.dbo.backupset " & _
"WHERE database_name = '" & dbName & "'", CONN
Do While Not RS.Eof
lastBackupDate = Trim(RS("last_backup_date"))
If lastBackupDate <> "" Then
addOutput( instId & " " & Replace(dbName, " ", "_") & " " & lastBackupDate )
End If
RS.MoveNext
Loop
RS.Close
Next
Code: Select all
<<<mssql_backup>>>^M
MSSQL_VEEAMSQL2008R2 master 2015-03-22 22:10:33^M
MSSQL_VEEAMSQL2008R2 model 2015-03-22 22:10:33^M
MSSQL_VEEAMSQL2008R2 msdb 2015-03-22 22:10:33^M
MSSQL_VEEAMSQL2008R2 VeeamBackup 2015-01-14 22:26:17^M
MSSQL_VEEAMSQL2008R2 VeeamBackupReporting 2015-03-22 22:10:33^M
-
- Product Manager
- Posts: 20368
- Liked: 2288 times
- Joined: Oct 26, 2012 3:28 pm
- Full Name: Vladimir Eremin
- Contact:
Re: What is the best way of protecting the Veeam Backup serv
The Veeam database is skipped by default. Please, utilize configuration backup in order to protect VB&R db. Thanks.
-
- Influencer
- Posts: 10
- Liked: 1 time
- Joined: Dec 12, 2014 11:07 am
- Full Name: Maygyver
- Contact:
Re: What is the best way of protecting the Veeam Backup serv
Thanks for Info. Good to know the default Skip.
-
- Influencer
- Posts: 13
- Liked: never
- Joined: Mar 03, 2015 7:16 am
- Full Name: Marcelo Bordon
- Contact:
[MERGED] Veeam as own VM / how to replicate
Hello at all,
we are planing a virtual enviroment with VMware and two VMs + one VM (Windows Server 2012) as Veeam B&R-Server.
To Backup the configuration, there are an Option "Backup configuration" and it sounds good to backup the veeam properties.
But what is the best practise to replicate the Veeam-VM when the ESXi-Hosts is down?
Greetings
Mabordo
we are planing a virtual enviroment with VMware and two VMs + one VM (Windows Server 2012) as Veeam B&R-Server.
To Backup the configuration, there are an Option "Backup configuration" and it sounds good to backup the veeam properties.
But what is the best practise to replicate the Veeam-VM when the ESXi-Hosts is down?
Greetings
Mabordo
-
- Veeam Software
- Posts: 21133
- Liked: 2140 times
- Joined: Jul 11, 2011 10:22 am
- Full Name: Alexander Fogelson
- Contact:
Re: What is the best way of protecting the Veeam Backup serv
Marcelo, I've merged your post into the corresponding discussion, you can find some considerations regarding Veeam B&R server replication above. It is a viable approach to protecting Veeam B&R, however, the best practice, as you've noted, is to backup Veeam B&R configuration.
-
- Veteran
- Posts: 290
- Liked: 25 times
- Joined: Mar 23, 2015 8:30 am
- Contact:
[MERGED] Replication for Veeam Backup server
Hi
I want to replicate my Veeam backup Server within my site. Reason is the following: We have two datacenters with a layer two connection between. All our VMware clusters are spread over these datacenters. Half of the ESXi Servers from a Cluster in site A and the other half in site B.
I plan to install a virtual veeam backup Server and different veeam proxy Servers. The veeam backup server should run on a single ESXi host in site A with local disks. The VMware vCenter Server also runs on this single ESXi host. What I want now, it to replicate both VM's to another single ESXi Server in site B. My question now is: is it possible to replicate the veeam backup Server in this manner with veeam replication? I want to be able to bring online vcenter Server and veeam backup Server as fast as possible if site A Fails. Reason to not run vcenter Server and veeam backup Server on a "normal" ESXi Cluster is because I want to be completely independent from any other infrastructure compontens like shared storage etc... for this two machines.
thx and regards
sandsturm
I want to replicate my Veeam backup Server within my site. Reason is the following: We have two datacenters with a layer two connection between. All our VMware clusters are spread over these datacenters. Half of the ESXi Servers from a Cluster in site A and the other half in site B.
I plan to install a virtual veeam backup Server and different veeam proxy Servers. The veeam backup server should run on a single ESXi host in site A with local disks. The VMware vCenter Server also runs on this single ESXi host. What I want now, it to replicate both VM's to another single ESXi Server in site B. My question now is: is it possible to replicate the veeam backup Server in this manner with veeam replication? I want to be able to bring online vcenter Server and veeam backup Server as fast as possible if site A Fails. Reason to not run vcenter Server and veeam backup Server on a "normal" ESXi Cluster is because I want to be completely independent from any other infrastructure compontens like shared storage etc... for this two machines.
thx and regards
sandsturm
-
- Veeam Software
- Posts: 21133
- Liked: 2140 times
- Joined: Jul 11, 2011 10:22 am
- Full Name: Alexander Fogelson
- Contact:
Re: What is the best way of protecting the Veeam Backup serv
Definitely, it is possible. Some of the implications of replicating Veeam B&R backup server are discussed in this thread, as well as other ways of protecting it, among which backup of Veeam B&R configuration is the most commonly recommended approach.
-
- Veteran
- Posts: 290
- Liked: 25 times
- Joined: Mar 23, 2015 8:30 am
- Contact:
Re: What is the best way of protecting the Veeam Backup serv
Thanks for the fast answer. I now that backup of veeam B&R configuration is the common Approach. But then I have to install a new Server, install B&R and restore the config. I want to have a faster recovery solution, so I thougth about replicating the virtual machine. If I choose "Application Aware processing" for my replication Job for the B&R Server, do I have then a consistent backup of the b&R database or not (in V8)?
If in my Scenario Site A fails and I have to start the replicated B&R Server in site B. Am I able to start this Server in site B without having B&R running?
thx
sandsturm
If in my Scenario Site A fails and I have to start the replicated B&R Server in site B. Am I able to start this Server in site B without having B&R running?
thx
sandsturm
-
- Veeam Software
- Posts: 21133
- Liked: 2140 times
- Joined: Jul 11, 2011 10:22 am
- Full Name: Alexander Fogelson
- Contact:
Re: What is the best way of protecting the Veeam Backup serv
The fastest recovery solution would be to have Veeam B&R instance responsible for replication jobs in the target site. That will allow for automated failover/failback operations right from its UI.
Veeam B&R database is automatically excluded from VSS processing, so replica will have database in crash-consistent state. However, even large dynamic SQL databases are typically ok with that and able to recover fine in 99% of cases.sandsturm wrote:If I choose "Application Aware processing" for my replication Job for the B&R Server, do I have then a consistent backup of the b&R database or not (in V8)?
Yes, you can manually start replica VM from vSphere Client.sandsturm wrote:If in my Scenario Site A fails and I have to start the replicated B&R Server in site B. Am I able to start this Server in site B without having B&R running?
-
- Veteran
- Posts: 290
- Liked: 25 times
- Joined: Mar 23, 2015 8:30 am
- Contact:
Re: What is the best way of protecting the Veeam Backup serv
The idea with a Veeam B&R instance in the second datacenter sounds quite nice. Do I understand you right to do it the following manner:
- Function of Veeam B&R (Server A) in site A: Backup to local disk for Backups of vCenter Server and other Management Servers
- Function of Veeam B&R (Server B) in site B: Replicationjob configured for Server A with the replica metadata on a local Repository (Server B local)
- no backup of the Server A on Server A or do I need a local backup of this Server also?
Is this a feasible solution?
- Function of Veeam B&R (Server A) in site A: Backup to local disk for Backups of vCenter Server and other Management Servers
- Function of Veeam B&R (Server B) in site B: Replicationjob configured for Server A with the replica metadata on a local Repository (Server B local)
- no backup of the Server A on Server A or do I need a local backup of this Server also?
Is this a feasible solution?
-
- Product Manager
- Posts: 20368
- Liked: 2288 times
- Joined: Oct 26, 2012 3:28 pm
- Full Name: Vladimir Eremin
- Contact:
Re: What is the best way of protecting the Veeam Backup serv
The metadata data should be stored at the repository residing on source site (A).- Function of Veeam B&R (Server B) in site B: Replicationjob configured for Server A with the replica metadata on a local Repository (Server B local)
Configuration backup should be enough.- no backup of the Server A on Server A or do I need a local backup of this Server also?
-
- Lurker
- Posts: 2
- Liked: never
- Joined: Sep 07, 2012 1:08 am
- Full Name: Ryan Huts
- Contact:
Re: What is the best way of protecting the Veeam Backup serv
Just wondering if it would be possible (or supported) to run Veeam Endpoint Backup on the Veeam Backup Server (running as a VM)?
At the moment we run the configuration backup, but just thinking if we had an endpoint backup of the machine (just stored on a NAS or other non-backup repository storage) it would make restoring the machine quicker than the current plan of installing os, updating os, configuring os, installing veeam, restoring veeam config.
At the moment we run the configuration backup, but just thinking if we had an endpoint backup of the machine (just stored on a NAS or other non-backup repository storage) it would make restoring the machine quicker than the current plan of installing os, updating os, configuring os, installing veeam, restoring veeam config.
-
- Veteran
- Posts: 7328
- Liked: 781 times
- Joined: May 21, 2014 11:03 am
- Full Name: Nikita Shestakov
- Location: Prague
- Contact:
Re: What is the best way of protecting the Veeam Backup serv
Ryan,
Yes, you can backup virtual machines with Endpoint as well.
VBR also can backup/replicate itself. Though, please be aware that if this machine is also used as a default virtual proxy, CBT will not be utilized.
Thanks!
Yes, you can backup virtual machines with Endpoint as well.
VBR also can backup/replicate itself. Though, please be aware that if this machine is also used as a default virtual proxy, CBT will not be utilized.
Thanks!
-
- Veteran
- Posts: 338
- Liked: 35 times
- Joined: Jan 20, 2012 2:36 pm
- Full Name: Christensen Farms
- Contact:
[MERGED] Backup of physical VEEAM server itself
I'm sure this is discussed elsewhere, but I can't find it in the forums. We have VEEAM B&R running on a physical server. What is the best method to back this server up? We don't have any other backup programs. Do some use the free VEEAM backup endpoint tool? I know supposedly it's easy to reinstall VEEAM and reattach to the database, but believe me, it's not that easy and when you have a few other things on the server those are important to backup as well.
We just had a case where an HP update blue screened our VEEAM server and it really worried me.
We just had a case where an HP update blue screened our VEEAM server and it really worried me.
-
- Veeam Software
- Posts: 21133
- Liked: 2140 times
- Joined: Jul 11, 2011 10:22 am
- Full Name: Alexander Fogelson
- Contact:
Re: What is the best way of protecting the Veeam Backup serv
The recommended way of protecting Veeam B&R is using its built-in configuration backup functionality. However, if the server runs some other workloads, you can also use Veeam Endpoint Backup to protect it.
-
- Novice
- Posts: 4
- Liked: 1 time
- Joined: Jan 06, 2015 4:20 pm
- Full Name: Elaine den Hoed
- Contact:
Re: What is the best way of protecting the Veeam Backup serv
Question: We do a configuration backup. We have a separarte sql server Problem: Several servers are indexed during backup (these files are saved locally through veeam) - how will I "restore" those in case of disaster if I am not directly backing up my Veeam B&R server as Veeam suggests?
-
- Veteran
- Posts: 338
- Liked: 35 times
- Joined: Jan 20, 2012 2:36 pm
- Full Name: Christensen Farms
- Contact:
Re: What is the best way of protecting the Veeam Backup serv
Is there documentation on how to backup the VEEAM physical server with VEEAM Endpoint? Do I install the full VE on my VEEAM server?
-
- Enthusiast
- Posts: 50
- Liked: 3 times
- Joined: Aug 06, 2015 8:08 am
- Full Name: Andy C
- Contact:
Re: What is the best way of protecting the Veeam Backup serv
Dont know if this has been mentioned before but hey ho (12 pages of posts to check ) but im my dev platform i simply backed up the Veeam virtual server as a separate task (self backup to the cloud connect) once all other backup tasks are completed to ensure that database is the most up to date for consistancy. This is not ideal as it takes up more space in the repository for each instance/customer but in a DR scenario you can bring the Veeam server back and then your good to go. Ideally an off-site copy would be best like cloud connect repo but a DR site would be just as good. This means the extra SQL maintenance plan management is not required and is easier to restore than rebuilding the setup and recovering the DB which of course there is a chance it does not come back properly.
Of course this only works if the SQL database and stores of the config files are local to itself and not on an independent share.
I have feature requested this and hopefully it will come in v9
Andy
Of course this only works if the SQL database and stores of the config files are local to itself and not on an independent share.
I have feature requested this and hopefully it will come in v9
Andy
-
- VP, Product Management
- Posts: 27347
- Liked: 2785 times
- Joined: Mar 30, 2009 9:13 am
- Full Name: Vitaliy Safarov
- Contact:
Re: What is the best way of protecting the Veeam Backup serv
If you're referring to indexing data (stored in the catalog) recovery, then please review this topic (including subtopic), it should answer your question > Basic Backup catalog questionslarimerE wrote:Question: We do a configuration backup. We have a separarte sql server Problem: Several servers are indexed during backup (these files are saved locally through veeam) - how will I "restore" those in case of disaster if I am not directly backing up my Veeam B&R server as Veeam suggests?
Not sure that I understand what you mean by saying "full VE", but if you want to protect VBR server with Veeam Endpoint Backup, just install VEB and configure backup job to do full image backups. You can point your backup job to any supported designation target, for example a CIFS share.cffit wrote:Is there documentation on how to backup the VEEAM physical server with VEEAM Endpoint? Do I install the full VE on my VEEAM server?
Yes, this could be another option of protecting your backup server.cupplesey wrote:Dont know if this has been mentioned before but hey ho (12 pages of posts to check ) but im my dev platform i simply backed up the Veeam virtual server as a separate task (self backup to the cloud connect) once all other backup tasks are completed to ensure that database is the most up to date for consistancy. This is not ideal as it takes up more space in the repository for each instance/customer but in a DR scenario you can bring the Veeam server back and then your good to go. Ideally an off-site copy would be best like cloud connect repo but a DR site would be just as good. This means the extra SQL maintenance plan management is not required and is easier to restore than rebuilding the setup and recovering the DB which of course there is a chance it does not come back properly.
-
- Veteran
- Posts: 338
- Liked: 35 times
- Joined: Jan 20, 2012 2:36 pm
- Full Name: Christensen Farms
- Contact:
Re: What is the best way of protecting the Veeam Backup serv
So just to be clear, it is supported to have both VEEAM B&R and VEEAM Endpoint Backup on the same server?
-
- Product Manager
- Posts: 6550
- Liked: 765 times
- Joined: May 19, 2015 1:46 pm
- Contact:
Re: What is the best way of protecting the Veeam Backup serv
Hi,
Thank you.
Yes, it is supported. From VEB's perspective VBR server is a "yet-another-mssql-machine" thus it can be backed up like any other one with no problem. As a sidenote: if you are interested in how Endpoint deals with mssql, then please take a look at this thread and this guide..So just to be clear, it is supported to have both VEEAM B&R and VEEAM Endpoint Backup on the same server?
Thank you.
-
- VP, Product Management
- Posts: 27347
- Liked: 2785 times
- Joined: Mar 30, 2009 9:13 am
- Full Name: Vitaliy Safarov
- Contact:
-
- Expert
- Posts: 152
- Liked: 24 times
- Joined: May 16, 2011 4:00 am
- Full Name: Alex Macaronis
- Location: Brisbane, Australia
- Contact:
Re: What is the best way of protecting the Veeam Backup serv
I didnt think this warranted its own thread...
Does Veeam support its DB being stored in an AlwaysOn Availabilty Group?
Does Veeam support its DB being stored in an AlwaysOn Availabilty Group?
-
- Veeam Software
- Posts: 21133
- Liked: 2140 times
- Joined: Jul 11, 2011 10:22 am
- Full Name: Alexander Fogelson
- Contact:
Re: What is the best way of protecting the Veeam Backup serv
Yes, should not be any issues with that.
-
- Influencer
- Posts: 15
- Liked: never
- Joined: Jan 25, 2016 4:53 pm
- Full Name: John Kenny
- Contact:
[MERGED] : Protect Veeam B&R V9
What should i be using for Disaster Recovery in Veeam B&R V9? What im thinking of is what i would use to restore data if the main site was a total loss.
We came from Symantec Backup Exec and in that we had a DR iso to boot with, what is the Veeam equivelent? Do i need to setup an off site replica for DR?
Thanks
JK
We came from Symantec Backup Exec and in that we had a DR iso to boot with, what is the Veeam equivelent? Do i need to setup an off site replica for DR?
Thanks
JK
-
- Expert
- Posts: 123
- Liked: 16 times
- Joined: Aug 28, 2013 9:46 am
- Full Name: Thomas Braun
- Location: Germany.Europe.Terra.Sol.Milkyway.Localgroup.Virgo
- Contact:
Re: Veeam B&R V9 What should i use for DR ie Backup server l
I use "Veeam endpoint backup" to backup the backup server (wow... that many "backup" in one short sentence )
-
- Product Manager
- Posts: 5788
- Liked: 1214 times
- Joined: Jul 15, 2013 11:09 am
- Full Name: Niels Engelen
- Contact:
Re: Veeam B&R V9 What should i use for DR ie Backup server l
Have a look at the thread you've been merged to - a lot of options are posted here. If you can use replication it is probably the fastest way to get it back however.
Personal blog: https://foonet.be
GitHub: https://github.com/nielsengelen
GitHub: https://github.com/nielsengelen
-
- Novice
- Posts: 7
- Liked: never
- Joined: Feb 03, 2016 3:59 pm
- Full Name: Sylvain ARNAUD
- Contact:
Re: What is the best way of protecting the Veeam Backup serv
Hello,
Is it possible with the same license to have the Veeam Backup server in SiteA, and a second Veeam server acting as the Replication server in SiteB so that it is immediately available in case of a SiteA disaster to orchestrate the startup of replicated SiteA's VMs in SiteB ?
Thanks,
Sylvain
Is it possible with the same license to have the Veeam Backup server in SiteA, and a second Veeam server acting as the Replication server in SiteB so that it is immediately available in case of a SiteA disaster to orchestrate the startup of replicated SiteA's VMs in SiteB ?
Thanks,
Sylvain
-
- Veeam Software
- Posts: 21133
- Liked: 2140 times
- Joined: Jul 11, 2011 10:22 am
- Full Name: Alexander Fogelson
- Contact:
Re: What is the best way of protecting the Veeam Backup serv
Yes, as long as the number of sockets on the hosts you're backing up/replicating VMs from does not exceed the number specified in the license. Consider using Enterprise Manager to have visibility across both backup servers.
Who is online
Users browsing this forum: Semrush [Bot] and 83 guests