Comprehensive data protection for all workloads
Post Reply
VanillaMastermind
Enthusiast
Posts: 37
Liked: 7 times
Joined: Nov 23, 2015 4:47 pm
Full Name: VanillaMastermind
Contact:

Best practices for database backup of Veeam Config database?

Post by VanillaMastermind »

I noticed that by default in B&R V9, there does not appear to be anything performing a backup of the Veeam configuration SQL Server database "VeeamBackup", or any of the SQL Server system databases on the same instance. Is it recommended to manually create a native SQL job to back these databases up? I was going to back these up to a network share, but I noticed that the the SQL Server service runs under "NT Authority\NetworkService", which wouldn't have access to a network share. If it is recommended to do a SQL level backup, is it safe to change the SQL Server service account to use the Veeam admin account so I can write to the network?
veremin
Product Manager
Posts: 20415
Liked: 2302 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Best practices for database backup of Veeam Config datab

Post by veremin »

Creating configuration backup regularly should be enough. Additional information regarding backup server protection can be found here. Thanks.
VanillaMastermind
Enthusiast
Posts: 37
Liked: 7 times
Joined: Nov 23, 2015 4:47 pm
Full Name: VanillaMastermind
Contact:

Re: Best practices for database backup of Veeam Config datab

Post by VanillaMastermind »

Without backing up the local SQL instance running the Veeam configuration, wouldn't we be in trouble if something happened to the SQL instance? Wouldn't I have problems trying to restore the native Veeam configuration backup if the SQL instance didn't work?
foggy
Veeam Software
Posts: 21139
Liked: 2141 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Best practices for database backup of Veeam Config datab

Post by foggy »

You can restore Veeam B&R configuration to any other SQL Server instance and proceed with backups/restores. Configuration backup contains all the required data.
VanillaMastermind
Enthusiast
Posts: 37
Liked: 7 times
Joined: Nov 23, 2015 4:47 pm
Full Name: VanillaMastermind
Contact:

Re: Best practices for database backup of Veeam Config datab

Post by VanillaMastermind »

foggy wrote:You can restore Veeam B&R configuration to any other SQL Server instance and proceed with backups/restores. Configuration backup contains all the required data.
Great! I didn't realize that and thought Veeam required a local instance. Thanks!
veremin
Product Manager
Posts: 20415
Liked: 2302 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Best practices for database backup of Veeam Config datab

Post by veremin »

Correct, the detailed description of both restore and migration procedures can be found here. Thanks.
Post Reply

Who is online

Users browsing this forum: Google [Bot] and 91 guests