Veeam Backup Server (Physical)

[DMermod]

Everyone,

I have been searching the forums and it's pretty hard to find keywords for what I'm looking for that don't bring back an abundant number of hits.

My question is this. What is the best way to backup and restore the physical Veeam Backup and Replication server?

Thank you,

- Denis R

[Gostev]

Hi Denis, all you really care to backup is SQL database (this is where all job configuration resides). One way is to point Veeam to use SQL running in VM (and backup this SQL VM), or some other managed SQL if you have one. Another way is to use simple scripted copy of Veeam configuration database files (Veeam DB is quite small). Thanks!

[DMermod]

Thank you Gostev,

I will look into some scripting for SQL backups. Can you confirm the restore process is just as easy? Either if I restore on the same server or a new server?

- Denis R

[foggy]

Yes, its pretty easy. You can search this forum for moving Veeam SQL for some tricks in the case when it is a new server. Thanks.

[Gostev]

This script may help as well

[pparks1]

The above script is exactly what I used in my environment, where my Veeam server is Physical.

I run a scheduled job every day which backups up the Veeam database.

Code: Select all

Set All=%date:~7,2%
Rem Use above to keep just 30 days


REM Echo %ALL%
SQLCMD -S DETVEEAM1\VEEAM -E -Q "BACKUP DATABASE VeeamBackup TO DISK='E:\database_backups\VeeamBackupdb_%All%.bak' WITH FORMAT"

The above gives me 30 days worth of SQL backup files in E:\database_backups. Each is named VeeamBackupdb_01.bak, then 02.bak, then 03.bak. After 30 days, it simply overwrites 1, 2 and 3 and so on. My database backup files are approx 4.5MB is size.

Then I run a job to backup my actual E:\backups folder (where my Veeam backups are stored)
Then I run a job to backup my actual E:\vbrcatalog file.


In the event that I lose everything,
--Reinstall the OS and the Veeam Software
--Install SQL Management Studio Express and restore the database from my latest backup
--Copy back the data into E:\backups and E:\vbrcatalog

Everything should be back.